Fantasy baseball draft season is approaching! Scrap whatever you were doing because I officially welcome you to the eleventh year of Mr. Cheatsheet. I’m here, once again, at your service to help you win your fantasy leagues aided by the craziest Excel spreadsheets in the land.

I create highly customizable and data-overloaded spreadsheets every year that can handle any single league you throw at it. The general idea is that you take your crazy league settings, enter them into the spreadsheet and get advanced projections and analysis catered to your specific league settings. From there, you can conduct your entire draft from within the spreadsheet and get insight and knowledge throughout the draft to help give you an edge over your clueless leaguemates. Sound good? Then let’s rock.

What Makes These Cheatsheets Special?

I, myself, play in a variety of fantasy baseball leagues and every single one of them is different. There are auction leagues instead of snake drafts and there are keeper leagues instead of redraft leagues and there are points leagues instead of roto leagues. The list goes on and on. Considering that’s just me, I can only imagine the infinite number of fantasy league varieties that exist in the universe. As a result of there not being one standard way to play fantasy baseball, I built these highly customizable spreadsheets to help aid anybody with their unique league type, no matter what crazy settings you may have.

Once the draft gets going, you can keep track of it in the spreadsheet. You’ll be able to see projected standings and all sorts of data during your draft so that you can make educated decisions when your time to pick comes up.

If you are in a keeper league, you can enter your keepers in and the cheatsheet will take those into account. If you’re in a roto auction league, you can run it from the cheatsheet and get custom values based on your league settings that change during the draft based on your league’s inflation rates. The possibilities for what these cheatsheets can handle are (nearly) endless.

What Data Am I Pulling In?

This spreadsheet would be pretty mundane and boring without all the options that are included in it. You can choose from a ton of different baseball projections, or ADP data, or auction values, or expert rankings. I owe a great deal to all of those services for existing. I’m simple offering a tool that puts them all at your fingertips.

As the draft season progresses over the next month, these options will expand a bit but here’s what you can find inside this first version of the 2020 cheatsheets.

Projections Sources: Steamer, The BAT, ZiPS, Clay Davenport, Mr. Cheatsheet’s Special Blend

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

Auction Values Sources: FantasyPros, CBS, ESPN, Yahoo, RotoChamp

Expert Rankings Sources: FantasyPros, Yahoo, ESPN, RotoChamp

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, which shows you how far above or below average each player is in comparison to the replacement level for your league. 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 2020 Cheatsheet

I’m excited to announce that there are four different varieties of cheatsheets this year. I’m introducing a Points Auction version for the first time, due to popular demand. It took a lot of work (thus the slight delay in the release of these sheets this year) but it’s finally here! Rejoice, my points auction friends. But let’s dive deeper into your options this year.

Roto Leagues

If you play in a rotisserie league or a H2H categories league, you’ll want to download the roto cheatsheets below. You can either choose the draft version if you have a typical fantasy draft for your league, or you can choose the auction version if your league conducts an auction instead of a straight draft.

Download the cheatsheet for your rotisserie standard draft leagues

(Current Version: 1.19 uploaded on July 21 at 6:15 PM EST)

Download the cheatsheet for your rotisserie auction draft leagues

(Current Version: 1.19 uploaded on July 21 at 6:15 PM EST)

Points Leagues

If you don’t play in a rotisserie league, you likely play in a points-based H2H league that scores a bit like fantasy football where players are awarded points for each stat they accrue based on your scoring system. If you are in a Points league, you can download the draft or auction version of the spreadsheet below based on your draft type.

Download the cheatsheet for your points-based league drafts

(Current Version: 1.19 uploaded on July 21 at 6:15 PM EST)

Download the cheatsheet for your points-based league auction drafts

(Current Version: 1.19 uploaded on July 21 at 6:15 PM EST)

Troubleshooting

There are instructions within the cheatsheets but questions may still arise. Post your questions in the comments below so I can answer for others to see.

While I did a bunch of testing on these prior to their release, it’s hard to test out every conceivable scenario so it’s possible you may encounter a bug or error that I didn’t catch. Let me know about that as well and I’ll post updates as needed. You can keep track of spreadsheet updates by following me on Twitter where I post about any minor updates that may happen.

As new cheatsheet updates are released, you’ll want to utilize the “Save Or Load” page in the cheatsheet to copy and paste your custom data into new updates.

Donations

These cheatsheets are free! And I do that because I want them to reach as many people as possible. If you play in a $10 fantasy league, it wouldn’t make sense to pay $5 for a spreadsheet to help you. But you should still be able to dominate your league. Anyway, there are still costs associated with keeping this website up (in addition to the man hours I put into making these) so I do appreciate anyone who would like to offer a donation to me so that I can buy coffee or something like that.

We made it to 2020, y’all! Let’s go out and win our fantasy leagues once again. Have fun with the cheatsheets and good luck.