The NCAA college football bowl season is here again which means it’s time to make your picks and predictions about who you think will win each game. One of the best times of the holiday season (other than giving and receiving gifts) is gathering around the TV and rooting for your alma mater or hometown football team.
The beauty of this football bowl manager is you will not have to change or modify any formulas yourself (unless you want to of course). Instructions are included within the Excel file and shows you exactly how to manually add more players. But if you were wondering about the nuts and bolts, my spreadsheet uses the rank without ties formula:
=RANK(num, ref) + COUNTIF(range,num)-1
To download the college bowl pool spreadsheets simply click the link below which will take you to the box.com, where the file is hosted. Next, click on the “Download” link in the upper right hand corner. That’s it!
2013 College Football Bowl Pool Manager.xls download (updated 12-9)
2013 College Football Bowl Prediction Entry Form.xls download (updated 12-9)
Please let me know if you have any questions, comments, find any bugs, or have any suggestions for improvement. If you like this spreadsheet then check out our NCAA Helmet Schedule spreadsheet. What team are you rooting for?
Upgrades from last year’s college football bowl pool manager spreadsheet include:
- New easy method to make each bowl game worth a different point value
- New leaderboard tab and stats
- New entry sheet to pass out to participants/co-workers
- Manager copies and pastes participants picks into the bowl pool manager file (will be automated with a macro sometime soon)
- Complete NCAA college football bowl schedule with game times and TV station
- The bowl prediction sheets include the football helmet designs for every team, their win-loss record, and the logo for all 35 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!
The beauty of this football bowl manager is you will not have to change or modify any formulas yourself (unless you want to of course). Instructions are included within the Excel file and shows you exactly how to manually add more players. But if you were wondering about the nuts and bolts, my spreadsheet uses the rank without ties formula:
=RANK(num, ref) + COUNTIF(range,num)-1
2013 College Football Bowl Pool Manager.xls download (updated 12-9)
2013 College Football Bowl Prediction Entry Form.xls download (updated 12-9)
Please let me know if you have any questions, comments, find any bugs, or have any suggestions for improvement. If you like this spreadsheet then check out our NCAA Helmet Schedule spreadsheet. What team are you rooting for?
No comments:
Post a Comment