Skip to main content

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. 

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.

Popular posts from this blog

Labor Day FF links

Happy long weekend! Here's hoping most of you are free to enjoy the 3-day weekend and the relaxation and fun that comes with it. I spent my Sunday participating in 3 fantasy football drafts scattered throughout the day and night, but I think I've finally wrapped up my drafts for the year. So like many of you I'm now turning my attention to the Week 1 games! But before we get to some player rankings and prep for Week 1, I want to make sure that all you experts out there are aware of the upcoming deadline for the annual accuracy contest that I run with the Fantasy Sports Trade Association. I compare preseason positional rankings from experts to the final outcome of the fantasy season to see which site had the most accurate preseason rankings, and this year's deadline is fast approaching: September 9th by kickoff. Check out the info on the FSTA site for more details and be sure to e-mail me your submissions. Now, onto Week 1! First up, let's get to some of this

2010 Week 2 consensus start/sit

Greetings and happy weekend. I've got this week's consensus start/sit for you which is a tally of all the start/sit votes that players received in the various start/sit articles that I linked to earlier in the week. So while these aren't my personal recommendations, I do think knowing what the consensus is could be of help when making lineup decisions...so enjoy! Note: the players are listed in no particular order. QB Start: Michael Vick, Kyle Orton, Matt Ryan, Jason Campbell Sit: David Garrard, Alex Smith, Jay Cutler, Vince Young, Carson Palmer RB Start: LeSean McCoy, Darren McFadden, Ahmad Bradshaw, Brandon Jackson Sit: Tim Hightower, C.J. Spiller, Beanie Wells, Ronnie Brown WR Start: Santana Moss, Legedu Naanee, Malcolm Floyd, Mike Williams (TB), Dez Bryant Sit: Randy Moss, Michael Crabtree TE Start: Chris Cooley, Todd Heap, John Carlson, Jermichael Finley Sit: Jermaine Gresham, Owen Daniels, Tony Scheffler, Jeremy Shockey, Bo Scaife Kicker Start: La

Start/Sit Week 4 and a smattering of rankings

It's been awhile, my fantasy football friends. I have lofty intentions of getting several posts up here each week, but life is busy and I will do my best. So in the intervening 6 years since I've posted regularly on here, our family added another child (now there are 3!), moved back to Boulder for a sabbatical year and then returned to Knoxville, and we have basically been chugging along like many of the rest of you. My two boys (who turn 12 and 9 soon) are in a fantasy football league for the first time this year with their buddies, which ostensibly is the just the dads (and mom!) playing one another of course. But my oldest is taking it super seriously and what kind of Fantasy Football Librarian would I be if I didn't step up my game for him? So I'm back - and am interested in the fantasy landscape - lots of the same awesome sites out there, but many new ones as well. I'll try to incorporate a mix. Please be sure to let me know if my 2006 ways aren't working i