The college football conference championships were played this past weekend which means the 2021 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 eighth year of a four team playoff to determine the national champion.
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 the 2017 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
I'm working on a new version where you could do confidence points that you can test out now and give me feedback.
Download the 2021 CFP Bowl Prediction Pool Manager.xlsm file here
Please let me know if you have any questions, comments, find any bugs, or have any suggestions for improvement. I love that people are using this Bowl Prediction Game to help raise money for charity, that's so awesome to hear! What team are you rooting for?
will you be coming out with a 2022 spreadsheet?
ReplyDeleteyes, it is live now, same download link
DeleteWe waiting Nick Thanks for creating College bowl sheet.
ReplyDeletethis is awesome! I want to learn how to make one! Any instructional videos?
ReplyDeleteI have some videos on YouTube. You can download the sheet and deconstruct it to see how it works.
DeleteWill there be a 2024 one?
ReplyDeleteYes, working on it
Delete