Using google documents to scout?

[dcarr]

Originally Posted by sanddrag

Google spreadsheet is really nice for Pivot Tables, which are incredibly useful. For connectivity, we used Clear 4G Wimax into a Cradlepoint CTR35 Router.

How does that work...aren't WiFi access points prohibited?

[sanddrag]

Originally Posted by dcarr

How does that work...aren't WiFi access points prohibited?

Not Wifi. WiMax. Different frequency. And that's only for the internet connection. Locally, we run strictly wired networks. No wifi is enabled on any device.

[dcarr]

Originally Posted by sanddrag

Not Wifi. WiMax. Different frequency. And that's only for the internet connection. Locally, we run strictly wired networks. No wifi is enabled on any device.

I got that part. I thought you were making a WiFi access point from your WiMax connection (but now I realize you must be running all Ethernet from that router).

One cool feature I've learned about DD-WRT - I have an Asus router at home with USB ports, and it allows you to use those to share the connection from a USB 4G device. Potentially opens up a lot of options in terms of '4G routers.'

[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.