Hey Olivia,
My team (FRC 2485) used a HTML web form that put data directly onto a spreadsheet on Google Drive. Data is weighted such that more recent matches count more towards a team's average stats. We have some documentation and a download at the following link, as well as instructions on how to set it up for yourself.
https://drive.google.com/folderview?id=0BzF5AKL9TStqdGhCWTF0NzBNWnM&usp=sha ring
Pros -- Multiple people are able to view/edit the data simultaneously, meaning it is quicker to create and allows every person at the Friday night meeting to look up teams on their own. It also allows someone on the drive team to have access to the data at all times, updated pretty quickly after scout submissions.
Google sheets also allows you to interface easily with other things on the web. For example, in order to see what defenses were up each match, we used The Blue Alliance's API.
The HTML and JS of the web form is easily editable on the fly, just copy-pasting and changing names to add more fields. The interface itself is also very extensible.
Cons -- A big con to this method is connecting to the internet. Cell phone data usage is a big deal over the course of a competition.
Another con is that Google limits the speed/size of each sheet. For this reason, our system this year needed to span several spreadsheets, all importing data from others, to prevent lag on the spreadsheet that looks up data caused by the spreadsheet that calculates it. This made the system pretty complex, but still manageable.
For the 2016-2017 season, our team is migrating to a Bluetooth-based system to collect data from scouts and send it to one person's computer, who will then send the data to Google Drive so that only one person needs a hotspot. This alleviates our problem of data usage. I'll make another reply here if that pans out.
Hoped I helped a bit.
All the best,
Troy