Dr. Green and White Sports Authority

(Originally posted to various internet sources in July of 2015) Math + sports = happiness, at least that is how I look at the world. I little while ago, I posted a very long analysis of the upcoming college football season based on a spreadsheet-driven simulation of the entire football season. In that article, I glossed over the details of the simulation, but for those that are interested, I have prepared this companion article that goes into the simulation in greater detail. In nothing else, I think there is some cool data about Vegas spreads in here. Ironically, the spreadsheet was born on the campus of Purdue University in 1998, where as a graduate student I first created a file to track schedules and scores. Year-by-year, I would make steady improvements to the format to make the entry of both the schedule and scores easier. At some point, I added an equation to calculate a rudimentary power ranking based on the points scored in each game and the opponents winning percentage.

(Originally posted to various internet sources in July of 2015) Hello. My name is Paul, and I have a problem: I love college sports and I love spreadsheets. When I put these two loves together, strange, time-consuming things happen. Back in the spring, I made a couple of Fanposts detailing the Excel database that I created to track  NCAA basketball tournament   history and some of the data mining that I have performed on it. But basketball is only the tip of the iceberg. I actually first flirted with sports and spreadsheets long before the basketball database every existed. My first love, in fact, is the College Football Spreadsheet, and I would like to share that love with Spartan Nation today, especially those that are #teammath. Many years ago now, I developed a spreadsheet and algorithm that allows me to generate a power ranking, predict point spreads, and probabilities of victory for every game in the Division 1 college football season. During the long dark summer of no colleg