Folks, for this past week, I've been working on an automated scoring system to help everyone out.
Leveraging the power of pivot tables and a little bit of scripting, the end result is available by
clicking here.
Just some of the sheets:
"ScoreTotal" - Total scores for all teams.
"ScoreByEvent" - Score breakdown for all FF teams by the event.
"ScoreByWeek" - Score breakdown for all FF teams by the competition week.
"Raw Picks" - All picks and points for each FF teams.
The rest of the sheets hold raw data, roll ups, and other information needed to power the autoscoring.
As of right now, this thing will (should) score regionals and districts and keep it up as the season goes on.
If there are any questions/suggestions I can field them here. Additionally, if you poke around and find any errors, let me know and I'll get them ironed out as soon as possible.
Thanks,
- Sunny G.
Edit: As a note, the scoring isn't real-time. The processing for gathering data can be manually kicked off.