Wednesday, August 10, 2011

2011 Average Rankings Spreadsheet

Greetings, fantasy football fans and welcome to the 2011 Average Rankings Position Spreadsheet. Last night I trolled around the web and gathered top 100 overall rankings from 10 sites and have averaged them together into a handy dandy spreadsheet for you. The rankings come from: ESPN, CBSSports.com, NFL.com, SI, FFToolbox.com, Yahoo!, KFFL, FFCalculator (ADP), FOX Sports, and Ask the Commish. I will update these rankings at the end of August for those of you who draft closer to the start of the season.

A few things to note before we get to the spreadsheet itself:

  • This is just an average of Top 100 players across all positions. I'll try and update the spreadsheet this weekend to reflect the ranking within position as well, so look for that update in the Google Docs version of the spreadsheet in the next few days.
  • I tried to ensure that the experts all used the same scoring system (non-PPR) but many sites didn't note their scoring system at all.
  • I pulled all of these rankings within the span of an hour or two on Tuesday, August 9th so that they represent rankings from the same time period/news/injury updates, etc.
  • I've included the standard deviation of each player's ranking so that you can get an idea of how much consensus there was on a player's ranking across the 10 experts. So the lower the standard deviation, the more of a consensus there is on the ranking for that player. In some cases where just one site submitted a ranking for that player, you of course won't see a standard deviation at all. I added the standard deviation to the average ranking position to create one number to represent both a player's ranking and the level of agreement on that rankingI find this pretty interesting in and of itself, but it could be particularly useful for players that are a bit deeper in the Top 100. 
  • I've included the rankings from these 10 sites (11 different rankings though since CBS offers one from each of their 2 experts) as separate tabs in case you just want to look at the data from each site - or want to do your own analysis. The names are about 99% cleaned up here in this version with a few errant misspellings from FOX. Sorry to call you out, FOX, but seriously, shouldn't you know how to spell Dwayne Bowe by now?
So enjoy the Google Docs version or send me an e-mail and I can get an excel copy sent your way. 

9 comments:

Anonymous said...

When you do your positional rankings would it be possible to do it using a composite of the sites that have are the top 5 at ranking that position for 3 or more years?

Speaking of which, I was wondering if you'd consider a change to how you do the best multi-year rankings (since it isn't out yet).

Could you average their score for each year and rank that rather than their average percentile rank? This would reward a #1 site more in a year they blow away the competition vs. a year they were just about tied with everyone in the top ten. Also, if you showed the score it would give an idea of tiers.

In addition, you could include in the two year one anyone that also has more than two years. So, it would be everyone with data for 2009 and 2010 (even if they also have data in 2008 and before). Then the three year would be anyone with data for 2008, 2009, and 2010. And so on for more years.

JD said...

Would love to see a PPR version of this also.

Anonymous said...

Fantastic job! Thanks!!

Anonymous said...

They must have confused Dwayne Bowe with Dwyane Wade, who's name is inexplicably spelled with the y before the a...

Dan C said...

For the players that aren't ranked by every source, you seem to throw out the rankings of the sources where the player is ranked over 100. For instance, Willis McGahee is ranked 84th by one source, and unranked by the other 10 (which essentially means they've ranked him worse than 100), yet his Average is listed as 84. The best case scenario for this player would be all 10 other sites having him listed at 101, which would mean that there is no way his average could be better than 99.5.

Dan C said...
This comment has been removed by the author.
Anonymous said...

Great job, would love to see it expanded to 200 players and include columns with player's team and position. Would make it more sortable. Thanks!

Anonymous said...

Ya a 200 list would be great for my 14 team draft. And since we are making requests can you add the bye week column?

Anonymous said...

This is fantastic. You should include this spreadsheet in your annual rankings of the most accurate projections. It will be interesting to see where it comes in.