Pages

Sunday, December 4, 2022

2022 College Football Bowl Prediction Pool

The college football conference championships were played this past weekend which means the 2022 NCAA college football bowl season is here again! Therefore, it’s time to make your picks and predictions about who you think will win each bowl game. One of the best times of the holiday season (other than giving and receiving gifts) is being able to talk trash to your relatives about their terrible bowl picks.

This year has the added bonus of not just single bowl games but the ninth year of a four team playoff to determine the national champion. And it was recently announced this will be the second to last year of the four team format as starting in 2024 the college football playoff will expand to twelve teams. Can't wait to see how that plays out!

ncaa college football bowl pickem game in excel


But let's not get ahead of ourselves and just enjoy that fact that for the first time the playoff doesn't have Alabama or Clemson in it! It's good to see at least one new team make the CFB playoff. Here's the full breakdown of bowl teams per conference:

bowl pickem excel game template college football


There are multiple ways to play Bowl pick'em. Features for this year's bowl prediction pool over the previous college football bowl pool manager spreadsheets include the following:

  • Easy method to make each bowl game worth a different point value, so the national championship game and semi-finals can be worth more points, or however you want to customize it.

  • Updated leaderboard tab with new stats

  • Separate entry sheet to pass out to participants or co-workers that can be imported automatically by a built-in macro

  • Complete NCAA college football bowl schedule with game times and TV stations

  • New stat sheet to track each conference's record during bowl season. Graph shows total conference teams and total conference wins

The bowl prediction sheets include the football helmet designs for every team (taken from my college football helmet schedule spreadsheet), their win-loss record, and the logo for all bowl games. I added the helmets so those players who aren't big college football fans can pick a winner based on their favorite helmet design!

Download the CFP Pool Manager and Single Entry Form here

Bowl Pick'em Game For Google Sheets

Unlike many of my other spreadsheets, macros are not critical for the Bowl prediction pool. If you have a Google drive account you should be able to upload the pool manager and use it inside Google sheets. Participants can make their picks directly in the sheet using the drop down lists and everyone can see the scoreboard update in real time. All the formulas should work. Insert new columns where it says in order to add more players. The macro to import single player picks won't work but it is not needed. Try it if you want to play that way and let me know if you find any issues in Google sheets.

College Football Bowl Pick'em with Confidence Points

If you watch the video above you can see how this works. Each player can select confidence picks where they rank each game according to how confident they are in their pick. If you're super confident Georgia is going to roll over Ohio State you would rank that game 42 from the drop down list and would receive 42 points if you're correct. If you're not so sure Michigan will beat TCU you might only rank that game 1 or 2 points. 


Download the 2022 CFP Bowl Prediction Pool Manager.xlsm file here

Have fun! As always, I welcome any feedback or ideas for improvement.

12 comments:

  1. Cricket Bowl?
    Points dont add up without it?

    ReplyDelete
    Replies
    1. I didn't add the cricket celebration bowl this year but I can. what points aren't adding up? on the leaderboard?

      Delete
  2. what is the best way to add point spreads?

    ReplyDelete
    Replies
    1. You mean for each game as a reference? Insert a new column between F and G

      Delete
  3. Replying to Cricket Bowl
    when using the confidence sheet - there are 946 points for the summary total - this only works with 43 bowl games. Either change the total to 903 points (w/o Cricket bowl) or add back the cricket bowl

    ReplyDelete
  4. Nick last year when you put all your picks in and when you got ready to make the championship selection it would allow you to do so for each person who is playing this year once I get to the title game the selection is saying select a winner instead of giving you the choice of the 2 winners on that person line sheet who they may have selected.

    ReplyDelete
    Replies
    1. The drop down is being populated by the wrong cells. The drop down in L44 is referring to E and F 44. If you go to Data>Data validation you can change to L42 and L43 then it will show who that player picked to win those games in the drop down.

      Delete
  5. Nick I'll be honest I'm not excel savvy is it anyway you could help with this please and send it out? I tried it but I cannot seem to get it to work for me in all the other cells. Please Help. Thanks

    ReplyDelete
    Replies
    1. Sorry about that. OK, should be fixed now (in the regular bowl manager, not the confidence sheet yet). Download again.

      Delete

I'd love to hear from you!
-Nick