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.

18 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Please send me the file! Thanks!

    Yield101@aol.com

    ReplyDelete
  3. Please send me the file
    brian@rdelect.com

    Thanks

    ReplyDelete
  4. Please email spreadsheet to me. Derekmedley@gmail.com

    ReplyDelete
  5. Please send me the file.
    toia.dungan@momentumchevrolettulsa.com

    ReplyDelete
  6. Please send me the file.

    Thanks!

    dangodf@yahoo.com

    ReplyDelete
  7. Email to rangersfan96@gmail.com

    Thank you!

    ReplyDelete
  8. Email to tjh365@mst.edu

    Thanks!

    ReplyDelete
  9. Please send this file
    bkh_32@hotmail.com

    Thanks!

    ReplyDelete
  10. Please send. Thanks!

    LAsearch11@gmail.com

    ReplyDelete
  11. Please send...Thanks!!

    jpiakis@gmail.com

    ReplyDelete
  12. The download link has been posted and should be working now!

    ReplyDelete
  13. Please send me the file: jcaparula@gmail.com

    ReplyDelete

I'd love to hear from you!
-Nick