Saturday, January 31, 2009

Last Minute, Automated-ish, Superbowl Pool


It's the Saturday before Superbowl Sunday - and you wish you had created a box pool for you and your friends. Too late, right? Nah... anything is possible... (if you've never been in a superbowl box pool - either stop reading or read on to check it out).

Here's an online way to do it (I know there are "real" sites for this): I created a SuperBowl Box Pool spreadsheet which has an online FORM for people to quickly participate... People fill out the form and they get assigned a random box in the pool - then, when all boxes are taken (there's 100 boxes, so it's ok to take more than one), the score values are randomly assigned and the names are again shuffled...
Then, as I enter the scores at the end of each quarter, the winners are identified automatically (as if that would be too hard to do by hand - sometimes I'm almost pathetic in my need to create useless spreadsheet formulas)

If you want to play in my pool (just for fun... no "points" to be won here!), just FILL OUT MY FORM and then go SEE THE BOX POOL to see which random boxes.

If you want your own - just go to THE SAMPLE and make your own copy (File menu, "create a copy" option... you'll need a Google Docs account).

If I get 100 boxes filled, I'll post the winner here after the Superbowl!

[Update: If you use the sample to run one of these on your own, be careful once the box numbers are generated... as they could easily be re-generated in-advertently if a change is made to the sheet which forces a re-calc - like inserting columns or other things. This shouldn't impact anything until you generate the random score numbers ... Once you take that startup step as per the instructions, don't touch the thing except to enter scores ;) and PRINT IT to be sure... ]

[Update 2/2/2008: And the winner was - Curious George. I would have won the half-time score, which is no wonder since I had to take almost half the boxes between myself and people close enough that they may as well have been me... Well - maybe I'll start collecting players for 2010 ;) ]

No comments: