Excel quiz bowl scoresheets
Excel quiz bowl scoresheets
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!
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
Hunter '12, MIT '16
- Mechanical Beasts
- Banned Cheater
- Posts: 5673
- Joined: Thu Jun 08, 2006 10:50 pm
Re: Excel quiz bowl scoresheets
That's some pretty sexy Excel programming. Also, you know the word "kludge," so +10 to you.
Andrew Watkins
- Terrible Shorts Depot
- Yuna
- Posts: 760
- Joined: Mon Mar 24, 2008 5:05 pm
Re: Excel quiz bowl scoresheets
Hey Lily Chen,
You're pretty cool for making this.
You're pretty cool for making this.
Charlie Rosenthal
Shady Side Academy '09
Carleton College '13
University of Pennsylvania '18
Shady Side Academy '09
Carleton College '13
University of Pennsylvania '18
- Maxwell Sniffingwell
- Auron
- Posts: 2164
- Joined: Sun Feb 12, 2006 3:22 pm
- Location: Des Moines, IA
Re: Excel quiz bowl scoresheets
Nifty.
Greg Peterson
Northwestern University '18
Lawrence University '11
Maine South HS '07
"a decent player" - Mike Cheyne
Northwestern University '18
Lawrence University '11
Maine South HS '07
"a decent player" - Mike Cheyne
-
- Auron
- Posts: 1401
- Joined: Tue Apr 29, 2003 8:27 am
- Location: Morton Grove, IL
Re: Excel quiz bowl scoresheets
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"
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"
-
- Rikku
- Posts: 251
- Joined: Tue Dec 13, 2005 11:01 pm
- Location: Rockford, IL
Re: Excel quiz bowl scoresheets
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
- Captain Sinico
- Auron
- Posts: 2675
- Joined: Sun Sep 21, 2003 1:46 pm
- Location: Champaign, Illinois
Re: Excel quiz bowl scoresheets
I had everyone use these in practice and they are really excellent. Thanks!
MaS
MaS
Mike Sorice
Former 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
Former 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
Re: Excel quiz bowl scoresheets
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 817 times
Greg (Vanderbilt 2012, Wheaton North 2008)
Re: Excel quiz bowl scoresheets
Thanks for the comments!
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.Siverus Snape wrote:if the tossup goes dead and bonus points are still awarded to one team, the spreadsheet doesn't flag it.
Lily Chen
Hunter '12, MIT '16
Hunter '12, MIT '16
Re: Excel quiz bowl scoresheets
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.
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.
- Ben Dillon
- Rikku
- Posts: 323
- Joined: Thu Apr 28, 2005 10:47 pm
- Location: South Bend, IN
- Contact:
Re: Excel quiz bowl scoresheets
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.
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!"
"Why, sometimes I've believed as many as
six impossible things before breakfast!"
- millionwaves
- Auron
- Posts: 1360
- Joined: Sun Feb 25, 2007 12:35 pm
- Location: Urbana, Illinois
- Contact:
Re: Excel quiz bowl scoresheets
We pretty much ran IO using these today, and they worked fantastically. Thanks a ton for creating these, they're super useful.
- Maxwell Sniffingwell
- Auron
- Posts: 2164
- Joined: Sun Feb 12, 2006 3:22 pm
- Location: Des Moines, IA
Re: Excel quiz bowl scoresheets
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.
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
Northwestern University '18
Lawrence University '11
Maine South HS '07
"a decent player" - Mike Cheyne
- Mike Bentley
- Sin
- Posts: 6463
- Joined: Fri Mar 31, 2006 11:03 pm
- Location: Bellevue, WA
- Contact:
Re: Excel quiz bowl scoresheets
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
Treasurer, Partnership for Academic Competition Excellence
Adviser, Quizbowl Team at University of Washington
University of Maryland, Class of 2008
Treasurer, Partnership for Academic Competition Excellence
Adviser, Quizbowl Team at University of Washington
University of Maryland, Class of 2008
- Ben Dillon
- Rikku
- Posts: 323
- Joined: Thu Apr 28, 2005 10:47 pm
- Location: South Bend, IN
- Contact:
Re: Excel quiz bowl scoresheets
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!"
"Why, sometimes I've believed as many as
six impossible things before breakfast!"
Re: Excel quiz bowl scoresheets
.
User was permanently banned for being enok walker avoiding a previous ban.
IP address was banned for a month.
User was permanently banned for being enok walker avoiding a previous ban.
IP address was banned for a month.
Re: Excel quiz bowl scoresheets
Go away, enok walker.
Fred Morlan
University of Kentucky CoP, 2017
International Quiz Bowl Tournaments, CEO, co-owner
former PACE member, president, etc.
former hsqbrank manager, former NAQT writer & subject editor, former hsqb Administrator/Chief Administrator
University of Kentucky CoP, 2017
International Quiz Bowl Tournaments, CEO, co-owner
former PACE member, president, etc.
former hsqbrank manager, former NAQT writer & subject editor, former hsqb Administrator/Chief Administrator
Re: Excel quiz bowl scoresheets
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
- 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
Hunter '12, MIT '16
- Captain Sinico
- Auron
- Posts: 2675
- Joined: Sun Sep 21, 2003 1:46 pm
- Location: Champaign, Illinois
Re: Excel quiz bowl scoresheets
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
MaS
Mike Sorice
Former 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
Former 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
- Maxwell Sniffingwell
- Auron
- Posts: 2164
- Joined: Sun Feb 12, 2006 3:22 pm
- Location: Des Moines, IA
Re: Excel quiz bowl scoresheets
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?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
Greg Peterson
Northwestern University '18
Lawrence University '11
Maine South HS '07
"a decent player" - Mike Cheyne
Northwestern University '18
Lawrence University '11
Maine South HS '07
"a decent player" - Mike Cheyne
Re: Excel quiz bowl scoresheets
We emailed them to Donald.
Jonah Greenthal
National Academic Quiz Tournaments
National Academic Quiz Tournaments
Re: Excel quiz bowl scoresheets
You're welcome! I'm glad people like them.
That's a good idea. There will be a new version up shortly (2.46) with a cell for the room number.Captain Scipio wrote:The one thing I'd request is that you add a column for the room the round was read in.
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.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?
Lily Chen
Hunter '12, MIT '16
Hunter '12, MIT '16
- Captain Sinico
- Auron
- Posts: 2675
- Joined: Sun Sep 21, 2003 1:46 pm
- Location: Champaign, Illinois
Re: Excel quiz bowl scoresheets
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
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
Former 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
Former 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
- Sir Thopas
- Auron
- Posts: 1330
- Joined: Tue Mar 28, 2006 10:10 pm
- Location: Hunter, NYC
Re: Excel quiz bowl scoresheets
Also, Taft allows each moderator to input the stats locally, should the money be willing to be forked over.
- BuzzerZen
- Auron
- Posts: 1517
- Joined: Thu Nov 18, 2004 11:01 pm
- Location: Arlington, VA/Hampshire College
Re: Excel quiz bowl scoresheets
You're seriously attributing propositional attitudes to money?Sir Thopas wrote:should the money be willing to be forked over
Evan Silberman
Hampshire College 07F
How are you actually reading one of my posts?
Hampshire College 07F
How are you actually reading one of my posts?
- Maxwell Sniffingwell
- Auron
- Posts: 2164
- Joined: Sun Feb 12, 2006 3:22 pm
- Location: Des Moines, IA
Re: Excel quiz bowl scoresheets
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.
No printer access, no problem - paperless tournament.
Greg Peterson
Northwestern University '18
Lawrence University '11
Maine South HS '07
"a decent player" - Mike Cheyne
Northwestern University '18
Lawrence University '11
Maine South HS '07
"a decent player" - Mike Cheyne
- Sir Thopas
- Auron
- Posts: 1330
- Joined: Tue Mar 28, 2006 10:10 pm
- Location: Hunter, NYC
Re: Excel quiz bowl scoresheets
It greases the palm, after all.BuzzerZen wrote:You're seriously attributing propositional attitudes to money?Sir Thopas wrote:should the money be willing to be forked over
Re: Excel quiz bowl scoresheets
Are you counting the paper used to print and post stats?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.
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.
- Mike Bentley
- Sin
- Posts: 6463
- Joined: Fri Mar 31, 2006 11:03 pm
- Location: Bellevue, WA
- Contact:
Re: Excel quiz bowl scoresheets
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
Treasurer, Partnership for Academic Competition Excellence
Adviser, Quizbowl Team at University of Washington
University of Maryland, Class of 2008
Treasurer, Partnership for Academic Competition Excellence
Adviser, Quizbowl Team at University of Washington
University of Maryland, Class of 2008
- Captain Sinico
- Auron
- Posts: 2675
- Joined: Sun Sep 21, 2003 1:46 pm
- Location: Champaign, Illinois
Re: Excel quiz bowl scoresheets
Bentley Like Beckham wrote:...have a backup plan...
Bentley Like Beckham wrote:...have a backup plan...
MaSBentley Like Beckham wrote:...have a backup plan...
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
Former 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
Former 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
- Maxwell Sniffingwell
- Auron
- Posts: 2164
- Joined: Sun Feb 12, 2006 3:22 pm
- Location: Des Moines, IA
Re: Excel quiz bowl scoresheets
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?
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
Northwestern University '18
Lawrence University '11
Maine South HS '07
"a decent player" - Mike Cheyne
- Maxwell Sniffingwell
- Auron
- Posts: 2164
- Joined: Sun Feb 12, 2006 3:22 pm
- Location: Des Moines, IA
Re: Excel quiz bowl scoresheets
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
Northwestern University '18
Lawrence University '11
Maine South HS '07
"a decent player" - Mike Cheyne
- Maxwell Sniffingwell
- Auron
- Posts: 2164
- Joined: Sun Feb 12, 2006 3:22 pm
- Location: Des Moines, IA
Re: Excel quiz bowl scoresheets
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
Northwestern University '18
Lawrence University '11
Maine South HS '07
"a decent player" - Mike Cheyne
-
- Rikku
- Posts: 463
- Joined: Thu May 05, 2005 1:50 pm
- Location: Columbus, OH
-
- Rikku
- Posts: 251
- Joined: Tue Dec 13, 2005 11:01 pm
- Location: Rockford, IL
Re: Excel quiz bowl scoresheets
Much better, freer, and less bloated than WinRAR: http://www.7-zip.org/
Siva Sundaram, Rockford Auburn High School '09
-
- Rikku
- Posts: 463
- Joined: Thu May 05, 2005 1:50 pm
- Location: Columbus, OH
Re: Excel quiz bowl scoresheets
They're making you pay for WinRAR now? I didn't even check. Yeah, go with 7-Zip.Siverus Snape wrote:Much better, freer, and less bloated than WinRAR: http://www.7-zip.org/
Brice Russ
East Forsyth '04
UNC '08
Ohio State '13
East Forsyth '04
UNC '08
Ohio State '13
Re: Excel quiz bowl scoresheets
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
Coach DAR Quizbowl Team
-
- Wakka
- Posts: 142
- Joined: Mon Mar 26, 2007 5:21 pm
- Location: Ohio
Re: Excel quiz bowl scoresheets
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
Link
Joseph Wells
Garfield Heights High School '08
Centre College 2008-2010
Tri-C 2010-2011
Ohio State 2011-
Garfield Heights High School '08
Centre College 2008-2010
Tri-C 2010-2011
Ohio State 2011-
Re: Excel quiz bowl scoresheets
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
Hunter '12, MIT '16
- First Chairman
- Auron
- Posts: 3651
- Joined: Sat Apr 19, 2003 8:21 pm
- Location: Fairfax VA
- Contact:
Re: Excel quiz bowl scoresheets
I appreciate your efforts on this, Lily.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.
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)
Founder, PACE
Facebook junkie and unofficial advisor to aspiring health professionals in quiz bowl
---
Pimping Green Tea Ginger Ale (Canada Dry)
Re: Excel quiz bowl scoresheets
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
National Academic Quiz Tournaments
- Frater Taciturnus
- Auron
- Posts: 2463
- Joined: Mon Dec 12, 2005 1:26 pm
- Location: Richmond, VA
Re: Excel quiz bowl scoresheets
Can't you just change the numbers?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.
Janet Berry
[email protected]
she/they
--------------
J. Sargeant Reynolds CC 2008, 2009, 2014
Virginia Commonwealth 2010, 2011, 2012, 2013,
Douglas Freeman 2005, 2006, 2007
[email protected]
she/they
--------------
J. Sargeant Reynolds CC 2008, 2009, 2014
Virginia Commonwealth 2010, 2011, 2012, 2013,
Douglas Freeman 2005, 2006, 2007
Re: Excel quiz bowl scoresheets
Yes, but I thought other people might find the same thing useful, so it would be great if they were centrally distributed.Frater Taciturnus wrote:Can't you just change the numbers?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.
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
National Academic Quiz Tournaments
Re: Excel quiz bowl scoresheets
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.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.
Lily Chen
Hunter '12, MIT '16
Hunter '12, MIT '16
- Whiter Hydra
- Auron
- Posts: 1418
- Joined: Tue Dec 04, 2007 8:46 pm
- Location: Fairfax, VA
- Contact:
Re: Excel quiz bowl scoresheets
Wouldn't they just be cells AA24 and AB24?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.
Harry White
TJHSST '09, Virginia Tech '13
Owner of Tournament Database Search and Quizbowl Schedule Generator
Will run stats for food
TJHSST '09, Virginia Tech '13
Owner of Tournament Database Search and Quizbowl Schedule Generator
Will run stats for food
Re: Excel quiz bowl scoresheets
Nope. That appears to be the total number of rebounded points (also displayed at H30 and Q30), but isn't the number of opportunities.The Gambler, the Nun, and the Radio wrote:Wouldn't they just be cells AA24 and AB24?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.
Jonah Greenthal
National Academic Quiz Tournaments
National Academic Quiz Tournaments
- Whiter Hydra
- Auron
- Posts: 1418
- Joined: Tue Dec 04, 2007 8:46 pm
- Location: Fairfax, VA
- Contact:
Re: Excel quiz bowl scoresheets
That's rebounded points available, which if you divide by 10, is number of opportunities.jonah wrote:Nope. That appears to be the total number of rebounded points (also displayed at H30 and Q30), but isn't the number of opportunities.The Gambler, the Nun, and the Radio wrote:Wouldn't they just be cells AA24 and AB24?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.
Harry White
TJHSST '09, Virginia Tech '13
Owner of Tournament Database Search and Quizbowl Schedule Generator
Will run stats for food
TJHSST '09, Virginia Tech '13
Owner of Tournament Database Search and Quizbowl Schedule Generator
Will run stats for food
- jonpin
- Auron
- Posts: 2266
- Joined: Wed Feb 04, 2004 6:45 pm
- Location: BCA NJ / WUSTL MO / Hackensack NJ
Re: Excel quiz bowl scoresheets
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:
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.
- 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).
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 700 times
-
- ACF bounceback.xlsx
- (21.35 KiB) Downloaded 743 times
-
- ACF.xlsx
- (21.29 KiB) Downloaded 800 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
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
- jonpin
- Auron
- Posts: 2266
- Joined: Wed Feb 04, 2004 6:45 pm
- Location: BCA NJ / WUSTL MO / Hackensack NJ
Re: Excel quiz bowl scoresheets
Here's the PACE NSC version, since I'm limited to 3 attachments per post
- Attachments
-
- PACE NSC.xlsx
- (20.92 KiB) Downloaded 593 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
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
- 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
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
Caesar Rodney High School
Camden, Delaware
CRHS '97-'01
University of Delaware '01-'05
CRHS quizbowl coach '06-'12
http://crquizbowl.edublogs.org