Thursday, August 16, 2012

2012 average position rankings

Back by popular demand is my annual average position rankings spreadsheet. This morning I gathered up the top 150 overall rankings from 11 different experts (10 sites, but CBS has their 2 gurus) and averaged them together to create a helping hand to all the drafters out there. The rankings for 2012 come from: ESPN, NFL.com, CBSSports.com (both Dave Richard and Jamey Eisenberg), KFFL.com, Ask the Commish, Yahoo!, FFCalculator (ADP), FFToolbox, ProFootballWeekly (winner of the 2011 multi-year - sorry, Fantasy Shrink won in 2011! - preseason accuracy contest) and SI.

This year I decided to go ahead and put the spreadsheet into Dropbox, which should be an easy way for you to all get the excel version. If you have any issues with this though, just shoot me an e-mail. Otherwise, click here for the 2012 average position rankings spreadsheet.

For some of the nitty gritty, read on:

  • I gathered all the ranking within an hour or two this morning, but some sites had been updated more recently than others. I also tried to ensure that the experts all used the same scoring system (this is non-PPR) but many sites didn't note their scoring system at all.
  • As in the past, I've included the standard deviation for each player's ranking so that you can get an idea of how much consensus there was on a player's ranking across the 11 experts. What this means is that 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 created another column that adds the standard deviation to the average ranking to create one number to represent both a player's ranking and the level of agreement on that ranking
  • You'll find these 11 rankings listed as separate tabs in the spreadsheet in case you just want to look at the data from each site or even want to do your own analysis. 
  • I included bye weeks in here and have my fingers crossed that they're all accurate but don't be surprised to see an error or two in there since I added those in at the end of this analysis when my brain was semi-fried. 
I'll try to get an updated version of this done at the end of the month and if there's a site/expert out there that you'd like to see included, please leave a note in the comments.

Enjoy!

22 comments:

Anonymous said...

Awesome, thank you!

Anonymous said...

wohhoo thanks! just in time for weekend draft!

Anonymous said...

This is great. Thank you!

Will said...

Thrilled about all the great links and advice; this is my go to site for fantasy. I was curious about the difference between your spreadsheet and the consensus rankings that Fantasypros offer, and after looking at your spreadsheet, I definitely love the formatting and hard work you put into it.

Thank you so much for this.

Anonymous said...

Excellent work!

Anonymous said...

can you add fftoday and the third guy on cbs....how about fakefootball....great job as is if not

MelR said...

Is it wrong that I'm not telling anyone else in my fantasy football leagues about your site? It's Great Info!! Thanks for all the work you put into this.

Anonymous said...

How about a PPR version? Good work!

Anonymous said...

thank you, it is very much appreciated

Anonymous said...

Great stuff...but PLEASE, put up a PPR version!!!

Anonymous said...

Thank you!

Anonymous said...

Great work. Love your blog. There's one issue I have with the list that I'm not sure can be dealt with easily. There are players who are on some lists but not on others (presumably because they didn't crack the top 150/200). Because the APR and std deviation are calculated based only on those lists for which they appear, their APR is inflated. For example, the Chargers D have the highest APR for a defense even though they were only ranked on one list (KFFL). Clearly, the consensus isn't that they're the best defense, but they appear highest on the list. Note, KFFL didn't even have them as their #1 defense. One possible suggestion is to fill in the "blanks" with the ranking of the lowest positional player for that particular list. Example: Jahvid Best wasn't on "Ask the Commish" rankings but you could fill in the rank of the lowest RB (plus one if you'd like) that does appear in those rankings. I know it's a lot of work to look up all those positional ranks, but an easier method might be to just sub in the value 150 or 200. Although this would probably skew some players the other way.

Anonymous said...

PPR Version=Go to FantasyPros or just overvalue WR's and RB's who are in passing offenses. This clearly was a ton of work done for free, be grateful. Thanks for the list, it's been slaying my mocks.

Bruno Boys Fantasy Football said...

awesome job Sara!

Anonymous said...

love, love, love!!! I tried my own version of this a few year ago, and got no where close to your finesse! as others have stated, I hate to tell others about such a fabulous resource! (fingers crossed I say this at the end of the season!)

Anonymous said...

love, love, love!!! I tried my own version of this a few year ago, and got no where close to your finesse! as others have stated, I hate to tell others about such a fabulous resource! (fingers crossed I say this at the end of the season!)

Anonymous said...

love, love, love!!! I tried my own version of this a few year ago, and got no where close to your finesse! as others have stated, I hate to tell others about such a fabulous resource! (fingers crossed I say this at the end of the season!)

Anonymous said...

love, love, love!!! I tried my own version of this a few year ago, and got no where close to your finesse! as others have stated, I hate to tell others about such a fabulous resource! (fingers crossed I say this at the end of the season!)

Anonymous said...

love, love, love!!! I tried my own version of this a few year ago, and got no where close to your finesse! as others have stated, I hate to tell others about such a fabulous resource! (fingers crossed I say this at the end of the season!)

Anonymous said...

I would love for you to include rankings from 4for4 (FantasyShrink)

Anonymous said...

Thanks! Been following the site for years and you never disappoint!

Armchair Historian said...

Wow, this is incredible. Thank you for taking the time to do all this! Just a note to other folks out there; this is even more helpful when you add a filter in row 2 so you can sort by position.

If you do update this that would be awesome!