With
the help of David Tyler (creator of one of the best NCAA college basketball Excel brackets) I have made some modifications to my
2011 college football bowl sheet.
· By
using the sumproduct formula and conditional formatting we have
replaced the VBA COLORFUNCTION, making the spreadsheet much more user
friendly. No need to press crtl+alt+f9 to update the formulas!
· I
moved the scoreboard to its own individual sheet and included a few new
stats, such as the bowl game picked correctly by the most number of
players.
· I
expanded the default number of players to twenty but there’s still the
issue where new players beyond the first twenty added to the pool are
not automatically accounted for in the leader boards.
Please
keep in mind; this is just the beginning of the evolution of this
spreadsheet. The end goal is to automate inserting the exact number of
players along with all of their picks. There will also be some sort of
tie-breaking function, like guessing the score for the BCS championship
game or using a confidence interval to rank each pick.
And
hopefully by the time this new spreadsheet is completed we can throw
the whole thing out because we’ll finally have a college football
playoff!
No comments:
Post a Comment
I'd love to hear from you!
-Nick