Here is a link to the template.
Some of the features of this program include:
- Live-tracking of cumulative bonus conversion.
- Live-tracking of each player’s powers, gets, negs, and points per game.
- Advanced category statistics showing bonus conversion broken down by category.
- The percentage of available points earned in each category.
- Detailed individual category statistics for each round and across the entire tournament.
- Displaying the category split (how many tossups your team answered correctly versus how many tossups your opponent answered correctly) for each round and across the entire tournament.
- Integrated score tracker for each match.
Coincidentally, I’m making this post at the same time a discussion of online scoresheets is taking place. I’d like to make it clear that this template is not intended to be used by moderators or tournament organizers to track statistics for multiple teams.
Another note I’d like to make is that the version of the template linked above should be considered an alpha version of what will hopefully eventually be a fully-polished, optimally user-friendly tool. In the future, in addition to addressing the bugs reported by early users, I plan on releasing a version of the template with more than the 15 rounds currently supported. I hope to have this completed before state and national championships are hosted, since these tournaments frequently involve more rounds than the typical local event.
Currently, this template does not fully support half-packet rounds. As such, individual and team points per game statistics will be inaccurate if one of the games included was played with fewer tossups than the other games. Also, the overall statistics tracked by this template are calculated as “per game” statistics, not “per 20 tossups heard” statistics. Future versions of this template geared towards nationals tournaments may switch to “per 20 tossups heard” statistic tracking.
I have included more instructions for using this template in the Google Sheet itself.
I’ve created a Google form for collecting bug reports, questions, and recommendations.