I would rethink some of your pit scouting.
- If they can score gears, you will know from the match.
- If they shoot, you'll see where and when from the match.
- Accuracy, match.
- Climb the rope, match.
Use pit scouting for things that cannot be observed from the match. You'll get some inaccurate data from pit scouting and also waste the time of your scouts and the people in the pits you are going to.
EDIT: Also, I just noticed, on the match scouting sheet, I noticed that you asked for the match score. This can be very easily obtained from the FRC Events API or The Blue Alliance API. If you're inputting data to a spreadsheet, you can automatically pull that data into the sheet.