2017 Fantasy Baseball Excel Cheatsheets for Windows/Mac [Final Release]

With a big fantasy baseball draft weekend upon us, I am releasing my final update of the cheatsheets for 2017. For those unfamiliar, these sheets are designed to be used in conjunction with your drafts to give you live data throughout the draft about who to draft and your team’s strengths and weaknesses. This cheatsheet gives you access to tons of projections, draft data, rankings and is customizable to fit your league’s unique needs.

What’s New In The Final Release?

This version of the sheet now has a new projection option: Special Blend With Steamer Replacements. The idea for that is that the projection system will primarily use my Special Blend projections (read about them here) but use the Steamer projections when there isn’t a Special Blend projection.

All of the ADP, auction values and projection data should be fully up-to-date as well now.

In addition, there’s been a long list of small little tweaks and bug fixes for all of the sheets. The points league sheets also get the addition of a number of new categories to choose from.

One of my favorite additions in this version though is the Player Notes page. On this page, you can choose the Note Type and enter notes for player. Then, on your draft page, there will be an indication of the note to the right of the player’s name that you can click on to read the note. I’ve already input a bunch of my own notes in there based on my research to give you a head start.

Cheatsheet Options

If you haven’t used this cheatsheet before, you’ll see that it is designed to accommodate nearly any type of fantasy baseball league imaginable. And, believe me, there’s more league variations than you could even imagine. That being said, it can be a bit overwhelming to see so many options for a new user. To get started, I’d just enter your league settings on the Settings page and leave most things with their default settings and dive in. If you don’t like the data you’re seeing, go back to the Settings page and maybe try some other Projections or Rankings on there until it looks good to you.

Once the draft is going, enter your picks into the sheet and see your Standings and data start to adapt and change for your specific league. The idea is that the cheatsheet will give you data and values that are completely unique to your specific league type.

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.

Warning for Points League Drafters!

This version of the cheatsheet will not be able to load your previous settings without you taking special care. Due to the addition of new stat categories, the Save/Load page does not exactly match the previous spreadsheets. If you do want to paste over data, just do it carefully by pasting into the correctly labeled sections.

Download Your 2017 Cheatsheet

Without further ado, pick your flavor of cheatsheet from the options below.

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

If you find errors in the sheets, let me know in the comments below and I’ll work on fixing those. I likely will not be doing any further updates as far as new functionality to the sheets at this point though. I’ll focus on fixing errors and updating data as needed until Opening Day.

Donations

I’ve said it once and I’ll say it again: these cheatsheets take tons of man hours to create. I really want to keep them free and keep doing this each year for you all. If you want to support the site to keep this going, punch that Donate button below:


Good luck in your drafts, everyone!

You Might Also Like

  • Brad
    04/06/2017 at 11:33 PM

    Hey-Love your work…Quick question though on the Roto Draft spreadsheet. When I goto the players tab I see drop downs with player names that you can scroll through. Is there an easier way to find a player on that tab? I’m not seeing a way to search that.

    Thanks!!

  • James
    05/01/2017 at 3:28 PM

    Not sure where to leave this, but just wanted to mention that I’m 4-0 so far this year in both my points leagues due in large part to your cheatsheet and rankings! Thank you!!

  • 1 2