Monday, September 7, 2015

Going for Two: Just Before Regular Season Start

The 2015 regular season of the NFL starts next week and I'm starting with my first post for it today. I selected the name for these posts, "Running the Football" "Going for Two", based on the fact that this is the second consecutive season that I have committed to blogging [nearly] every week and created a spreadsheet to pick winners during* the season. In other words, this is possibly the start of a "streak", synonyms for which are period, spell, stretch, run, and patch. Of those, run relates most to football, hence "Running the Football".

I've been enjoying pre-season games for the last month and opened up my spreadsheet this weekend for the first time since March, when I entered in the Free Agency "Grades" as identified by CBS Sports. I made edits to the spreadsheet, including splitting the Master sheet into two and changing my "Ideal" ranks. Then I started making a calculation to determine the expectations this year based on performance last year and activity in the post and off seasons.

  • 2014 Wins: All 2014 Regular & Post Season wins (Ties count for .5) and 1 point for getting into the playoffs.
  • Free Agency Performance: Number out of 8 points based on a percentage identified by the Free Agency Grade, assuming that the grades are given based on an American college scale, with 1-2 percentage points gained or lost based on whether experts at the NFL identified the team as a "Winner" or "Loser" during the free agency period.
  • Draft Performance: Number out of 4 points based on a percentage identified by dividing the number of points awarded in the NFL's Draft Class Power Rankings by 290, the points given to the highest ranked team.
It took a few passes to get to those decisions, with first giving a total possible 8 points for Free Agency and Draft, and giving whole number points from 1-8 for each grade (e.g. 8 for an A, 7 for a B+). After a conversation with a friend about the perils of the draft, I reduced the weight of the draft numbers to half of those for Free Agency. While Free Agents have played with NFL rules, college players have not. A well-rated college player's performance is less known. 

Next, I looked for additional rankings of Free Agency performance, but only found those "Winners" and "Losers" sites. Without a better ranking, I decided to apply a percentage to the grades so I could award points to the winners and losers without "bumping up their grade".

After entering these numbers, I sorted the points to determine how the teams will do this year. 

Team RankPointsTeam RankPoints
1New England Patriots14.8117Minnesota Vikings10.01
2Green Bay Packers14.5618Buffalo Bills9.97
3Dallas Cowboys14.3919Cleveland Browns9.95
4Seattle Seahawks13.8920Carolina Panthers9.60
5Denver Broncos13.0921San Francisco 49ers9.59
6Indianapolis Colts12.9922Atlanta Falcons8.94
7Baltimore Ravens12.6723New Orleans Saints8.91
8Arizona Cardinals11.9424New York Giants8.77
9Cincinnati Bengals11.9125Chicago Bears8.68
10Pittsburgh Steelers11.5126New York Jets8.38
11Detroit Lions11.3927St. Louis Rams7.85
12Houston Texans11.2628Washington Racists7.67
13Philadelphia Eagles10.6229Jacksonville Jaguars7.59
14Miami Dolphins10.5930Tennessee Titans6.61
15San Diego Chargers10.4531Oakland Raiders6.58
16Kansas City Chiefs10.2132Tampa Bay Buccaneers5.66

I've had a couple peer reviews of these rankings and while those peers put some teams higher or lower, there is general approval of the overall picture. I can only offer my apologies to Oakland and Tampa Bay.

These numbers will be used for the first five week of the season, in diminishing importance each week (e.g. 100% for Week 1, 80% for Week 2, and down), before total wins and losses are the only ranking factor.

*I didn't pay much attention to the 2013 season due to other factors, but I did create a spreadsheet and fill in the information, including my likely 'gut' picks. Because I didn't know the outcome of most of the games, those picks were somewhat accurate, but it is likely that they skewed more accurate based on what I did know. I tried to focus only on the number of wins for the team and who Football Locks identified as the favorite. 

No comments:

Post a Comment