I’m not dead yet. I know there was some concern about whether I’d be publishing anything in 2018 due to the lack of updates thus far but, look, here I am updating and posting a thing. A very important thing in fact! This thing I’m publishing today is why the site has cheatsheet in its very name. Yup, here are the beautiful 2018 cheatsheets in all their glory and they are free for download as always.

Last year was a big year of overhauls for these Excel cheatsheets as I implemented countless new features and made it so the cheatsheets could be used on both Mac and Windows machines. This year, we’re rolling ahead with those versions as they worked so well last year.

Fire up your latest version of Excel and let’s dive into these crazy monster spreadsheets.

What Makes These Cheatsheets Special?

Gosh, that’s a good question. At their heart, they are designed to accommodate almost any off-the-wall variation of a fantasy baseball league that you play in. Do you play in a 10×10 roto league with lots of wacky categories? Yeah, this will cover that and cover basically any league you throw at it. The spreadsheet takes your league settings and generates player values based on your league so you know what a player is worth in that league world. Once the draft gets going, you can keep track of it in the spreadsheet and it will update projected standings and rosters for you so you can analyze the crap out of your league in real-time.

Also, there’s just tons of options in this spreadsheet when it comes to different projections to look at or auction values or whatever you want to know from various places around the internet.

What’s Changed From Past Years?

For those that missed last year’s updates, here are some of the highlights:

For straight drafts, the cheatsheet tracks draft order now. As you enter picks, it automatically will fill in who thinks has the next pick based on your settings. This allows for there to be a draft history in a tab now. This also means you can trade draft picks within there.

Since the cheatsheet tracks draft picks and order, you can also now enter keepers in separately so they don’t affect draft order.

During the draft, instead of scrolling around, you can enter all picks at the top of the page now by choosing the teams and players drafted and clicking Make Pick. Or, you can enter picks into the Draft Log directly if you wanted. You’ve got a few options.

What Data Am I Pulling In?

There’s a ton of data in here and most of it isn’t mine. So I owe a big thanks to all of these sources.

Projections Sources: Steamer, ZiPS, Fangraphs, Clay Davenport

Average Draft Position Sources: FantasyPros, CBS, ESPN, Fantrax, Yahoo, NFBC

Auction Values Sources: FantasyPros, CBS, Yahoo, RotoChamp

Expert Rankings Sources: FantasyPros, Yahoo, CBS, ESPN

WERTH Values (Roto Leagues)

If you’re playing in a roto league, you may notice that these cheatsheets have a WERTH value for each player. These are essentially z-scores in each roto category based on your league setting. The cheatsheets calculate who the projected league starters would be and then use that to calculate league averages and standard deviations in each category. Using that data, it then says how far above average each person is in that category (z-score) so a positive WERTH value means that player will contribute positively for your team. This is all dependent on your league settings which makes these values completely unique to your league.

Download Your 2018 Cheatsheet

Without further ado, pick your flavor of cheatsheet from the options below. Go out there and kick some butt in your fantasy leagues!

Download the cheatsheet for your rotisserie standard draft leagues

(Current Version: 1.55 uploaded on March 25 at 12:35 PM EST)

Download the cheatsheet for your rotisserie auction draft leagues



(Current Version: 1.55 uploaded on March 25 at 12:35 PM EST)

Download the cheatsheet for your points-based league drafts

(Current Version: 1.55 uploaded on March 25 at 12:35 PM EST)

Troubleshooting

In the interest of getting these out into the world as quickly as possible, I admittedly didn’t get a chance to utilize beta testers this year. So, please let me know if you encounter bugs or issues with the sheets as you play with them. In the month ahead, I’ll work on addressing those as well as trying to optimize these spreadsheets to run faster (I know these initial versions are a bit bulky and may run a bit slow). You can keep track of my spreadsheet updates by following my Twitter where I’ll let you know when updates happen.

Donations

I’ll be honest. These take a ton of work. I want to keep these free. I know there are resources like mine out there that charge money but I’ve never wanted to go down that road. That being said, donations help keep this site afloat and keep me wanting to come back and do these each year so I’d appreciate any small donations you’d give to help fuel my coffee addiction and such. If you’re cool with that, punch the donate button below:



Hope you all enjoy the sheets and have a great 2018 season!