Quote:
Originally Posted by Chadfrom308
I made this really advanced google docs scouting sheet
Here is how it worked:
1. The scouter filled out a little form on google
2. The form automatically sends the data to a google spreadsheet
a. One page in the spreadsheet is for the raw data
b. one is for the data that is sorted by teams and averaged
c. one is for the interface that we can use for graphs
3.The spreadsheet automatically sorts all the information and makes it easy for me or whoever is looking through it to see all the matches and trends in near real-time
The only downfall to this is you need internet (which was solved by writing down the matches and giving it to somebody that did)
and you need people who want to scout (which we had like nobody) (it also doesnt help that you dont do well)
If anyone wants to know how I did it, just ask, its pretty simple
Here is a picture of the interface, which has been improved with graphs and individual results after that competition
http://imageshack.com/a/img834/186/k4qi.png
Please note that all the boxes had info at it at one time. The code somehow broke when I was copying it for another competition |
Team 696 used a similar Google Docs based scouting system for the 2012 and 2013 official seasons. Although simple and easy to use to create a system, it has MAJOR downsides.
1. Google's systems have crashed at every single competition. It seems like Google Spreadsheets can not handle the amount of formulas needed for any meaningful analysis. Because of this, we were not able to access our data for our Friday night scouting meetings.
2. Its SLOW. At the height of it's lag, it took around 30 minutes for data to be submitted. In addition, the sheets sometimes take forever to load.
I warned a team going to Champs not to use a Google Docs system, and they faced similar results (for post-day analysis).
If not for these, Google Docs would be the perfect scouting solution. This summer, we created a scouting system running off our website that would be able to input data, analyze the data, create rankings and team reports, and create a match strategy printout that people would be able to send to a printer in the pits. We successfully collaborated with 3476 and 3255 and used the system at IRI, Battle at the Border, and Fall Classic.