August 13, 2011 - UPDATED with 2011 Season!!! Check the Spreadsheets Tab.
First, I do realize this spreadsheet may not excite you like it does me, but I'm weird like that. I love my spreadsheets; probably because I love organization, but not to the point that I'll be appearing on A&E's Obsessed any time soon.
And I've created an awesome NFL Pick Em spreadsheet, available free to anyone who wants it. Like many of my spreadsheets, I've been using this one for years, but just took the weekend to completely revamp it. I've saved it as an XLS (Excel 2003) file.
You can get the file (for non-spread pick pools) from my folders on MediaFire here:
NFL Pick Em-2011.xls
And you can get the file (for pools against the spread) from my folders on MediaFire here: NFL Pick Em-2011-Spread.xls
Before I make my picks each week in the office pool, I have a ritual.
- Find out the favorites.
- Check out the point spread.
- Read about the matchups.
- Check for key player injuries.
- Consider home field advantage.
- Make my picks.
- Predict the Sunday Night and Monday night scores (you need those for tiebreakers).
- Predict the team who will score the lowest and the highest (also needed for tiebreakers).
- Choose my survival pool team (pick one team to win each week but can't choose same team twice). I actually have two of those going in the beginning of the season, then I'm quickly down to one.
As the games complete, I update my spreadsheets and see how I fared. I also check out what would have happened if I chose all favorites or all home teams. Each year, I would have won the pool at least once, if I had tried one of these methods, even after the tiebreakers - usually with all favorites. Home team advantage is not as big a factor as local fans would like to think.
So if you're detail-oriented or just want some helpful organization, this is the spreadsheet for you. I embrace my neuroses! Maybe I should be on A&E.
Let me know what you think!