Using google documents to scout?

[ctccromer]

So after playing around with forms on google documents, I'm 100% sold. It's like it's MADE for FRC scouting

A few questions:
1) If I send a form to someone, can they fill it out MULTIPLE times? (i.e. for each match) or do I have to send it to everyone before each match?
EDIT: Found out, yes they CAN fill it out more than once.
2) Is there any way to split the results up by a certain result? Like instead of one giant spreadsheet, is there a way to make it turn into a spreadsheet for each FRC team?
3) Is there any way to change the theme/background? The defaults are okay but I think it'd be cool to put our team logo on there

Thanks to everyone for the help! I'm very excited now

[saikiranra]

Originally Posted by ctccromer

2) Is there any way to split the results up by a certain result? Like instead of one giant spreadsheet, is there a way to make it turn into a spreadsheet for each FRC team?
3) Is there any way to change the theme/background? The defaults are okay but I think it'd be cool to put our team logo on there

There are ways of splitting results, you need to use pivot tables or/and some semi-complicated equation like things. Making a sheet for every team is do-able, but we decided against it last year, because we attend the LA Regional, with over 60 teams.

I don't believe that you can change the back ground. We found the default easy to work with and we organized the rows by light blue and light red (for the different teams).

As for forms, we have had trouble last year using it. It worked perfectly before the competition, but they submitted too slowly and sometime did not submit at all. They might have fixed it since, but manually inputting the data works well too.

Again, Google Docs is one of the best things to scout with. It is so easy to use and it allows all teams to have the potential to make a great scouting system.