I wrote this sheet for scouting at CA State Championships Pomona last year. There was no wifi at the event, so we wound up downloading it as an excel sheet and filling it out off line, but it worked pretty well, better than our robots did that day unfortunately, haha. Anyway, the way it works is that each team in an event is given their own sheet, then all of the individual sheets fill in the main. Each sheet contains the same categories as the main, and are scored on a scale of 1-5, 5 being best. Then, in the main you can sort by any category, or by “overall” which is just a simple function I wrote that takes all of the categories into account.
This was of course written for In The Zone, so the categories don’t all make sense for this game, but it could still be used as a template. The nice thing about using Sheets is you could have a scout at each field and have them share the Sheet. That way the sheet automatically is up to date for all fields.