If you’re a fan of this site, you may have noticed that my fantasy baseball cheatsheets are coming out a bit later than usual this year. It’s for good reason. I completely overhauled the cheatsheets to make them functional on Macs (for Excel 2011 and later, that is) in addition to Windows computers. That wasn’t possible in the past. While doing these overhauls, I ended up reworking some of the functionality of the cheatsheets themselves and introduced new features as well.

Let’s take a dive into what these 2017 version of my cheatsheets offer you.

What Makes These Cheatsheets Special?

They’re free and they’re awesome! More specifically, these spreadsheets are designed to accommodate almost any variation of fantasy baseball leagues that you can think up. Roto-league owners can choose from a long list of potential stat categories and point-league owners can input their scoring system right in the sheet. Once you get everything set up, the cheatsheet allows you to choose which projections you want to use and then generates custom rankings and values that are unique to your specific league. There are a lot of things that can affect player value, including number of teams and roster size, and all of that is taken into account in these valuations in the sheet.

In addition to giving you unique league values, you can track your draft as it occurs to see your strengths and weaknesses and to see your league rosters and best available players.

And, if you like options, you get tons of ’em within these spreadsheets. You can choose from a variety of rankings, projection options and ADP or auction value options as well. Your cheatsheets will be catered to whatever options you do choose.

What’s Changed From Past Years?

A lot. The main things to note for draft leagues are:

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.

For auction leagues, the main difference being that you can enter your auction picks from the top of the page. You’ll also have an auction history in a tab too that you can edit, if needed. For auction leagues, I’ve also spent some time working with the formulas surrounding player values so they should be improved from previous years.

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. But, here’s what is in there:

Projections Sources: Steamer, ZiPS, Fangraphs, CAIRO, Clay Davenport

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

Auction Values Sources: FantasyPros, CBS, Yahoo, RotoChamp

Expert Rankings Sources: FantasyPros, Fake Teams, 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 2017 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: 2.58, uploaded on March 28 at 4:45 PM EST)

Download the cheatsheet for your rotisserie auction draft leagues

(Current Version: 2.58, uploaded on March 28 at 4:45 PM EST)

Download the cheatsheet for your points-based league drafts

(Current Version: 2.55, uploaded on March 28 at 4:45 PM EST)

Troubleshooting

I’ve tried testing these as much as I can and sent them out to others to test too but there’s tons of different scenarios to account for and tons of different types of computers that we all have so I can’t guarantee that everything will work perfectly (but I hope so!). So, if you have issues with the cheatsheet, post them as comments here so I can try to address them. If you have suggestions for ideas or features, let me know too. I’ll post new versions of the sheet up until Opening Day with bug fixes, data updates or new features so keep checking back.

Donations

Okay. Truthfully, I debate every year about whether I can dedicate the time to making these cheatsheets. I’m just one man doing this all by myself and it’s a lot of work. In fact, I tend to always forget how much effort and time these take to make until I’m knee-deep in them. I do them for free every year though because I’m happy that people seem to appreciate the work. That being said, it would make it a lot easier for me to keep doing this if I got a few bucks here and there as a thanks. If you’re cool with that, the donate button is below:



I want to keep these free and I want to keep doing these each year so I’d appreciate it but, if you can’t spare it, don’t worry! Enjoy the free awesomeness regardless.