Now Reading
2020 Fantasy Baseball Draft Cheatsheets

2020 Fantasy Baseball Draft Cheatsheets

2020 Cheatsheets

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.

View Comments (89)
  • This is incredible thank you! Where would you like feedback directed? I noticed when adding my keepers that Will Smith (C) is not in the player pool. It seems like Buster Posey has taken his place as ranked 5th based on steamer projections.

    • Really cool stuff now that I can actually see everything. Considering how useful this will be and imagining the ammount of time you likely put in, I’ll certainly be donating in the future. Few questions:

      1) Is there a way to attribute multipositional eligibility into these rankings which I assume would affect the players WERTH.

      2) Would it be possible to add W-L as a category.

      3) Is there a way to attribute for a bench also in the settings (I assume, no, since bench doesnt have specifics on position so its going to vary from league to league.

        • Thanks! I include a bench setting for the Auction sheets as that is needed in the calculations of auction values. I haven’t included it in the Draft sheets as it wouldn’t really be used in any calculation but I understand people want the cosmetic satisfaction of seeing the accurate number of bench positions on some tabs. That being said, it’s a lot of re-coding to get that done so it’s not at the top of my list of changes I’m trying to implement for the next update. It’s been noted though.

  • Leaving feedback here works! Yeah, I was notified by somebody else that there’s something weird with Will Smith. I’m assuming something got mixed up with there being two players with that name. I’ll check it out and have a little update soon.

  • Thanks for the great work Luke!

    When do you expect to have “the search for Narco” ready? I targeted a few of the SP/Hitters that you recommended and worked out great! Thanks again.

  • Amazing tool! I used this last season with great results.

    I have one note regarding the projections. Under the “Your Own Custom Combination” option, you have Fangraphs – Depth Chart projections as an option, however if I give this any weight the projections do not fill in on the draft sheets. I’m not noticing this issue with any of the other projection systems. Selecting Fangraphs – Depth Charts alone from the Projections dropdown appears to work fine but I’m not able to include it in the custom combination projections.

    Thank you for creating this excellent draft aid!

  • Hey Luke, sorry if I missed this. But will you be doing your “Special Blend” projections? And will those be an option for “Projections to use” in your spreadsheet?

  • I’m in a dynasty league, and on the Rosters page, it has deep dynasty players that automatically go into certain positions that they won’t fill during the regular season. An example, one guy has Taylor Trammel as an OF prospect, so it fills it in his starter spot. Is there a way to adjust the positions so I can put back-ups in their correct position? Essentially, it autofills to fill the roster, but that’s not accurate to what others will be using as their normal line-up. Thanks!

  • After switching the settings to match my 10 team 5×5 Roto league I noticed that almost all of the players on the positions tab have a negative WTH. Can you give me a better explanation of this number and what it represents?
    Thank you for all the work you do on this sheet!

  • Once a player is on a team, on the Rosters page, you can right click on a player to force them to be a starter on that team’s roster and then it adjusts the lineup accordingly. Is that what you are looking for?

  • The cheatsheet will calculate league averages for you and replacement level players. Players that are above replacement level will have a positive value and players that are below replacement level (essentially the most valuable bench player) will be negative value.

  • Thanks for the reply. I’m actually trying to get players out of the starter section to see the gaps in the players starters, not necessarily into the lineup.

  • Hey man, great work, was just hoping you’d add a 5×5 H2H categories option. If not, no worries. Just seems to be a very popular league type

  • H2H Categories leagues are a type of roto league. As I mention above, if you’re in that type of league, download the roto sheets and that’ll have everything you need in there to manage your drafts. Let me know if you have questions though!

  • So I have no players rosters at the moment. Literally the only 2 players with a positive WTH are Trout (0.5) and Yelich (0.3).
    I was trying to use the WTH column to get a better ranking/value of players by position but the fact that all their numbers are negative has me concerned and confused.

  • When I try to “search for player” on the keeper tab, it says “Cannot run the macro “2020 Points draft cheatsheet v1.02.xlsm’!Search_And_Place’. the macro may not be available or all marcos may be disabled.

  • Any chance you could allow highlighting in a future update… I understand locking the spreadsheet but man if I could highlight a player rather then going through the notes section, this would improve interface greatly imo

    • Yes! Color-coding note types would be great. The entire row doesn’t have to be color-coded, just the Notes cell in the “Your Draft” sheet.

      • I’ve figured out a way to accomplish this and will be adding it to the next update. When adding player notes, you’ll be able to select if you want to highlight that player or not (choosing whether to highlight them in green or black, depending on whether it is a positive or negative highlight).

  • Thanks again for the tool! Quick feedback on one setting. When changing the league budget per team on setting tab, team #3 remains at the default $400 amount on projected standings. Thanks!

  • Luke, Gretat job once again!I apprecite all the effort and will be hitting the donate button.
    I am having one issue. While on the “Your Roto Draft” tab, clickinh any cell throws a VBA error. It states :Compile error in hidden module” and then points to either module 1 or sheet 2. I can send you a picture if you like. Running a 32-bit version of Office 13, macros are enabled and the file is saved as an xlsm type.
    Thoughts?

  • I can’t seem to get the save/load copy paste to work. Every time I try it tells me “This action won’t work on multiple selections”

    • Try unselecting the columns in the sheet you’re copying from before you paste it into the new sheet. I’m guessing it may think you’re trying to paste on both spreadsheets if columns are selected on both open workbooks. Just a guess though.

  • Was hoping for some help here, not sure what I’m doing wrong. I had this problem last year also but it doesn’t seem like anyone is having this issue.

    I’m clicking on the ROTO Draft cheatsheet and google docs comes up and it is just a blank spreadsheet with nothing written in. I don’t have Microsoft Office and usually when I try opening an Excel spreadsheet it will load up in Google Docs/Google Drive so I’m not sure if anyone has any guidance on what/why this is happening. Any help would be appreciated.

      • Thanks Luke. I think I have an install file of microsoft office somewhere on an external HD, although its a bit of an older version but hopefully it will still work. I did get it to load up on safari somewhat and looks like it has so much more info than i expected. Looking forward to playing around with some of the customizable options once I can get it to work. Thanks for all the hard work you’ve obviously put in to this spreadsheet.

  • Hello! Thank you so much for these sheets – they’re lifesaver!

    I got two questions for you:

    1) Would it be possible to add projected Plate Appearance / Innings PItched to the Your Roto Auction page? Thats the main page I interact with most during my auction. Its nice to get a sense of how PA/IP players with the lower value platoon players and project mid-season call ups for us in deeper leagues.

    2) I use the imported, custom auction values for the chosen site value column on the Your Roto Auction page. When I change the number of teams (12 -> 15), it applies an inflation on those imported values. Is it possible to disable that behind-the-scenes inflation for custom imported values?

    Thanks!

  • Points Roto sheet I think your OBP formula is wrong. Looks like it’s on base divided by AB and not PA
    Everyone’s OBP is way too high in the Steamer projections as listed on “Your Points Draft”

    Thanks for all the hard work you do!

  • how can I set the roster size to a certain number? We have 23 total players, but some teams go in with anywhere from 6 to 10 keepers. Can I make the draft show as team’s max out? Oh, by the way. So far I think your cheatsheet is awesome!

  • Is there a way to input keeper values and have the remaining pool calculate the projected value based on the dollars remaining after keepers?

    • Record all of the keepers as if they are the first players taken in the auction and the spreadsheet should automatically update to give you what you’re looking for.

  • Is there a way to unlock the draft page so I can change the color fill on players I’m targeting or avoiding? I’m trying to customize it for my draft tomorrow night (Sunday, March 8).

  • I am trying to add two sheets to the document, preferably via Move/Copy function but when I do that, nothing happens, and when I try to add a new sheet or copy/paste info, I get an error message saying “This action won’t work on multiple selections”. I had no issues doing the same thing with the previous 2 versions of the spreadsheet so I’m wondering what I’m doing wrong here. Thanks.

  • Hi Luke,
    Thanks for everything.
    I tried to cut and paste columns A through L to update tonight and it didn’t work. The Save and Load page changes (and stays changed after I close the program and reopen it) but all of the other sheets stay blank.
    Can you verify to see if it’s a problem on your end or if my computer just hates me?
    Thanks a ton,
    DB

  • Hi Luke,

    Hopefully this is a simple fix. On the Player Notes page, Player Notes field, attempting to edit this field erases the entire field. It would be nice if I could edit rather than re-type this field.

    Thanks,
    Tom

  • I am still pretty new to fantasy baseball, this will be my 4th year. Does anyone have any helpful suggestions on how they manage the spreadsheet live? Between entering who has been drafted and making a decision on your next pick, I feel it can get a bit much at times in the heat of the moment.

    • It really depends on your draft style. If you’re in a fast draft that has like 60 seconds per pick, the spreadsheet would be crazy hard to manage in-draft. If you have a good amount of time for each pick, just update it as it gets close to your pick so you can start to see who you might want to draft.

          • Yeah, I have to do a lot of prep. I have my speadsheet, targets, guys I want to avoid, etc all on it. I usually have a few tiers from various sites pulled up. It helps me when the draft starts to get of hand.

            Between picks is when I have to make sure I have a group of guys I like qued up.

            Your position list could help me a lot live. I can probably quickly highlight the names of guys that are selected. Pre mark guys I like with a different color.

  • Thanks for the special blend update! 1. Kipnis is listed with CLE. 2. I am not able to copy over the save sheet from the old to the new, but i am wondering if this is an office on mac thing.

  • This action won’t work on multiple selections. The work around is to copy then close the original spreadsheet and then paste to the new version. o well.

    • Yeah. If you get that error when loading data into a new sheet, it is likely because you still have columns selected in the sheet you’re copying from so Excel thinks you’re trying to paste into both sheets. Deselect the columns in the old sheet before pasting into a new one.

  • What am I doing wrong? When I make changes in the settings it doesn’t seem to do anything to the cheatsheet. For instance, if I zero out the 1B position entirely it does nothing to the rankings or if I add an absurd number of starting SPs the rankings dont change. Is there a recalculate button I’m missing (macros are enabled)? Thanks in advance.

    • Sounds like you have Automatic Calculations turned off within Excel at the moment. Try finding that within the Excel settings and turning that back on and see if that fixes your issue.

  • I’m in a 5×5 H2H Categories league. Is the roto spreadsheet able to accommodate if I wanted to punt on a category or two? Would I just not select those categories? Or should I select them, but mark “half” to lessen their effect? Thanks!

  • On the cheatsheet, what’s the difference between the Special Blend and the Special Blend w/Steamer Replacements projections?

    • I need to take out the Steamer replacements option most likely. In the past, the Special Blend projections didn’t have as many players projected as the other systems (because part of the blending process used a source that didn’t project as many players). As a result, I had that option to replace any unprojected player with a Steamer projection. It’s not as relevant anymore now that my blending process includes more players.

  • Great stuff Luke! Love the spreadsheet. Downloaded the latest two versions of the Roto Auction (1.10 and 1.11). Noticed an error on mine that Kirby Yates has lost his stats so isn’t listed in the “Positions” tab. If I search for him in the “Your Roto Auction” tab, he comes up at the very bottom of the spreadsheet with no stats. Not sure if it’s something on my end or if others are seeing it too. He does show up in your initial version (1.02) with stats. Thanks!

  • Great Job, thx for the hard work.

    Quick question, I am in a 6×6 ( runs, hr, rbi. sb. avg. ops) (wins, loses, saves, KOs, ERA, WHIP) categories league on yahoo h2h. however we get points for each category as a tally. So If a guy on my team hits a HR, I get one point. Whoever has more hrs at the end of the week wins that category.

    how would i set up your cheat sheat? which style should i pick? thanks for you help bud

  • Will Smith (C) looks like he still has some issues, at least on the Roto sheet. His ADP is blank on the Your Roto Draft tab so he shows up really low. And he doesn’t show up on the Positions tab (maybe the same reason?). Thanks for all the great work, these sheets are amazing.

  • Hi, ive noticed in the roto auctions latest update the majority of set up men have 0 or very few holds projections. Example Yankees’ Ottavino, Kahnle, & Britton are projected for 0 holds.

  • Luke awesome data and cheat sheets as always dedicated fan doing draft today and your tools are key to winning a bunch. Happily send along some $ for the good karma. Best of luck – thajakel

  • Hey Luke,
    I hope you are healthy and hanging in there during this challenging time. I realize we don’t know when (that’s right I’m optimistic) baseball will start this year but I was hoping to see your updated cheat sheets with your multi-positional logic and possibly some more current ADP and rankings. I’m still puttering with mock drafts and trying to keep hope alive…lol.
    Stay safe,
    Tom

  • Very cool spreadsheet! I’m a bit of an Excel geek, so I can image that it took to put all this together!

    Something that would be helpful (to at least me, and I think other people), is to include the target player draft position on the Player Notes pages so when you’re making a decision on whether to add a lower or higher note you know where they are to begin with instead of toggling back and forth between Player Notes and Your Roto Draft. It seems like something like =match(a3,’Your Roto Draft’!C$11:C1000) should returns their position, but every time I put it in the Player Notes section it wipes it out so I can’t be sure.

  • Hi, awesome sheet! But I think one of the Data Validations is broken on the settings tab of the Standard Roto sheet. It isn’t able to locate the list of Roto categories and therefore nothing can be entered or removed from the cell. Is anyone else experiencing this issue?

  • Donated today. Thanks for the hard work. It’s quite impressive.
    Feedback:
    – Ohtani – as a pitcher, I don’t see him in the spreadsheet. During the draft I couldn’t find him, and then got totally lost trying to figure out how to skip to the next team because it kept going back to the team that had the empty draft slot. I finally found “Unlisted Player” …but seems like Ohtani as a pitcher is good enough that he should be in there.

    – I got a REF#! error about 18 rounds into my draft, and I had to bail on the spreadsheet. Error was shown on the draft log, and I was going to try to just copy and paste the row above into the cells, but it wouldn’t let me because the sheet is protected. I totally get protecting the sheets so that dumb mistakes can’t mess everything up…but I had no luck at all trying to solve the problem, and basically the last 8 rounds I had to go without it…which was a bummer.

    • Yes, the Ohtani issue is one I was trying to work into the spreadsheet when baseball shut down in March. I have new formulas to handle him and plan to introduce them next year. In the meantime, if you wanted to just switch him to a pitcher then use the Change Position option to see that. He’s only one player currently. In future versions, you’d choose how to treat him in your sheet based on your league settings… I just didn’t fully build it out and then the season shut down and they came back at a time when I wasn’t really prepared to continue that project.

      Appreciate the donation and sorry about the error… I’m not sure what that is as it’s hard to troubleshoot with just that information there as I’m not totally sure the issue. I haven’t encountered that error in my own drafting but sorry it messed you up. That sucks.

      And, yes, there were plans to implement features such as highlighting players either via the Notes tab or when you draft them and I had built out portions of that concept but then, you know, the season shut down. It just messed up a lot of concepts that I was working on and I couldn’t immediately flip things on when they decided to bring the season back. Thanks again for the donation. It’ll help pay for the server costs to keep this going another year.

  • One other thought…
    Allow the user to designate which team they are…and when a player is drafted to that team, the name gets HIGHLIGHTED on the positions tab so that you can quickly and easily see which players have been drafted to each position, and also you can get a quick look at where those players fall in the position rankings.

Leave a Reply

Your email address will not be published.

© MR. CHEATSHEET (EST. 2010)
Scroll To Top