2015 Fantasy Baseball Draft Cheatsheets (Roto, Auction, Points) Update #1

The first version of my fantasy baseball cheatsheets were released a few weeks back and it’s time for an update, my friends. There has been more projections, ADP, auction and rankings data released and it needed to get added in for you to drool over. In addition, I was feeling ambitious and made a number of requested tweaks and changes to the sheets.

Before touching upon all of the updates, for those who are finding these cheatsheets for the first time, here is some background for you:

The cheatsheets are interactive spreadsheets that are can be tuned to your personal league settings and preferences. You will be able to use these sheets to see how valuable each player is specifically for your league. The spreadsheets also update throughout the draft so you can easily know when you need to adapt your draft strategy based on how a draft is going. For the data nerds, you get a ton of available projections and draft data right at your fingertips in one easy place.

As for the changes that I made in this latest version, a brief summary of the major changes:

  • Added IF (Infield) as a new roster spot that you can choose. This roster spot is similar to CI and MI but covers 1B, 2B, 3B and SS.
  • Added a whole lot of new roto batting categories: Net SB, Singles, Combo (BB+SB-KO), Caught Stealing, Fielding Errors
  • Added a whole lot of new roto pitching categories: Earned Runs, Games Started, Complete Games, Shutouts
  • Added new stats for points league calculations: Fielding Errors and GIDP for hitters and Games Started for pitchers
  • Added my Special Blend projections as a selection projection
  • Opened the ability to do Combined projections and select how you’d like to weight each source
  • Added ZiPS and MORPS projections
  • Added new rankings sources (such as Rotographs and ESPN Points League rankings)
  • Added CBS and ESPN ADP data
  • Added ESPN auction data
  • Updated projections, ADP data, Auction Value data and Rankings that had updates available
  • And, there’s a whole lot of minor little tweaks and fixes that I made that aren’t major but had either been requested or were things I noticed

With that being said, it’s time to download your cheatsheets! There are three types of cheatsheets. For rotisserie league owners (whether it’s H2H or traditional), you can use the standard draft or the auction draft cheatsheet depending on your draft type. If you’re not in a roto league, there’s also a cheatsheet for point scoring leagues too.

2015 Roto Draft Cheatsheet
2015 Roto Auction Cheatsheet
2015 Points League Draft Cheatsheet

To better understand all of the features of these special little cheatsheets, skim through this post here that explains each area of the spreadsheets.

Please note that these sheets are designed for Microsoft Excel and utilize macros which will make them unable to be used on Mac versions of Excel (it sucks, I know).

Once downloading the sheets, you’ll be prompted with two messages to enable content and then you’ll be able to use them fully after that. Once again, if you are a bit confused upon opening the cheatsheets, refer to the how-to post here.

For this round of updates, I made a lot of changes that may not be evident and I did my own testing but there very well may be things you notice that aren’t acting as you’d expect. If that’s the case then drop me a line in the comments and I’ll get it fixed. Also, if you had used the previous version of the sheets and entered keepers or data in, feel free to click Save Settings there then come over to the new version and click Load Settings to bring in that old data.

Enjoy and happy fantasy baseball draft season!

You Might Also Like

  • Mike Brueck
    03/12/2015 at 1:16 AM

    Would everything work using Google Spreadsheets?

  • MP
    03/12/2015 at 7:12 AM

    Can you please add Games Played as a category for pitchers in the points league spreadsheet? Thanks!

  • Andrew Hafemann
    03/12/2015 at 1:37 PM

    Can't get the file to open in Google Spreadsheets. No worries though, just download a free 30-day trial of Office 2013. Solved the issue for this year.

  • Mike Brueck
    03/12/2015 at 10:28 PM

    Good call on the Office trial, unfortunately I'll be using a Chromebook for my draft. I was able to get the file imported into google spreadsheets fine, everything works except I can't edit teams and the dropboxes won't load any team name (even the generic 'Team A'). I also tried Microsoft's free excel online app, but none of the hidden sheets will load in for some reason, so I can't edit any of the scoring or team names to be specific for my league.

  • MP
    03/15/2015 at 8:37 AM

    Any chance you can put a version number in the file names, so users know whether they have the latest update or not?

  • BLK
    03/24/2015 at 2:53 AM

    In either NL or AL only leagues, the Positional Worksheet tab displays players from the non-eligible league. And those players cannot be manually deleted because the sheet is locked. Any chance you can fix this before next week?

  • Michael Wire
    08/31/2015 at 4:00 PM

    Great job with that worksheet! It is really useful. As I started I was searching for something like that for a long time now but with no luck. If I use those and the strategies from here I would make a lot of wins this season. Thanks for sharing.

  • 1 2