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 (KMO, Science Bowl, etc).

Excel quiz bowl scoresheets

Postby lchen » Sun Nov 09, 2008 3:43 pm

http://sites.google.com/site/hchsquizbowl/Home/excel-scoresheets

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
lchen
mason high on your treacherous scaffolding
 
Posts: 180
Joined: Wed Apr 02, 2008 8:11 pm
Location: Hunter, NYC

Re: Excel quiz bowl scoresheets

Postby Mechanical Beasts » Sun Nov 09, 2008 5:36 pm

That's some pretty sexy Excel programming. Also, you know the word "kludge," so +10 to you.
Andrew Watkins
User avatar
Mechanical Beasts
groom of totemic guanacos
 
Posts: 5673
Joined: Thu Jun 08, 2006 10:50 pm

Re: Excel quiz bowl scoresheets

Postby Terrible Shorts Depot » Sun Nov 09, 2008 6:32 pm

Hey Lily Chen,
You're pretty cool for making this.
Charlie Rosenthal
Shady Side Academy '09
Carleton College '13
User avatar
Terrible Shorts Depot
iceman of Andean tears
 
Posts: 759
Joined: Mon Mar 24, 2008 5:05 pm

Re: Excel quiz bowl scoresheets

Postby cornfused » Sun Nov 09, 2008 7:37 pm

Nifty.
Greg Peterson
Maine South HS '07
Lawrence University '11
User avatar
cornfused
groom of totemic guanacos
 
Posts: 2078
Joined: Sun Feb 12, 2006 3:22 pm
Location: Chicago, IL

Re: Excel quiz bowl scoresheets

Postby David Riley » Mon Nov 10, 2008 10:06 am

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"
David Riley
groom of totemic guanacos
 
Posts: 1416
Joined: Tue Apr 29, 2003 8:27 am
Location: Morton Grove, IL

Re: Excel quiz bowl scoresheets

Postby Siverus Snape » Tue Nov 11, 2008 11:26 am

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
Siverus Snape
torrent of sunbursts
 
Posts: 251
Joined: Tue Dec 13, 2005 11:01 pm
Location: Rockford, IL

Re: Excel quiz bowl scoresheets

Postby Captain Sinico » Tue Nov 11, 2008 2:20 pm

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

MaS
Mike Sorice
Illinois
Champaign Centennial
ACF
PACE
User avatar
Captain Sinico
groom of totemic guanacos
 
Posts: 2649
Joined: Sun Sep 21, 2003 1:46 pm
Location: Champaign-Urbana, Illinois

Re: Excel quiz bowl scoresheets

Postby rjaguar3 » Tue Nov 11, 2008 2:27 pm

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 251 times
Greg (Vanderbilt 2012, Wheaton North 2008)
User avatar
rjaguar3
torrent of sunbursts
 
Posts: 278
Joined: Tue Dec 05, 2006 8:39 am

Re: Excel quiz bowl scoresheets

Postby lchen » Wed Nov 12, 2008 12:46 am

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
lchen
mason high on your treacherous scaffolding
 
Posts: 180
Joined: Wed Apr 02, 2008 8:11 pm
Location: Hunter, NYC

Re: Excel quiz bowl scoresheets

Postby dtaylor4 » Sat Nov 15, 2008 12:39 pm

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.
Donald Taylor
Springfield, IL (no affiliation)
Illinois '09 BS Accountancy/'10 Master of Accounting Science
Freelance writer, staffer, stats guru, TD

Where is Christchurch? That's in Queensland
Where is Palmerston North? That's in New South Wales
User avatar
dtaylor4
groom of totemic guanacos
 
Posts: 3639
Joined: Tue Nov 16, 2004 11:43 am
Location: Springfield, IL

Re: Excel quiz bowl scoresheets

Postby Ben Dillon » Sat Nov 15, 2008 8:03 pm

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, St. Joseph's HS
Indiana State Quiz Bowl Board

"Why, sometimes I've believed as many as
six impossible things before breakfast!"
User avatar
Ben Dillon
mason high on your treacherous scaffolding
 
Posts: 243
Joined: Thu Apr 28, 2005 10:47 pm
Location: South Bend, IN

Re: Excel quiz bowl scoresheets

Postby millionwaves » Sat Nov 15, 2008 11:12 pm

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
millionwaves
groom of totemic guanacos
 
Posts: 1360
Joined: Sun Feb 25, 2007 12:35 pm
Location: Urbana, Illinois

Re: Excel quiz bowl scoresheets

Postby cornfused » Sun Nov 16, 2008 12:35 am

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
Maine South HS '07
Lawrence University '11
User avatar
cornfused
groom of totemic guanacos
 
Posts: 2078
Joined: Sun Feb 12, 2006 3:22 pm
Location: Chicago, IL

Re: Excel quiz bowl scoresheets

Postby Mike Bentley » Sun Nov 16, 2008 2:52 am

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
Host of the Quizbowl Cast, a Quizbowl Podcast.
Visit Wastebin, a trash packet archive.
User avatar
Mike Bentley
groom of totemic guanacos
 
Posts: 4561
Joined: Fri Mar 31, 2006 11:03 pm
Location: Bellevue, WA

Re: Excel quiz bowl scoresheets

Postby Ben Dillon » Sun Nov 16, 2008 4:43 pm

Thought of something else... Slimming down the columns so that they automatically fit on one 8.5 x 11 would be nice.
Ben Dillon, St. Joseph's HS
Indiana State Quiz Bowl Board

"Why, sometimes I've believed as many as
six impossible things before breakfast!"
User avatar
Ben Dillon
mason high on your treacherous scaffolding
 
Posts: 243
Joined: Thu Apr 28, 2005 10:47 pm
Location: South Bend, IN

Re: Excel quiz bowl scoresheets

Postby johnnyfulcrum » Mon Nov 17, 2008 12:59 pm

.

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

IP address was banned for a month.
johnnyfulcrum
emerge from subterranean time
 
Posts: 1
Joined: Mon Nov 17, 2008 12:37 pm

Re: Excel quiz bowl scoresheets

Postby Dr. Loki Skylizard, Thoracic Surgeon » Mon Nov 17, 2008 1:15 pm

Go away, enok walker.
Fred Morlan
University of Kentucky CoP, 20XX
hsqbrank manager, PACE member (former President and At Large member of Board), NAQT writer & subject editor, HSAPQ freelance writer, former hsqb Administrator/Chief Administrator, 2012 NASAT Tournament Director
User avatar
Dr. Loki Skylizard, Thoracic Surgeon
groom of totemic guanacos
 
Posts: 13181
Joined: Thu Apr 24, 2003 8:08 am

Re: Excel quiz bowl scoresheets

Postby lchen » Mon Nov 17, 2008 2:23 pm

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
lchen
mason high on your treacherous scaffolding
 
Posts: 180
Joined: Wed Apr 02, 2008 8:11 pm
Location: Hunter, NYC

Re: Excel quiz bowl scoresheets

Postby Captain Sinico » Mon Nov 17, 2008 7:08 pm

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
Illinois
Champaign Centennial
ACF
PACE
User avatar
Captain Sinico
groom of totemic guanacos
 
Posts: 2649
Joined: Sun Sep 21, 2003 1:46 pm
Location: Champaign-Urbana, Illinois

Re: Excel quiz bowl scoresheets

Postby cornfused » Mon Nov 17, 2008 7:20 pm

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
Maine South HS '07
Lawrence University '11
User avatar
cornfused
groom of totemic guanacos
 
Posts: 2078
Joined: Sun Feb 12, 2006 3:22 pm
Location: Chicago, IL

Re: Excel quiz bowl scoresheets

Postby jonah » Mon Nov 17, 2008 7:24 pm

We emailed them to Donald.
Jonah Greenthal
NAQT member, writer/editor, and webmaster
jonah
groom of totemic guanacos
 
Posts: 1864
Joined: Thu Jul 20, 2006 5:51 pm
Location: Chicago

Re: Excel quiz bowl scoresheets

Postby lchen » Tue Nov 18, 2008 1:13 pm

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
lchen
mason high on your treacherous scaffolding
 
Posts: 180
Joined: Wed Apr 02, 2008 8:11 pm
Location: Hunter, NYC

Re: Excel quiz bowl scoresheets

Postby Captain Sinico » Tue Nov 18, 2008 5:05 pm

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
Illinois
Champaign Centennial
ACF
PACE
User avatar
Captain Sinico
groom of totemic guanacos
 
Posts: 2649
Joined: Sun Sep 21, 2003 1:46 pm
Location: Champaign-Urbana, Illinois

Re: Excel quiz bowl scoresheets

Postby Sir Thopas » Tue Nov 18, 2008 5:13 pm

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
Sir Thopas
groom of totemic guanacos
 
Posts: 1330
Joined: Tue Mar 28, 2006 10:10 pm
Location: Hunter, NYC

Re: Excel quiz bowl scoresheets

Postby BuzzerZen » Tue Nov 18, 2008 5:17 pm

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
BuzzerZen
groom of totemic guanacos
 
Posts: 1517
Joined: Thu Nov 18, 2004 11:01 pm
Location: Arlington, VA/Hampshire College

Re: Excel quiz bowl scoresheets

Postby cornfused » Tue Nov 18, 2008 5:20 pm

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
Maine South HS '07
Lawrence University '11
User avatar
cornfused
groom of totemic guanacos
 
Posts: 2078
Joined: Sun Feb 12, 2006 3:22 pm
Location: Chicago, IL

Re: Excel quiz bowl scoresheets

Postby Sir Thopas » Tue Nov 18, 2008 5:26 pm

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
Sir Thopas
groom of totemic guanacos
 
Posts: 1330
Joined: Tue Mar 28, 2006 10:10 pm
Location: Hunter, NYC

Re: Excel quiz bowl scoresheets

Postby dtaylor4 » Tue Nov 18, 2008 5:29 pm

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.
Donald Taylor
Springfield, IL (no affiliation)
Illinois '09 BS Accountancy/'10 Master of Accounting Science
Freelance writer, staffer, stats guru, TD

Where is Christchurch? That's in Queensland
Where is Palmerston North? That's in New South Wales
User avatar
dtaylor4
groom of totemic guanacos
 
Posts: 3639
Joined: Tue Nov 16, 2004 11:43 am
Location: Springfield, IL

Re: Excel quiz bowl scoresheets

Postby Mike Bentley » Tue Nov 18, 2008 9:18 pm

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
Host of the Quizbowl Cast, a Quizbowl Podcast.
Visit Wastebin, a trash packet archive.
User avatar
Mike Bentley
groom of totemic guanacos
 
Posts: 4561
Joined: Fri Mar 31, 2006 11:03 pm
Location: Bellevue, WA

Re: Excel quiz bowl scoresheets

Postby Captain Sinico » Wed Nov 19, 2008 1:31 pm

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
Illinois
Champaign Centennial
ACF
PACE
User avatar
Captain Sinico
groom of totemic guanacos
 
Posts: 2649
Joined: Sun Sep 21, 2003 1:46 pm
Location: Champaign-Urbana, Illinois

Re: Excel quiz bowl scoresheets

Postby cornfused » Wed Nov 19, 2008 5:00 pm

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
Maine South HS '07
Lawrence University '11
User avatar
cornfused
groom of totemic guanacos
 
Posts: 2078
Joined: Sun Feb 12, 2006 3:22 pm
Location: Chicago, IL

Re: Excel quiz bowl scoresheets

Postby cornfused » Wed Nov 19, 2008 5:02 pm

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
Maine South HS '07
Lawrence University '11
User avatar
cornfused
groom of totemic guanacos
 
Posts: 2078
Joined: Sun Feb 12, 2006 3:22 pm
Location: Chicago, IL

Re: Excel quiz bowl scoresheets

Postby cornfused » Wed Nov 19, 2008 6:36 pm

Okay, how do I unzip .zip files when WinZip is no longer working (it refuses to work until I pay)?
Greg Peterson
Maine South HS '07
Lawrence University '11
User avatar
cornfused
groom of totemic guanacos
 
Posts: 2078
Joined: Sun Feb 12, 2006 3:22 pm
Location: Chicago, IL

Re: Excel quiz bowl scoresheets

Postby Red-necked Phalarope » Wed Nov 19, 2008 6:47 pm

Brice Russ
East Forsyth '04
UNC '08
Ohio State '13
Red-necked Phalarope
torrent of sunbursts
 
Posts: 463
Joined: Thu May 05, 2005 1:50 pm
Location: Columbus, OH

Re: Excel quiz bowl scoresheets

Postby Siverus Snape » Wed Nov 19, 2008 10:48 pm

Much better, freer, and less bloated than WinRAR: http://www.7-zip.org/
Siva Sundaram, Rockford Auburn High School '09
Siverus Snape
torrent of sunbursts
 
Posts: 251
Joined: Tue Dec 13, 2005 11:01 pm
Location: Rockford, IL

Re: Excel quiz bowl scoresheets

Postby Red-necked Phalarope » Thu Nov 20, 2008 1:10 am

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
Red-necked Phalarope
torrent of sunbursts
 
Posts: 463
Joined: Thu May 05, 2005 1:50 pm
Location: Columbus, OH

Re: Excel quiz bowl scoresheets

Postby Matthew D » Thu Nov 20, 2008 1:29 am

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
User avatar
Matthew D
iceman of Andean tears
 
Posts: 919
Joined: Sun Oct 23, 2005 9:52 pm
Location: Scenic Grant Alabama

Re: Excel quiz bowl scoresheets

Postby powerplant » Thu Feb 26, 2009 1:54 pm

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-
powerplant
mason high on your treacherous scaffolding
 
Posts: 140
Joined: Mon Mar 26, 2007 5:21 pm
Location: Ohio

Re: Excel quiz bowl scoresheets

Postby lchen » Sat Jun 13, 2009 5:29 pm

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
lchen
mason high on your treacherous scaffolding
 
Posts: 180
Joined: Wed Apr 02, 2008 8:11 pm
Location: Hunter, NYC

Re: Excel quiz bowl scoresheets

Postby First Chairman » Mon Jun 15, 2009 7:58 am

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)
User avatar
First Chairman
groom of totemic guanacos
 
Posts: 3875
Joined: Sat Apr 19, 2003 8:21 pm
Location: Fairfax VA

Re: Excel quiz bowl scoresheets

Postby jonah » Thu Nov 11, 2010 11:54 pm

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
NAQT member, writer/editor, and webmaster
jonah
groom of totemic guanacos
 
Posts: 1864
Joined: Thu Jul 20, 2006 5:51 pm
Location: Chicago

Re: Excel quiz bowl scoresheets

Postby Frater Taciturnus » Thu Nov 11, 2010 11:58 pm

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
--------------
J. Sargeant Reynolds CC 2008, 2009, 2014
Virginia Commonwealth 2010, 2011, 2012, 2013,
Douglas Freeman 2005, 2006, 2007
PACE
NAQT "writer"
User avatar
Frater Taciturnus
groom of totemic guanacos
 
Posts: 2447
Joined: Mon Dec 12, 2005 1:26 pm
Location: Richmond, VA

Re: Excel quiz bowl scoresheets

Postby jonah » Fri Nov 12, 2010 12:00 am

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
NAQT member, writer/editor, and webmaster
jonah
groom of totemic guanacos
 
Posts: 1864
Joined: Thu Jul 20, 2006 5:51 pm
Location: Chicago

Re: Excel quiz bowl scoresheets

Postby lchen » Fri Nov 12, 2010 12:36 am

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
lchen
mason high on your treacherous scaffolding
 
Posts: 180
Joined: Wed Apr 02, 2008 8:11 pm
Location: Hunter, NYC

Re: Excel quiz bowl scoresheets

Postby Public safety diving » Fri Nov 12, 2010 1:16 am

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
HSQB Forum Member
Tournament Database Search by Team
User avatar
Public safety diving
groom of totemic guanacos
 
Posts: 1013
Joined: Tue Dec 04, 2007 8:46 pm
Location: Blacksburg, VA

Re: Excel quiz bowl scoresheets

Postby jonah » Fri Nov 12, 2010 1:37 am

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
NAQT member, writer/editor, and webmaster
jonah
groom of totemic guanacos
 
Posts: 1864
Joined: Thu Jul 20, 2006 5:51 pm
Location: Chicago

Re: Excel quiz bowl scoresheets

Postby Public safety diving » Fri Nov 12, 2010 2:13 am

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
HSQB Forum Member
Tournament Database Search by Team
User avatar
Public safety diving
groom of totemic guanacos
 
Posts: 1013
Joined: Tue Dec 04, 2007 8:46 pm
Location: Blacksburg, VA

Re: Excel quiz bowl scoresheets

Postby jonpin » Tue Nov 16, 2010 1:09 pm

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 188 times
ACF bounceback.xlsx
(21.35 KiB) Downloaded 166 times
ACF.xlsx
(21.29 KiB) Downloaded 181 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: NHBB '13, '14; NSC '13, '14; ACF '14; NASAT '11
User avatar
jonpin
Forums Staff: Moderator
 
Posts: 1443
Joined: Wed Feb 04, 2004 6:45 pm
Location: BCA NJ / WUSTL MO / Hackensack NJ

Re: Excel quiz bowl scoresheets

Postby jonpin » Tue Nov 16, 2010 1:10 pm

Here's the PACE NSC version, since I'm limited to 3 attachments per post
Attachments
PACE NSC.xlsx
(20.92 KiB) Downloaded 153 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: NHBB '13, '14; NSC '13, '14; ACF '14; NASAT '11
User avatar
jonpin
Forums Staff: Moderator
 
Posts: 1443
Joined: Wed Feb 04, 2004 6:45 pm
Location: BCA NJ / WUSTL MO / Hackensack NJ

Re: Excel quiz bowl scoresheets

Postby Down and out in Quintana Roo » Tue Nov 16, 2010 4:18 pm

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
User avatar
Down and out in Quintana Roo
groom of totemic guanacos
 
Posts: 2907
Joined: Wed Apr 09, 2008 7:25 am
Location: Camden, DE

Next

Return to Spooky High School Quizbowl

Who is online

Users browsing this forum: No registered users and 0 guests