I am in the process of making a spreadsheet for the 2012 NFL season.
The purpose of the spreadsheet is to keep track of my bets, wins, losses, net profit, and other stuff related to the financial side of sports betting, but the most important thing it will be doing is calculating statistics for every NFL team from week to week.
So far, this is what it will do automatically for me when I enter final scores from week to week:
1. Divisional standings
2. Number of wins/losses per team
3. Average home points per team
4. Average away points per team
5. Average points over-all per team
6. Average home, away and over-all points per team for weeks 1-3, 4-7, 8-11, and 12-16.
7. Home winning percentage
8. Away winning percentage
I am also considering a simple function for calculating team standings ATS, but I know that I can easily find this on the internet.
Although this is a good start, I assume it is not enough. When I get home I will attach the XLS if anyone would like to look at it.
What other types of stats should I be keeping track of to make this spreadsheet even better?