Man. It’s been weeks since I’ve updated these 2016 fantasy baseball cheatsheets. You can blame me getting blasted with pneumonia and an ear infection that put me on the sidelines for a while. Luckily pneumonia can’t keep me down and I got a big update to the cheatsheets today for ya.
For those that don’t know, the cheatsheets are interactive Excel 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.
There are three types of cheatsheets. For rotisserie league owners, 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.
To better understand all of the features of these spreadsheets, skim through this post from last year that explains each area of them
What’s New in Version 1.1 of the Cheatsheets?
New projections are the biggest updates here. ZiPS projections are out and in the sheets and that also means that I was able to create my Special Blend projections. They’re in there too and I’ll be writing more about them later this week. In addition, I added the Fangraphs Depth Chart projections for the first time. On top of all of that, the projections that were in there before have been updated to the latest versions.
Some new ADP and Auction Value data has been added in from ESPN as well as updating the existing data too.
In addition, I worked on cleaning up some bugs and issues that I had come upon.
Average Draft Position
The 2016 cheatsheets include a good amount of average draft position data from websites that host mock drafts. This data lets you know the average place that a player is being drafted on that site. ADP data is largely reliant on the rankings of the site hosting the draft so it is recommended to choose the ADP data source that matches up to the site hosting your draft so you get the best idea on how your leaguemates might be picking. Here are the sources in this version:
- CBS (Points League or Roto League)
- FantasyPros Average ADP
As a note, our good friends at FantasyGameday have closed their doors so we’ll no longer include their ADP data and I no longer find the MockDraftCentral data useful so I’ll no longer be including that as well.
When opening up the cheatsheets, you’ll have a selection of different projections to choose from. The data you look at within the cheatsheet will only be as good as the projections you are using. There certainly isn’t one perfect projection system but each year I do analysis to try to figure out which ones are best and, for now, I say a good starting point is to use the Steamer projections and then play around with the others from there. Here is what is included in this version:
- Fangraphs Fans
- Fangraphs Depth Charts
- MORPS Baseline
- Clay Davenport
- Mr. Cheatsheet’s Special Blend
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.
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.
Download the 2016 Cheatsheet
Without further ado, pick your flavor of cheatsheet from the options below. If you do happen to find errors within there, please let me know in the comments below. Thanks for checking these out. Each year, these take me quite a bit of work to put together and I’m always happy to see the response that they get. Enjoy!
Luke is better known as Mr. Cheatsheet despite his last name not being Cheatsheet. He makes spreadsheets, writes blog posts and his rankings were in the top 10 accuracy among FantasyPros experts in 2014, 2016 and 2017. When he's not doing fantasy baseball things, he can be found playing board games or rating beer.