Excel quiz bowl scoresheets

Anything that's on topic but doesn't fit elsewhere, including related events that might be of interest to quizbowl players.
lchen
Wakka
Posts: 180
Joined: Wed Apr 02, 2008 8:11 pm
Location: Hunter, NYC
Contact:

Excel quiz bowl scoresheets

Post by lchen »

http://sites.google.com/site/hchsquizbo ... coresheets

Here are some Excel spreadsheets I wrote that can be used as quiz bowl scoresheets for mACF, NAQT, or PACE formatted games. They're good for practices or tournaments if your coach brings a laptop.

They do all the math automatically, and have error-detection for common mistakes such as typing 19 instead of 10, etc. They also have dynamic highlighting to make it easier to see which tossups went dead, or if you accidentally skipped a row when entering scores. The mACF version supports 15-point powers and a tiebreaker tossup.

I would appreciate any comments or feedback!
Lily Chen
Hunter '12, MIT '16
User avatar
Mechanical Beasts
Banned Cheater
Posts: 5673
Joined: Thu Jun 08, 2006 10:50 pm

Re: Excel quiz bowl scoresheets

Post by Mechanical Beasts »

That's some pretty sexy Excel programming. Also, you know the word "kludge," so +10 to you.
Andrew Watkins
User avatar
Terrible Shorts Depot
Yuna
Posts: 760
Joined: Mon Mar 24, 2008 5:05 pm
Contact:

Re: Excel quiz bowl scoresheets

Post by Terrible Shorts Depot »

Hey Lily Chen,
You're pretty cool for making this.
Charlie Rosenthal
Shady Side Academy '09
Carleton College '13
University of Pennsylvania '18
User avatar
Maxwell Sniffingwell
Auron
Posts: 2163
Joined: Sun Feb 12, 2006 3:22 pm
Location: Des Moines, IA

Re: Excel quiz bowl scoresheets

Post by Maxwell Sniffingwell »

Nifty.
Greg Peterson

Northwestern University '18
Lawrence University '11
Maine South HS '07

"a decent player" - Mike Cheyne
David Riley
Auron
Posts: 1428
Joined: Tue Apr 29, 2003 8:27 am
Location: Morton Grove, IL

Re: Excel quiz bowl scoresheets

Post by David Riley »

Thanks!
David Riley
Coach Emeritus, Loyola Academy, Wilmette, Illinois, 1993-2010
Steering Committee, IHSSBCA, 1996 -
Member, PACE, 2012 -

"This is 1183, of course we're barbarians" -- Eleanor of Aquitaine in "The Lion in Winter"
Siverus Snape
Rikku
Posts: 251
Joined: Tue Dec 13, 2005 11:01 pm
Location: Rockford, IL
Contact:

Re: Excel quiz bowl scoresheets

Post by Siverus Snape »

This is pretty cool stuff. One thing I noticed while I was playing around with it: at least on the mACF scoresheet (the only one I've looked at) if the tossup goes dead and bonus points are still awarded to one team, the spreadsheet doesn't flag it.
Siva Sundaram, Rockford Auburn High School '09
User avatar
Captain Sinico
Auron
Posts: 2865
Joined: Sun Sep 21, 2003 1:46 pm
Location: Champaign, Illinois

Re: Excel quiz bowl scoresheets

Post by Captain Sinico »

I had everyone use these in practice and they are really excellent. Thanks!

MaS
Mike Sorice
Coach, Centennial High School of Champaign, IL (2014-2020) & Team Illinois (2016-2018)
Alumnus, Illinois ABT (2000-2002; 2003-2009) & Fenwick Scholastic Bowl (1999-2000)
Member, ACF (Emeritus), IHSSBCA, & PACE
User avatar
rjaguar3
Rikku
Posts: 278
Joined: Tue Dec 05, 2006 8:39 am

Re: Excel quiz bowl scoresheets

Post by rjaguar3 »

I've tinkered with the mACF to make it suitable for Illinois format. This supports 5-point tossups (blurt rule), 3-, 4-, and 5-part bonuses, bouncebacks, and a tiebreaker tossup+bonus. The file should be attached.
Attachments
Illinois scoresheet.zip
(12.37 KiB) Downloaded 657 times
Greg (Vanderbilt 2012, Wheaton North 2008)
lchen
Wakka
Posts: 180
Joined: Wed Apr 02, 2008 8:11 pm
Location: Hunter, NYC
Contact:

Re: Excel quiz bowl scoresheets

Post by lchen »

Thanks for the comments!
Siverus Snape wrote:if the tossup goes dead and bonus points are still awarded to one team, the spreadsheet doesn't flag it.
Thanks for catching that. I went back and redid the error detection, so it should work now. The new version is up on our team's website.
Lily Chen
Hunter '12, MIT '16
User avatar
dtaylor4
Auron
Posts: 3733
Joined: Tue Nov 16, 2004 11:43 am

Re: Excel quiz bowl scoresheets

Post by dtaylor4 »

As someone entering stats from such scoresheets, one suggestion:

Instead of having a ginormous box with total tossup points and small boxes for bonus points and BC, have three equally sized boxes for total tossups, bonus points, and BC. This way, the person entering stats can double-check for any entry errors.
User avatar
Ben Dillon
Rikku
Posts: 293
Joined: Thu Apr 28, 2005 10:47 pm
Location: South Bend, IN
Contact:

Re: Excel quiz bowl scoresheets

Post by Ben Dillon »

I used the NAQT scoresheet at a tournament today to display the scores for the two teams; they appreciated having it up there on the big screen.

There is a bug, though. For the right-hand team, the Question Total and Cumulative Score doesn't work. The Final Score displayed at the bottom is correct, but the running score isn't because the first question doesn't register correctly.
Ben Dillon, Saint Joseph HS

"Why, sometimes I've believed as many as
six impossible things before breakfast!"
User avatar
millionwaves
Auron
Posts: 1360
Joined: Sun Feb 25, 2007 12:35 pm
Location: Urbana, Illinois
Contact:

Re: Excel quiz bowl scoresheets

Post by millionwaves »

We pretty much ran IO using these today, and they worked fantastically. Thanks a ton for creating these, they're super useful.
Trygve Meade
Illinois, ACF

Above the Star-Apple Kingdom
User avatar
Maxwell Sniffingwell
Auron
Posts: 2163
Joined: Sun Feb 12, 2006 3:22 pm
Location: Des Moines, IA

Re: Excel quiz bowl scoresheets

Post by Maxwell Sniffingwell »

Tryg - did you run this and the questions all on the screen? How'd it work switching back and forth?

I think I'll be using these for the upcoming LU tournament.
Greg Peterson

Northwestern University '18
Lawrence University '11
Maine South HS '07

"a decent player" - Mike Cheyne
User avatar
Mike Bentley
Sin
Posts: 6113
Joined: Fri Mar 31, 2006 11:03 pm
Location: Bellevue, WA
Contact:

Re: Excel quiz bowl scoresheets

Post by Mike Bentley »

Creating some code to extract data from these spreadsheets and enter them into SQBS automatically might be something I look into doing in the future.
Mike Bentley
VP of Editing, Partnership for Academic Competition Excellence
Adviser, Quizbowl Team at University of Washington
University of Maryland, Class of 2008
User avatar
Ben Dillon
Rikku
Posts: 293
Joined: Thu Apr 28, 2005 10:47 pm
Location: South Bend, IN
Contact:

Re: Excel quiz bowl scoresheets

Post by Ben Dillon »

Thought of something else... Slimming down the columns so that they automatically fit on one 8.5 x 11 would be nice.
Ben Dillon, Saint Joseph HS

"Why, sometimes I've believed as many as
six impossible things before breakfast!"
johnnyfulcrum

Re: Excel quiz bowl scoresheets

Post by johnnyfulcrum »

.

User was permanently banned for being enok walker avoiding a previous ban.

IP address was banned for a month.
User avatar
AKKOLADE
Sin
Posts: 15588
Joined: Thu Apr 24, 2003 8:08 am

Re: Excel quiz bowl scoresheets

Post by AKKOLADE »

Go away, enok walker.
Fred Morlan
University of Kentucky CoP, 2017
International Quiz Bowl Tournaments, co-owner
PACE
former (?) hsqbrank manager, former NAQT writer & subject editor, former hsqb Administrator/Chief Administrator
lchen
Wakka
Posts: 180
Joined: Wed Apr 02, 2008 8:11 pm
Location: Hunter, NYC
Contact:

Re: Excel quiz bowl scoresheets

Post by lchen »

Hey, thanks for all the suggestions. I've put up an updated version with some bugfixes and minor aesthetic changes.

- fixed the bug in the NAQT version that displayed the cumulative scores incorrectly (Thanks, Ben.)
- slimmed down the columns so that they fit on one letter-sized sheet of paper (The answers/notes column would print on a second page, but you can just print the first page if you only want the scoresheet part.)
- made the bonus conversion cells larger
Lily Chen
Hunter '12, MIT '16
User avatar
Captain Sinico
Auron
Posts: 2865
Joined: Sun Sep 21, 2003 1:46 pm
Location: Champaign, Illinois

Re: Excel quiz bowl scoresheets

Post by Captain Sinico »

These are great and I want to thank you for making them; we put them to extensive and very successful use at Illinois Open this weekend. The one thing I'd request is that you add a column for the room the round was read in.

MaS
Mike Sorice
Coach, Centennial High School of Champaign, IL (2014-2020) & Team Illinois (2016-2018)
Alumnus, Illinois ABT (2000-2002; 2003-2009) & Fenwick Scholastic Bowl (1999-2000)
Member, ACF (Emeritus), IHSSBCA, & PACE
User avatar
Maxwell Sniffingwell
Auron
Posts: 2163
Joined: Sun Feb 12, 2006 3:22 pm
Location: Des Moines, IA

Re: Excel quiz bowl scoresheets

Post by Maxwell Sniffingwell »

Captain Scipio wrote:These are great and I want to thank you for making them; we put them to extensive and very successful use at Illinois Open this weekend. The one thing I'd request is that you add a column for the room the round was read in.

MaS
Mike - how did you get the scoresheets from moderator to stat room - did you have them copy down the important parts onto actual paper, send it over wireless, or something else?
Greg Peterson

Northwestern University '18
Lawrence University '11
Maine South HS '07

"a decent player" - Mike Cheyne
jonah
Auron
Posts: 2340
Joined: Thu Jul 20, 2006 5:51 pm
Location: Chicago

Re: Excel quiz bowl scoresheets

Post by jonah »

We emailed them to Donald.
Jonah Greenthal
National Academic Quiz Tournaments
lchen
Wakka
Posts: 180
Joined: Wed Apr 02, 2008 8:11 pm
Location: Hunter, NYC
Contact:

Re: Excel quiz bowl scoresheets

Post by lchen »

You're welcome! I'm glad people like them.
Captain Scipio wrote:The one thing I'd request is that you add a column for the room the round was read in.
That's a good idea. There will be a new version up shortly (2.46) with a cell for the room number.
cornfused wrote:how did you get the scoresheets from moderator to stat room - did you have them copy down the important parts onto actual paper, send it over wireless, or something else?
We considered using these for Prison Bowl 09 and one of the ideas was to have the moderators print them to a networked printer in the control room.
Lily Chen
Hunter '12, MIT '16
User avatar
Captain Sinico
Auron
Posts: 2865
Joined: Sun Sep 21, 2003 1:46 pm
Location: Champaign, Illinois

Re: Excel quiz bowl scoresheets

Post by Captain Sinico »

Hey,
Yeah, we have pretty ubiquitous, reliable wireless coverage, so we had people sent them by e-mail or over AIM/Google Talk/whatever (I opted for the latter.) Previously, we'd transmitted the relevant results from the paper scoring over e-mail or AIM, but this makes the transmission easier: the moderator doesn't even need to type the couple lines; just attach the file to whatever. I think the main benefit, though, it that it makes actually keeping score much, much easier and more idiot-proof.
I suppose if you lack internet connectivity, the sheets could be transferred on rotating memory sticks, or the stats needed for the reports (final score; q's heard; tu,neg, & q's hears for each player) just written down on paper or whatever with the electronic sheets saved for later records. Or I suppose one could even print the sheet and bring it to the stat room if one's got the printers... but that seems pretty impractical.

MaS
Mike Sorice
Coach, Centennial High School of Champaign, IL (2014-2020) & Team Illinois (2016-2018)
Alumnus, Illinois ABT (2000-2002; 2003-2009) & Fenwick Scholastic Bowl (1999-2000)
Member, ACF (Emeritus), IHSSBCA, & PACE
User avatar
Sir Thopas
Auron
Posts: 1330
Joined: Tue Mar 28, 2006 10:10 pm
Location: Hunter, NYC
Contact:

Re: Excel quiz bowl scoresheets

Post by Sir Thopas »

Also, Taft allows each moderator to input the stats locally, should the money be willing to be forked over.
Guy Tabachnick
Hunter '09
Brown '13

http://memoryofthisimpertinence.blogspot.com/
User avatar
BuzzerZen
Auron
Posts: 1517
Joined: Thu Nov 18, 2004 11:01 pm
Location: Arlington, VA/Hampshire College
Contact:

Re: Excel quiz bowl scoresheets

Post by BuzzerZen »

Sir Thopas wrote:should the money be willing to be forked over
You're seriously attributing propositional attitudes to money?
Evan Silberman
Hampshire College 07F

How are you actually reading one of my posts?
User avatar
Maxwell Sniffingwell
Auron
Posts: 2163
Joined: Sun Feb 12, 2006 3:22 pm
Location: Des Moines, IA

Re: Excel quiz bowl scoresheets

Post by Maxwell Sniffingwell »

This is great - we have no printer in the tournament building, but we DO have ubiquitous wireless access and plenty of laptops... so we're going to use Lily's program and email and physically bring my printer from my dorm room to the stat room.

No printer access, no problem - paperless tournament.
Greg Peterson

Northwestern University '18
Lawrence University '11
Maine South HS '07

"a decent player" - Mike Cheyne
User avatar
Sir Thopas
Auron
Posts: 1330
Joined: Tue Mar 28, 2006 10:10 pm
Location: Hunter, NYC
Contact:

Re: Excel quiz bowl scoresheets

Post by Sir Thopas »

BuzzerZen wrote:
Sir Thopas wrote:should the money be willing to be forked over
You're seriously attributing propositional attitudes to money?
It greases the palm, after all.
Guy Tabachnick
Hunter '09
Brown '13

http://memoryofthisimpertinence.blogspot.com/
User avatar
dtaylor4
Auron
Posts: 3733
Joined: Tue Nov 16, 2004 11:43 am

Re: Excel quiz bowl scoresheets

Post by dtaylor4 »

cornfused wrote:This is great - we have no printer in the tournament building, but we DO have ubiquitous wireless access and plenty of laptops... so we're going to use Lily's program and email and physically bring my printer from my dorm room to the stat room.

No printer access, no problem - paperless tournament.
Are you counting the paper used to print and post stats?

For IO, this is effectively what was done. In the middle of a round, I would email the next round, and readers would email me the excel file.
User avatar
Mike Bentley
Sin
Posts: 6113
Joined: Fri Mar 31, 2006 11:03 pm
Location: Bellevue, WA
Contact:

Re: Excel quiz bowl scoresheets

Post by Mike Bentley »

I would probably advise people relying on wireless to have a backup plan. Wireless, especially on campuses, is notoriously unrelaible. The backup plan could be as simple as "bring all the laptop physically to the room where scorekeeping is done and have people just read out the scores for the rounds", but if you don't have such a plan in place you'll likely waste a lot of time trying to scramble for flash drives, etc.
Mike Bentley
VP of Editing, Partnership for Academic Competition Excellence
Adviser, Quizbowl Team at University of Washington
University of Maryland, Class of 2008
User avatar
Captain Sinico
Auron
Posts: 2865
Joined: Sun Sep 21, 2003 1:46 pm
Location: Champaign, Illinois

Re: Excel quiz bowl scoresheets

Post by Captain Sinico »

Bentley Like Beckham wrote:...have a backup plan...
Bentley Like Beckham wrote:...have a backup plan...
Bentley Like Beckham wrote:...have a backup plan...
MaS

PS: Of course, your level of wireless reliability may vary, and so too the likelihood that your backup plan will need to come into play... but you can figure that out.
Mike Sorice
Coach, Centennial High School of Champaign, IL (2014-2020) & Team Illinois (2016-2018)
Alumnus, Illinois ABT (2000-2002; 2003-2009) & Fenwick Scholastic Bowl (1999-2000)
Member, ACF (Emeritus), IHSSBCA, & PACE
User avatar
Maxwell Sniffingwell
Auron
Posts: 2163
Joined: Sun Feb 12, 2006 3:22 pm
Location: Des Moines, IA

Re: Excel quiz bowl scoresheets

Post by Maxwell Sniffingwell »

We'll be hosting our tournament in Main Hall, the most dependable wireless spot on campus. But yeah, I'll have paper scoresheets available for in case that fails.

I think instead of emailing the questions, I will start the moderators out with the questions and then email the passwords - could anyone give me a quick rundown of how to password question files?
Greg Peterson

Northwestern University '18
Lawrence University '11
Maine South HS '07

"a decent player" - Mike Cheyne
User avatar
Maxwell Sniffingwell
Auron
Posts: 2163
Joined: Sun Feb 12, 2006 3:22 pm
Location: Des Moines, IA

Re: Excel quiz bowl scoresheets

Post by Maxwell Sniffingwell »

OK, I found Mike Bentley's program, but I suppose that means I need to make sure everybody has WinZip. Still, I should be fine.
Greg Peterson

Northwestern University '18
Lawrence University '11
Maine South HS '07

"a decent player" - Mike Cheyne
User avatar
Maxwell Sniffingwell
Auron
Posts: 2163
Joined: Sun Feb 12, 2006 3:22 pm
Location: Des Moines, IA

Re: Excel quiz bowl scoresheets

Post by Maxwell Sniffingwell »

Okay, how do I unzip .zip files when WinZip is no longer working (it refuses to work until I pay)?
Greg Peterson

Northwestern University '18
Lawrence University '11
Maine South HS '07

"a decent player" - Mike Cheyne
Red-necked Phalarope
Rikku
Posts: 463
Joined: Thu May 05, 2005 1:50 pm
Location: Columbus, OH
Contact:

Re: Excel quiz bowl scoresheets

Post by Red-necked Phalarope »

Brice Russ
East Forsyth '04
UNC '08
Ohio State '13
Siverus Snape
Rikku
Posts: 251
Joined: Tue Dec 13, 2005 11:01 pm
Location: Rockford, IL
Contact:

Re: Excel quiz bowl scoresheets

Post by Siverus Snape »

Much better, freer, and less bloated than WinRAR: http://www.7-zip.org/
Siva Sundaram, Rockford Auburn High School '09
Red-necked Phalarope
Rikku
Posts: 463
Joined: Thu May 05, 2005 1:50 pm
Location: Columbus, OH
Contact:

Re: Excel quiz bowl scoresheets

Post by Red-necked Phalarope »

Siverus Snape wrote:Much better, freer, and less bloated than WinRAR: http://www.7-zip.org/
They're making you pay for WinRAR now? I didn't even check. Yeah, go with 7-Zip.
Brice Russ
East Forsyth '04
UNC '08
Ohio State '13
User avatar
Matthew D
Yuna
Posts: 919
Joined: Sun Oct 23, 2005 9:52 pm
Location: Scenic Grant Alabama

Re: Excel quiz bowl scoresheets

Post by Matthew D »

Just wanted to say thanks for creating the spreadsheets.... it has cut down my practice scoresheet printing to nothing.. now I am attempting to figure out how to use it at my tournament in Jan
Matt Dennis
Coach DAR Quizbowl Team
powerplant
Wakka
Posts: 142
Joined: Mon Mar 26, 2007 5:21 pm
Location: Ohio

Re: Excel quiz bowl scoresheets

Post by powerplant »

So I tinkered with the PACE sheet and made one for the KAAC Quick Recall format. When a tossup is answered, the question below it turns blue, indicating that it was a bonus. If people have any questions about it or suggestions for how I can make it better, I'd love to hear them.

Link
Joseph Wells

Garfield Heights High School '08
Centre College 2008-2010
Tri-C 2010-2011
Ohio State 2011-
lchen
Wakka
Posts: 180
Joined: Wed Apr 02, 2008 8:11 pm
Location: Hunter, NYC
Contact:

Re: Excel quiz bowl scoresheets

Post by lchen »

I've updated the scoresheets to version 2.6, which now supports the new 2010 PACE format. In addition, I've added highlighting for stolen bonus points, and correct calculation of % bonus/steals for the PACE format. From now on, the spreadsheet for the old PACE format will no longer be maintained.
Lily Chen
Hunter '12, MIT '16
User avatar
First Chairman
Auron
Posts: 3875
Joined: Sat Apr 19, 2003 8:21 pm
Location: Fairfax VA
Contact:

Re: Excel quiz bowl scoresheets

Post by First Chairman »

lchen wrote:I've updated the scoresheets to version 2.6, which now supports the new 2010 PACE format. In addition, I've added highlighting for stolen bonus points, and correct calculation of % bonus/steals for the PACE format. From now on, the spreadsheet for the old PACE format will no longer be maintained.
I appreciate your efforts on this, Lily.
Emil Thomas Chuck, Ph.D.
Founder, PACE
Facebook junkie and unofficial advisor to aspiring health professionals in quiz bowl
---
Pimping Green Tea Ginger Ale (Canada Dry)
jonah
Auron
Posts: 2340
Joined: Thu Jul 20, 2006 5:51 pm
Location: Chicago

Re: Excel quiz bowl scoresheets

Post by jonah »

I hate to look a gift-Lily in the mouth, but is there any chance of making a version of the mACF sheet that supports bouncebacks? The NSC-format one doesn't work perfectly for this because it has powers worth 20 instead of 15. It would also be great for there to be a cell at the bottom displaying the total number of bounceback opportunities (number of tossups the opponent got minus the number of bonuses they thirtied) to save a little time when entering data into SQBS.
Jonah Greenthal
National Academic Quiz Tournaments
User avatar
Frater Taciturnus
Auron
Posts: 2463
Joined: Mon Dec 12, 2005 1:26 pm
Location: Richmond, VA

Re: Excel quiz bowl scoresheets

Post by Frater Taciturnus »

jonah wrote:I hate to look a gift-Lily in the mouth, but is there any chance of making a version of the mACF sheet that supports bouncebacks? The NSC-format one doesn't work perfectly for this because it has powers worth 20 instead of 15. It would also be great for there to be a cell at the bottom displaying the total number of bounceback opportunities (number of tossups the opponent got minus the number of bonuses they thirtied) to save a little time when entering data into SQBS.
Can't you just change the numbers?
George Berry
[email protected]
they/them/their(s)
--------------
J. Sargeant Reynolds CC 2008, 2009, 2014
Virginia Commonwealth 2010, 2011, 2012, 2013,
Douglas Freeman 2005, 2006, 2007
jonah
Auron
Posts: 2340
Joined: Thu Jul 20, 2006 5:51 pm
Location: Chicago

Re: Excel quiz bowl scoresheets

Post by jonah »

Frater Taciturnus wrote:
jonah wrote:I hate to look a gift-Lily in the mouth, but is there any chance of making a version of the mACF sheet that supports bouncebacks? The NSC-format one doesn't work perfectly for this because it has powers worth 20 instead of 15. It would also be great for there to be a cell at the bottom displaying the total number of bounceback opportunities (number of tossups the opponent got minus the number of bonuses they thirtied) to save a little time when entering data into SQBS.
Can't you just change the numbers?
Yes, but I thought other people might find the same thing useful, so it would be great if they were centrally distributed.

edit: Also, implementing the second thing I requested would require a lot of unraveling of the hidden columns (T-AF) that I don't understand at a glance, whereas Lily probably knows what they're doing pretty easily and would be able to do it much quicker.
Jonah Greenthal
National Academic Quiz Tournaments
lchen
Wakka
Posts: 180
Joined: Wed Apr 02, 2008 8:11 pm
Location: Hunter, NYC
Contact:

Re: Excel quiz bowl scoresheets

Post by lchen »

jonah wrote:I hate to look a gift-Lily in the mouth, but is there any chance of making a version of the mACF sheet that supports bouncebacks? The NSC-format one doesn't work perfectly for this because it has powers worth 20 instead of 15. It would also be great for there to be a cell at the bottom displaying the total number of bounceback opportunities (number of tossups the opponent got minus the number of bonuses they thirtied) to save a little time when entering data into SQBS.
Done and uploaded. I modified the NSC format spreadsheet to support 15s and -5s. I wasn't able to do the second thing; maybe I'll get around to it sometime later. Bouncebacks should be highlighted in blue, so it shouldn't be that much harder to just count them. There is a cell at the bottom that calculates the percentage of available bounceback points a team actually earns.
Lily Chen
Hunter '12, MIT '16
User avatar
Whiter Hydra
Auron
Posts: 1317
Joined: Tue Dec 04, 2007 8:46 pm
Location: Fairfax, VA
Contact:

Re: Excel quiz bowl scoresheets

Post by Whiter Hydra »

jonah wrote:It would also be great for there to be a cell at the bottom displaying the total number of bounceback opportunities (number of tossups the opponent got minus the number of bonuses they thirtied) to save a little time when entering data into SQBS.
Wouldn't they just be cells AA24 and AB24?
Harry White
TJHSST '09, Virginia Tech '13
VP of Technology, PACE
Owner of Tournament Database Search and Quizbowl Schedule Generator
Will run stats for food
jonah
Auron
Posts: 2340
Joined: Thu Jul 20, 2006 5:51 pm
Location: Chicago

Re: Excel quiz bowl scoresheets

Post by jonah »

The Gambler, the Nun, and the Radio wrote:
jonah wrote:It would also be great for there to be a cell at the bottom displaying the total number of bounceback opportunities (number of tossups the opponent got minus the number of bonuses they thirtied) to save a little time when entering data into SQBS.
Wouldn't they just be cells AA24 and AB24?
Nope. That appears to be the total number of rebounded points (also displayed at H30 and Q30), but isn't the number of opportunities.
Jonah Greenthal
National Academic Quiz Tournaments
User avatar
Whiter Hydra
Auron
Posts: 1317
Joined: Tue Dec 04, 2007 8:46 pm
Location: Fairfax, VA
Contact:

Re: Excel quiz bowl scoresheets

Post by Whiter Hydra »

jonah wrote:
The Gambler, the Nun, and the Radio wrote:
jonah wrote:It would also be great for there to be a cell at the bottom displaying the total number of bounceback opportunities (number of tossups the opponent got minus the number of bonuses they thirtied) to save a little time when entering data into SQBS.
Wouldn't they just be cells AA24 and AB24?
Nope. That appears to be the total number of rebounded points (also displayed at H30 and Q30), but isn't the number of opportunities.
That's rebounded points available, which if you divide by 10, is number of opportunities.
Harry White
TJHSST '09, Virginia Tech '13
VP of Technology, PACE
Owner of Tournament Database Search and Quizbowl Schedule Generator
Will run stats for food
User avatar
jonpin
Forums Staff: Moderator
Posts: 2195
Joined: Wed Feb 04, 2004 6:45 pm
Location: BCA NJ / WUSTL MO / Hackensack NJ

Re: Excel quiz bowl scoresheets

Post by jonpin »

Not to steal Lily's thunder, but last spring I designed several Excel '07 spreadsheets that serve this purpose. I hadn't really gotten a chance to continue development until recently (because they were saved on the school computers), but I now present these four versions of my spreadsheets for public consumption:
  • ACF: Strictly speaking, mACF. Supports powers and negs. Also used for most regular season NAQT tournaments (20 tossups with sudden death OT)
  • ACF bounceback: As above, but supports bouncebacks.
  • NAQT official: Supports powers, negs, games of up to 26 tossups, and 3-tossup overtimes.
  • PACE NSC: Supports 20-point powers and bouncebacks, as well as recording of 0-point wrong answers (no negs).
Both bounceback formats include a box at the bottom indicating how many bounceback opportunities there were (as well as a line in the footer telling the scorekeeper how to calculate it if keeping score on paper)

I believe these serve well under many situations:
1. You can print them out and use them as regular scoresheets. Everything is then pretty straight-forward.
2. You can distribute them to moderators electronically and they can use them on the computer, and then email the TD with the stat lines.
3. You can distribute them to moderators electronically and they can use them on the computer, and then print out a nice-looking scoresheet to bring to headquarters.

I find each of these options has benefits. The utility of option 3 may be the hardest to see, but as someone who has had to decipher incomprehensible handwriting of people who failed to add up scoresheets correctly, it was the choice I would've used at BCA's recent tournament, had I been able to guarantee computer access in each room. These scoresheets then give the option of planning to run a paperless tournament, but if the wireless network then crashes, you can print out each scoresheet, and you can also print out blanks for spectator/player/non-computer-using-scorekeeper.

When used on the computer, they perform several layers of error-checking. I invite/ask people to download these and play around with them to make sure all potential errors are caught (the exception being that awarding bonus points in the wrong column might not be flagged, simply because I think you're smart enough not to enter data in a solid black box).

Without further ado, here are my scoresheet spreadsheets. If you have any questions or spot any errors, just talk to me here, in IRC, or via email.
Attachments
NAQT official.xlsx
(22.66 KiB) Downloaded 588 times
ACF bounceback.xlsx
(21.35 KiB) Downloaded 511 times
ACF.xlsx
(21.29 KiB) Downloaded 521 times
Jon Pinyan
Coach, Bergen County Academies (NJ); former player for BCA (2000-03) and WUSTL (2003-07)
HSQB forum mod, PACE member
Stat director for: NSC '13-'15, '17; ACF '14, '17, '19; NHBB '13-'15; NASAT '11

"A [...] wizard who controls the weather" - Jerry Vinokurov
User avatar
jonpin
Forums Staff: Moderator
Posts: 2195
Joined: Wed Feb 04, 2004 6:45 pm
Location: BCA NJ / WUSTL MO / Hackensack NJ

Re: Excel quiz bowl scoresheets

Post by jonpin »

Here's the PACE NSC version, since I'm limited to 3 attachments per post
Attachments
PACE NSC.xlsx
(20.92 KiB) Downloaded 465 times
Jon Pinyan
Coach, Bergen County Academies (NJ); former player for BCA (2000-03) and WUSTL (2003-07)
HSQB forum mod, PACE member
Stat director for: NSC '13-'15, '17; ACF '14, '17, '19; NHBB '13-'15; NASAT '11

"A [...] wizard who controls the weather" - Jerry Vinokurov
User avatar
Down and out in Quintana Roo
Auron
Posts: 2907
Joined: Wed Apr 09, 2008 7:25 am
Location: Camden, DE
Contact:

Re: Excel quiz bowl scoresheets

Post by Down and out in Quintana Roo »

This is awesome. I plan on using these in practice more to help facilitate individual and (more importantly) PPB stats.
Mr. Andrew Chrzanowski
Caesar Rodney High School
Camden, Delaware
CRHS '97-'01
University of Delaware '01-'05
CRHS quizbowl coach '06-'12
http://crquizbowl.edublogs.org
Post Reply