November 13, 2019 update:
I’m releasing a master copy of an answer spreadsheet on Google Sheets. There are various versions floating around since ~2015 because I never created a master copy available to the public (sorry! – don’t know why I failed to do that). This master copy supersedes any existing spreadsheets as a template for new tournaments, and integrates some clever work by JinAh Kim for deadlines and packet submission. (If you want help porting any features to an existing spreadsheet, which would mainly be the timeline, please contact me.)
To use the master copy, simply go to File > Make a Copy and create a copy for your own use. There is an extensive README included in the file. You may have to close and re-open the file (and wait a few seconds) for the “Format Count” menu to pop-up. You’ll also have to go through some onerous screens to authorize it since it isn’t verified by Google or anything like that.
The following text is 5 years old, and is essentially deprecated. I’ve kept it in case someone needs to use the simply tally options, or wants to include the script in their own answer sheet:
If you have questions that can't be answered by the answer spreadsheet or reading the script, this is the thread for them.Cody wrote: ↑Thu Oct 30, 2014 4:34 pmAn example answer sheet you can look at (make a copy if you want to test it), as well as an image of the named ranges used for the "Claims & Written" option. You can use the script in any spreadsheet created in the new version of Google Sheets by going to Tools > Script Editor; Create Blank Project; paste raw script. You will have to either run onOpen or close and reload the spreadsheet before the "Format Count" menu will pop up; you then have to give the script authorization to access Drive the first time you run it in a spreadsheet.
In brief, it works as follows:
- You create a named range (default: "answers") that covers your entire answer space.
- If all you want to do is count the number of bolded / italicized / struck-through / background colored cells, use one of the first four options and define a 1-cell named range (default: "tally") where the total number of written questions can be placed. These options are very primitive and you'll have to do any extensions (TU vs. B) yourself. See the Color: Hex Pairs sheet in the above spreadsheet for hex codes for background color purposes. There is no required formatting of your spreadsheet.
- If you want to use "Claims & Written", read the stuff at the top of the script and format your spreadsheet as the linked spreadsheet is formatted. If there's enough interest in a different answer sheet layout (sp. bonuses under tossups instead of next to), it'd be fairly easy to implement. Claims are represented by a cell w/ a background color; bold indicates a written question.