Monday, December 5, 2011

2011-12 NCAA College Football Bowl Pool Spreadsheet Dowload

Now that the2011-2012 NCAA college football bowl game match-ups have been announced, I was able to quickly put together a schedule in Excel spreadsheet form. I have made it available to download. Pictured below is the schedule of each and every bowl game as well as the time of the game and what TV channel it will be shown own.

I have also created a simple college football bowl predictions pool. When I get the emails of folks picks I put them in the spreadsheet and then when games are played I color the winners the green as in box A2 and the wrong ones in red. Then out in the far column it counts all the picks that are colored green using the COLORFUNCTION formula

=ColorFunction($A$40,C3:C38,FALSE)

You may have to double click on the sum cells in order to get them to compute. Please let me know if you have any questions.

A few interesting bowl game notes.
  • The Humanitarian Bowl has been replaced by the Famous Idaho Potato Bowl. 
  • The Texas Bowl is now called the Meineke Car Care of Texas Bowl.
  • The old Meineke Car Care Bowl has been replaced by the Belk Bowl.
Update: The download link should now be working! Please comment below if there are any issues. Thanks!

Download the 2011 College Football Bowl Prediction Pool Spreadsheet.xls


Check out our other sports spreadsheets, including a college football helmet schedule.

Latest download is here 12-27-11 

Update: Download the 2012 - 2013 version here.