FanGraphs Consensus Rankings Draft Spreadsheet
Hope this is just in time for your draft!
Our ranks, plus Steamer projected hitter numbers and ZiPs projected pitcher values, all in one downloadable place.
Thanks to our rankers for working tirelessly on these rankings: Mike Podhorzer, Zach Sanders, Jeff Zimmerman, Alan Harrison, Ben Pasinkoff and Colin Zarzycki.
With a phone full of pictures of pitchers' fingers, strange beers, and his two toddler sons, Eno Sarris can be found at the ballpark or a brewery most days. Read him here, writing about the A's or Giants at The Athletic, or about beer at October. Follow him on Twitter @enosarris if you can handle the sandwiches and inanity.
I don’t know how to “enable Google spreadsheet,” whatever that is. Can’t you just post it in regular Excel?
and thank you. he also meant to say, “thank you.”
Sweet! Thanks!
You can download the Excel file from that page, too
Thanks a lot guys!
I was wondering whether you were planning to release a top 100 or 200 list?
i find those useless…when your going that far down a list it begins to become more a function of need (position or category). I laugh at the these places that do top 400 lists. theres no utility
A top 100 list is “that far down a list”? How did you turn top 100 or 200 into top 400? I see no reason why a consensus top 200 couldn’t be a useful thing to have on hand during a draft.
And thanks guys, this is great.
We’ll try to do a top 300 next week. thanks!
Sure. Because by the 8th, 9th rd i’ll weigh more heavily a positional or categorical need over a guy who is ranked 80 vs 100 in an aggregate ranking. The guy ranked 80 might pickup SGP’s that are less important to my team based on how i’ve drafted to that point.
Further, a consensus ranking isn’t going to catch the intricacies of different league formats nor the dynamics of how a draft may be progressing.
I find it much more useful to reference the positional rankings and use a more open minded approach to where certain players fit in the big picture at that point in the draft.
That would be very helpful!
Nergasm!
Oh this is just awesome, thanks guys!!
One spreadsheet junkie to another, you need to alter your formula on RP to look for Josh Fields, not Joshua Fields. I am such a nerd…
That’s my bad. I will fix ASAP. Thanks!
why did you pick steamer for batters and zips for pitchers as opposed to just averaging them all? thx
I was curious also, why not the reverse? Or one or the other. What was your thinking on this? Thanks!
Time was a factor. Also: I find the steamer pitching run environment too high right now.
“I find the steamer pitching run environment too high right”
???
era’s are too high because of too many runs allowed forecast?
not sure what you mean.
thanks
Bob
Steamer will update Monday.
Nice to finally get some love. No other site respects me.
Great stuff. Thanks for sharing Eno.
thanks. this is cool.
cant open the link – it says “GOogle drive, the app is currently unavailable”
The SP projected numbers im seeing seem to be the steamer numbers?
Thanks!!!
This is awesome. Thanks a lot Eno!
This is awesome! Thanks for the great tool.
Eno, you the man, many thanks!
Great work, as always. In the future, would it be possible to list whether or not the player is in the AL or NL? That way, those of us in AL- or NL-only leagues could easily filter out players in the other league.
CH Smoot, are you a luddite?
this is unreal.. thank you guys so much for making this available!
You guys are awesome! Thanks!
Only noticed bc I’m looking at tweaking some projections for players I may platoon, but Brandon Moss projection in spreadsheet is substantially lower than Steamer projection when you bring up through projections/steamer link.
Seriously, nobody notices that all these numbers are different from the steamer projections? Can someone explain please!
I got the steamer projections for the batters off the steamer page here http://www.fangraphs.com/projections.aspx?pos=all&stats=bat&type=steamer and the ones on the player page are perhaps more informed by our depth charts for playing time. I used ZiPs for pitching. Steamer will update again Monday.
This is great. Thank you, gentlemen.