Wednesday, August 11, 2010

2010 Average Rankings Position Spreadsheet


It's time for the 2010 Average Rankings Position spreadsheet! I snagged the latest Top 100 rankings from 9 different websites and they're updated as of this evening, August 11th. I'll be conducting an update at the end of August for those of you who have drafts at the end of the month. The sites I looked at all provide their rankings for free on their sites and they include: Ask the Commish, CBSSports.com (note: CBSSports.com is providing 2 different sets of rankings this year), ESPN, FFToolbox, FOX Sports, KFFL, NFL.com, SI, and Yahoo.

A few things to note about the spreadsheet:
  • This is just an average of Top 100 players. 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 so that they represent rankings from the same time period/news/injury updates, etc.
  • As in the past several years, I assigned a ranking of 125 to any player that wasn't ranked in the Top 100 by a site. For example, several sites did not rank Vincent Jackson within their Top 100 players, so I gave Jackson a ranking of 125 from those sites to try and represent that missing rank.
  • 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. 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. 
  • With my late August update, I'll try to incorporate the bye weeks for each player if that's of interest to everyone - just ran out of time tonight and wanted to get this posted for you all ASAP!
To view the full average rankings, see the Google Docs version or send me an e-mail and I'll shoot over an excel version your way. But here are the top overall 30 players across all positions for the 2010 season according to the average from 10 experts (9 sites):

Name
AVERAGE
STD DEV
AVG + STD DEV
Chris Johnson
1.20
0.42
1.62
Adrian Peterson
2.00
0.82
2.82
Maurice Jones-Drew
2.90
0.32
3.22
Ray Rice
4.00
0.47
4.47
Frank Gore
5.80
0.79
6.59
Michael Turner
5.80
1.23
7.03
Andre Johnson
8.00
1.63
9.63
Steven Jackson
8.90
2.69
11.59
Randy Moss
11.80
2.62
14.42
Aaron Rodgers
12.10
4.09
16.19
Drew Brees
12.80
5.98
18.78
DeAngelo Williams
13.90
5.53
19.43
Larry Fitzgerald
16.20
6.88
23.08
Reggie Wayne
16.60
4.27
20.87
Rashard Mendenhall
17.00
6.75
23.75
Peyton Manning
17.00
7.23
24.23
Shonn Greene
20.00
5.64
25.64
Cedric Benson
20.10
7.71
27.81
Ryan Grant
22.00
9.09
31.09
Ryan Mathews
22.00
14.82
36.82
Miles Austin
22.50
7.49
29.99
Roddy White
23.30
4.92
28.22
Calvin Johnson
23.40
8.07
31.47
Brandon Marshall
23.60
7.81
31.41
DeSean Jackson
26.90
7.49
34.39
Tom Brady
27.40
10.57
37.97
Marques Colston
28.40
5.97
34.37
Beanie Wells
29.20
7.24
36.44
Matt Schaub
30.30
7.32
37.62

8 comments:

Slamdunk said...

I appreciate what you are doing with your blog. Being new to fantasy football (but a lifer NFL fan), I was unaware just how much information there is on the topic.

Visiting a site like this that tries to makes sense of the many opinions is helpful.

Keep up the good work.

Sean Douglas- fantasy-info said...

Hello,

I noticed your website while surfing around on the internet and I think it's a very informative FF website.

Wanted to know if you would be interested in exchanging links with our website fantasy-info.com.

Best of luck in the future,

Sean E. Douglas (website owner)

BDT said...

Any way to get a PPR spreadsheet? Thx

ScottA1A said...

I like the rankings! Do you take a culmination of a bunch of rankings and put those results into your own formula?

I'll refer others to this blog so keep it fresh!!

Enjoy the pre-season hype!

Anonymous said...

good work as always, can't wait for the MONSTER league to start ! -potlicker

Adam said...

This sheet was my secret weapon last year, and it will be again. Gracias

Dave said...

Sara, great stuff as always. We've got our consensus ranking tool up now, so please come check it out.

http://www.fantasypros.com/nfl/rankings/consensus-cheatsheets.php

You can select to combine all experts or just the experts you want. We also have separate rankings for PPR.

We'd love any feedback that you have!

claysta said...

This is my favorite FF website. It's really the only one I have to remember every year. So, Thanks!