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 ranking. I 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.

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

A hiatus

Update: It is with a very heavy heart that I tell you all that yesterday, August 30th, I delivered our stillborn daughter, Caroline Mary. This has been an almost surreal and definitely heartbreaking experience and I appreciate the support in each and every one of your notes. Caroline will be honored and loved always. Thank you, thank you, thank you for your thoughts and prayers - they mean the world to our family. I have been a very poor blogger this month and feel I owe you all an explanation, particularly as this is crunch time for draft prep. I hope this is not too personal of a look into my life since I know most of you are just here for the football. I am nearly 18 weeks pregnant and we have learned that our baby (a little girl!) has triploidy, a chromosomal abnormality that means she has three copies of every chromosome instead of the normal two. The doctors have explained that it's a completely random occurrence and fairly rare that she has made it this far along, but tha

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.

9:09 AM

JD said…

Would love to see a PPR version of this also.

10:49 AM

Fantastic job! Thanks!!

2:03 PM

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

4:09 PM

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.

8:43 PM

This comment has been removed by the author.

8:44 PM

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!

1:44 PM

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?

11:14 AM

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.

9:59 PM

Fantasy Football Librarian

Search This Blog