2019 Fantasy Baseball Excel Cheatsheets (Roto and Points Leagues) | Version 1.50

A few weeks back, the first version of the fantasy baseball cheatsheets were released into the ether. There have been a number of minor requests, bug fixes, and ideas that the community has suggested since that time. There were also a couple big free agent signings since that time. Like, hey, I heard that Bryce Harper guy signed with a team! Needless to say, it’s time for an update to the 2019 sheets.

If you are completely unfamiliar with the cheatsheets themselves, it may be more helpful to read over the post about their initial release first. For the initiated, let’s talk about what’s new in this version.

What’s New In Version 1.50?

In this iteration of the cheatsheets, there are a number of normal data updates but I also addressed some suggestions that people made in the comments. Here are the new things that you will find in the sheets as you open them up:

Updated in all three versions

  • ZiPS projections are now in the sheet
  • The first draft of my Special Blend projections are in the sheet. I’m saying “first draft” because I plan to tweak some things with these in the days ahead that may result in them changing a bit. I’ll be posting the “official” version to the site when that process is done. For the moment, the projections are using the weighting system from last year.
  • Yahoo ADP is now in the draft sheets
  • All ADP, projections, rankings and auction data that were already in the sheet are updated
  • From this update on, Player Notes will be able to be carried over in Save/Load
  • You can now enter custom Note Types on the Player Notes page instead of choosing from a list
  • Players that have signed to teams are now on their new teams
  • Player notes about injuries have been added in
  • For roto leagues, three pitching categories were added in (BAA, Games Finished, IP-ER)
  • Various bug fixes and tweaks

Updated in Roto Auction sheet

  • A team’s total initial value is now visible on the Teams page
  • On the settings page, you can choose to do a global inflation amount for your league. If you feel the projected values are too high or low for how your auctions go, this will allow you to adjust the amounts across-the-board

Updated in Points Draft sheet

  • Added a player’s ranking in projected points as a column to the Draft page

I still have a number of updates in mind but this version should address most of the big things that have come up in the comments over the past few weeks.

Which Data Am I Pulling In?

In addition to what was mentioned above, you have lots of options when it comes to data in these spreadsheets. Here’s the updated list of the different sources of information you can find inside:

  • Projections Sources: Steamer, Fangraphs, Clay Davenport, ZiPS, Mr. Cheatsheet’s Special Blend
  • Average Draft Position Sources: FantasyPros, CBS, ESPN, Yahoo, Fantrax, NFBC
  • Auction Values Sources: FantasyPros, CBS, ESPN, Yahoo, RotoChamp
  • Expert Rankings Sources: FantasyPros, Yahoo, ESPN, RotoChamp

Download Your 2019 Cheatsheet

The cheatsheets come in three different flavors. There’s a draft and auction version of the cheatsheet for roto leagues (this includes head-to-head category leagues) and there’s a version for points-based head-to-head league drafts.

Download the cheatsheet for your rotisserie standard draft leagues
(Current Version: 1.75 uploaded on March 27 at 6:45 PM EST)

Download the cheatsheet for your rotisserie auction draft leagues
(Current Version: 1.75 uploaded on March 29 at 10:30 AM EST)

Download the cheatsheet for your points-based league drafts
(Current Version: 1.75 uploaded on March 29 at 11:00 AM EST)

Troubleshooting

My hope is that these should be operating flawlessly but, of course, you may notice strange things in the sheets as you use them. Let me know about these bugs that you find and I’ll perform minor updates on the sheets to fix them as needed. You can keep track of these smaller spreadsheet updates by following me on Twitter where I post about any minor updates that may happen. Also, pay attention to the “current version” above to see when I may have uploaded the latest fix.

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. Your player notes from the previous version will not carry over in the save/load process but they will carry over to future versions now. Also, any current player notes in the sheet may be erased during the save/load process due to this update. Let me know if you have questions about that.

Donations

If you’re appreciative of my work, feel free to punch one of the buttons below to donate.

You Might Also Like

  • Donald McQuiston
    03/24/2019 at 12:28 AM

    Luke, is there any way to treat a player like Shohei Ohtani as a pitcher and a hitter (2 different players). In our league you have to draft him as either a hitter or pitcher. So he could actually be on 2 different teams or twice on the same team. There might be others that looks like they will be hitting and pitching as well (Matt Davidson) but Ohtani is the big one.

    • Luke Gloeckner
      03/29/2019 at 11:16 AM

      Ah, I don’t have anything like that for this year since I wasn’t thinking he’d be drafted as a pitcher in leagues since he’s not pitching this year. Sorry about that.

  • Brad
    03/24/2019 at 10:45 AM

    Hey Luke, first things first – thank you! You do great work!

    Issue with version 1.70. Assigning keepers seems to be broken. When I click on “Officially Assign Keepers” the sheet locks and the players/teams grey out on that sheet, but when I go to “Your Roto Draft” sheet nothing has happened and on the “Save or Load” page all the players and teams are listed, but it shows FALSE for all keeper player data.

    • Luke Gloeckner
      03/29/2019 at 11:15 AM

      Sorry that I’m just seeing this now. I can’t recreate the error myself. Your draft may be over but are you using Excel or a different spreadsheet program? Perhaps hit the Reset Draft button and then the Assign Keepers button again. Sometimes that wakes up Excel if there’s something stuck.

  • Brian Mink
    03/26/2019 at 12:07 PM

    Thank you so much for this. The only issue I have is that, when I try to enter in keepers from last year, some were kept for a draft round and therefore have a $0. When I try to do this via the ‘Your Roto Auction’, it allows me to enter one $0 player, but, beyond that, it doesn’t save them. Is there a different way I should be entering in kept drafted – and not auctioned – players?

    • Luke Gloeckner
      03/29/2019 at 11:12 AM

      Sorry that I’m just seeing this now. So it’s a mix of an auction and a draft? There are draft rounds but then an auction as well?

      • Brian Mink
        03/29/2019 at 11:21 AM

        Yes – there is an auction to fill your starting lineup and then a 7 round draft for your bench spots. As it is a keeper league, if one of your prior league draftees retains prospect status (less than 50 IP or 150 AB) you can keep them for the same round they were drafted (and no affect on your auction $). I tried to enter in $0 for their prices, but, it only seems to allow one player at $0 in the summary tab. Again, the work you put into this is awesome, so, thanks for that.

        • Luke Gloeckner
          03/29/2019 at 11:41 AM

          Okay, gotcha. Has your draft already happened? I know why it is not allowing $0 bids at the moment but I can play with it a bit to try to allow that if you still need it.

  • Rudy LaRue
    03/29/2019 at 9:59 AM

    Hi, will there be one last update for the points sheet?

    • Luke Gloeckner
      03/29/2019 at 11:01 AM

      Just uploaded version 1.75 that has the latest projections and such. Enjoy!

  • Ryan Dowling
    03/29/2019 at 9:47 PM

    How do i unlock the excel spreadsheet on version 1.75?

    • Luke Gloeckner
      03/29/2019 at 9:49 PM

      You don’t need to unlock the spreadsheet to use it. Is there something you’re trying to do that isn’t working?

  • Chuck T.
    03/30/2019 at 1:59 PM

    What a great auction spreadsheet this is! I’m extremely impressed.

    Is there a way to enter missing players? For example, Kyle Wright and Bryse Wilson are both missing. I’ve been drafting these missing players using the listed “Unlisted Player 1, 2, 3, etc.” but this does not show up on the roster or other spreadsheets with names and positions making it challenging to keep track of which slots remain open for each team.

    • Luke Gloeckner
      03/30/2019 at 2:44 PM

      Thanks! And, unfortunately, I don’t currently have it set up that the Unlisted Players can be assigned a name or a position. I think I’ll try to make that happen for next year’s version though. That’s a good idea.

    1 2