Fantasy drafts are coming up left and right and you’re going to want the latest versions of the cheatsheets if you have any hope of dominating your leagues. It had been a few weeks since I put out an official update of these 2016 spreadsheets but, have no fear, the new version is coming at you and it has a few added bells and whistles in addition to the typical data updates and bug fixes.
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.3 of the Cheatsheets?
There is the standard data update here that updates the auction data, ADP data, and projections to their newest incarnations. In addition to that though, here are some of the exciting feature changes that are in these versions:
- Live Standings page for Roto owners now adds up total stats in each category as opposed to WERTH values. This should make for a more clear breakdown of where people stand in your draft.
- Live Standings page has also been updated in all versions to include number of players drafted at each position for each team. This can help you get a sense of what teams may be targeting.
- And, for Auction leagues, the Live Standings page has also been updated to include more information about team budgets including Maximum Bid and Dollar Per Player Left/Spent.
- Team Summary page has been updated in all versions to include basic stats for each player on that team as well to give you a bit more information on the team breakdown.
- For Roto leagues, you can now select half points for roto categories. When selecting your league categories, choose a gray checkmark to indicate that category is only counted for half-value. A black checkmark indicates it is counted as a normal full category. This will affect WERTH calculation and Live Standings calculation.
Those are most of the big feature changes in this version. In addition, I fixed a few reported bugs. Here are some of the bug fixes:
- Hits and BB’s were getting mixed up on roto sheets if those were categories you were using
- Another issue was related to Complete Games and Shutouts being calculated incorrectly if you use those in Points leagues or even Roto leagues
- A big issue that was fixed was that it was not updating the sheets when you changed a player’s position on the Draft Central page. Now, if you click on a player’s position on the Draft Central page to change their position then it will update all of the calculations and other sheets in the workbook correctly.
All in all, this update focused more on some fixed and feature changes as the data hadn’t changed much since the last release.
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). I’ve heard of people who run the Windows version of Excel on a Mac but I don’t know the details of that.
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!
Update: A new version of each sheet was uploaded on the morning of 4/2 to have the latest projection information.