Attached is a spreadsheet I have developed for the upcoming FRC competition. It is designed for a team of six (preferably seven) statisticians to record and analyze data taken from the games during competition in order to select more effective alliance partners. The spreadsheet can work for up to 500 teams and 300 rounds at a time, before the data must be wiped, resetting the spreadsheet.
To record statistics, you will need an Ethernet hub and enough copies of Microsoft Excel, and share the spreadsheet from one computer to the others through this Ethernet hub. While it should work on older systems, I have only tested this program using Excel 2013 and Windows 8, so I cannot guarantee that older versions will work effectively. If you need any help, or have any suggestions as to how I can improve the program, please let me know at
djowen777@hotmail.com.
Thank you,
Dakota Owen