Thursday, December 17, 2009

Alternate Requests for College Bowl Pool Pick 'em Sheets

I've been getting flooded for requests for all types of variations on my traditional college football bowl pool pick 'em sheet. For those of you familiar with mine, it's a straight up pick the winner (not picking against the line) and you assign points to each pick between 1 and 34 (each number used only once) depending on how confident you are in your pick.

I cannot possibly keep up with each and every variation people want, but I have gotten a number of requests for a simpler version that is more like my NFL Weekly Pool sheet that I did not that long ago. This version is picking a winner straight up (no line) and one point is assigned for each correct pick. The tie-breaker is the total combined score of the championship game. This version I made with 30 possible games (I know there are 34 bowl games, but you can figure out how to add the rest if you want to.) and is set up for up to 100 participants.

Excel_Geek Insiders subscribers will get this file for free as part of their subscription. Not a subscriber? Sign up. It's cheap and easy and you get copies of all the $50 Projects I complete.

I'll probably do another version of two of pool sheets.



Sunday, December 06, 2009

2009-10 College Football Bowl Pool Spreadsheet

Okay's ready. Well...sort of.

We won't know whether or not it's Army or UCLA vs. Temple in the EagleBank Bowl until Army plays Navy on December 12th. Army has to win that game to become bowl eligible. My money's on Navy, so I'm guessing we'll see UCLA. Whenever we know, you'll have to make that last change for yourself.

Here are the files:

  • Click here for the corrected main file.

    Note: I just found out that I had a problem with this file. It wouldn't let you select the winner of each game in the "WINNER" column. I've since corrected this and this download now works. If you've already got all your data in the file you previously downloaded don't worry, the fix is simple. Go to Tools --> Protection --> Unprotect Sheet... Then select all of the cells where you determine the winner in the "WINNER" column and go to Format --> Cells... --> Protection tab, and uncheck the "Locked" option. Then go back to Tools --> Protection --> Protect Sheet... and click OK without setting a password.

  • Click here for a simply entry form you can pass around to other to make their picks.

Let me know if you have questions. Also, please pass along any great improvements you make. Remember, last year Jonathan chipped in some nice new features.