Skip to main content

Updated Average Rankings Spreadsheet

I've got your updated 2011 Average Rankings Spreadsheet, my friends. Read my post from earlier this month for all the appropriate warnings and remember to use this wisely. I do have a few changes though this time around - I've included Razzball.com and ProFootballFocus.com and dropped FOX since they hadn't updated their rankings since July. July?! No dice. Only the best for you all. I also snagged way more than 100 rankings per your request so there are now a whopping 280 names. I'm sure you may find an error or something bizarre in here, but hopefully those are limited - do let me know if you see something though. I will say that somehow one site ranked kicker Dan Carpenter 103rd overall, which shot him way, way up the average rankings...he does not belong where he is listed. I can say that unequivocally and it's an excellent lesson for why you must use your brain and own opinions here, too.

I'm currently adding in bye weeks, which I know is something that you all wanted so hopefully they will all be there in the next day or so. I'm also considering compiling this list for PPR, but not sure I have enough time and rankings. If you know of a top 100+ list for PPR that you want included, let me know.

I'm linking you all over to the Google Docs version but if you want the excel version, e-mail me and I'll send it your way soon. If it's urgent (i.e. your draft is in 12 hours or less), note that in the subject line.

Happy drafting!

Comments

Anonymous said…
You should just upload the file to a website like mediafire.com and post the link here, so anyone can download it instantly rather than request it via email.
Anonymous said…
Thank you for providing this info, which I know takes considerable amount of time to prepare.

Since you now live in K-town, GO VOLS!
Anthony said…
YOU. FRIGGIN. ROCK.

Thank you so much again.
Jason said…
Sara,
I'd love to see some PPR compilations. That's all I play in anymore. If you get a chance.
Thanks
Anonymous said…
You asked for info on errors in data. NFL ranking is missing:
74
75
77
78
80
81
83
84
86
87
89
90

Also - why delete the earlier comments?
Anonymous said…
The following ranks are also missing:

Razzball: 105
KFFL: 40, 81
SI: 66, 84, 137, 190
Anonymous said…
For those of you wanting to save a copy of the spreadsheet yourself, its really quite simple. Just click on the link to open it up in Google docs. Once its up, look at the url... at the end, you will see "&output=html". Change the "html" portion to "xls" and hit enter. Voila!
Hi all, thanks for the input. It looks like in the data clean-up chaos I might have some errors with the NFL.com data. My apologies. Will try to fix this weekend. The others mentioned I'll also look into.

I'm not sure which deleted comments you're referring to - NFL.com's player comments? I use a program called Stata to do all the data work and the comments/big text fields can't be included in that.

Thanks for comments everyone!
Anonymous said…
I have been doing something similar myself on a smaller scale for years - you are saving me so much time and effort, thanks! I am in all PPR leagues though so please add if you have time.
Anonymous said…
Hey Hey Librarian - Hurricane locked in NYC. 3 drafts approaching (first is on Monday) - would love to see those PPR league compilations . . . all I got is alcohol and internet (for now) until the power or floods start and my priority is not filling up my tub with water, rather it is getting my draft sheets prioritized! Thanks again for all you do it is truly aweosome.
This comment has been removed by the author.
Mike K said…
I noticed an error, there are rankings for both Benjamin Watson and Ben Watson for TE. I'm sure no one is staking their draft on Benjamin Watson's ranking but figured I'd help since I noticed that.
Jonny said…
Just finished my draft and this helped me out big time. Thank you!!!
rageear said…
People can get a Excel (.XLS) version of the spreadsheet via a slightly modified Google Docs link:

https://docs.google.com/spreadsheet/pub?key=0Alg27u7pZclWdFhyRkVYZHNhUTVSdjhIWkVnN2Vpcmc&output=xls
Anonymous said…
No posts in almost 4 days - awesome!
JPE said…
this is awesome, thank!
Unknown said…
Just a little tip -- anyone can copy the Google Docs spreadsheet contents into Excel. Just copy the contents into Notepad first... and then from Notepad into Excel. It fixes the formatting.
Anonymous said…
Hey There...
I see that the bye weeks don't go through the entire list, are you looking to complete that?


Thanks for helping me become a CHAMP last year!
Anonymous said…
Great job on this! Thank you very much.

Were you able to update your list for PPR leagues?

Also, the rankings have changed a bit for some of the websites you noted, hence the overall ranking may be affected as well. Just an observation. Thanks very much this is a great time saver.
rageear said…
I drafted last night using the spreadsheet as a guide and noticed that the Kicker rankings are a bit wonky.

Dan Carpenter is listed as K1, but he only cracked the top 200 in two of your sources.

Compare that with Gostkowski or Rackers, who appeared in the top 200 in 7 of the sources.

I know that Kickers aren't everyone's top concern, but thought I would mention it.

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