If you didn’t know, it’s college football bowl season. The three people who read this blog and like college football may like this spreadsheet.
I’ve copied some stats from the NCAA stat page and pasted them into Excel (Copy from the web page and Paste Special – Unicode Text). Then I organized the stats by bowl match up and applied some conditional formatting. I also show the last 4 games’ results to identify hot teams.
The conditional formatting is driven from the three cells at the top. The stats are national rankings for Rushing Offense and Defense, Passing Offense and Defense, and Turnovers. If the difference in the national ranking between opposite sides of the ball is more than 40, they cells are flagged. For instance, if a team has a rushing offense that’s 10th in the nation and their opponent has a rushing defense that’s 51st or worse, then the offense his highlighted yellow and the defense is highlighted red. The turnover stat isn’t national ranking, but plus-minus. A positive number means the team has more take-aways than give-aways.
You can change the numbers at the top (40, 40, and 8 ) to whatever you think is a better measure. I tried a few different numbers, but these seem to give good results. The result looks like this:
but shows every bowl game. You can download BowlStats.zip to see the whole workbook. For entertainment purposes only, etc. etc.