While playing with the early drafts of the 2014 cheatsheets was good fun, you all have been eagerly awaiting the version of this year’s spreadsheets that would have more data to play with. Well, we’re finally at that point now with today’s release. Nearly all of the projections are in there (even the Mr. Cheatsheet Special Blend projections) and the same can be said for ADP or Auction Value sources as well. In addition, for this version, there’s some tweaks and fixes and a new interface when you open the cheatsheet to help make it more navigable.
Before you jump into downloading the cheatsheets, I’ll give my usual recap of what the cheatsheets are for those who are coming to this site for the first time:
The cheatsheets are interactive spreadsheets that are completely customizable to your personal league settings. No matter how unique your league is, these cheatsheets will handle it. You will then be able to use these sheets to see how valuable each draftable player is in your league’s universe based on roto values or point-league values. In addition to that customization, you get to choose what data you want to utilize from a variety of projections, rankings and draft averages.
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 points leagues too.
In version 1.2, the main new enhancements are:
- Import Projections: This has been tweaked as there were problems with loading in your own projections in my last version. It should work better now. You’ll need to download the Projections Template by visiting the Import page here and then get your data formatted nicely and pasted into those templates.
- Import ADP or Auction Values: Same as the Projections Import tweaks. You’ll need to download the ADP or Auction Values Template by visiting the Import page.
- Load/Save Settings: Also some tweaks here to make this run more reliably. If you have saved your data/settings from version 1.1 then you should be able to click the Load Settings button when you open 1.2 and then import them in.
- New Auction Dollar Calculations: Based on user feedback, I was able to enhance my calculations used for the auction value calculations to make it a bit more reflective of your individual league market. The dollar calculations should seem a lot better than previous versions.
- New Auction Value Split Option: Do you want to set your own split for hitter/pitcher values? Maybe you want a 70/30 split or 60/40? Well, now you can customize that within the cheatsheets to your own liking.
- New Projection Data: Nearly all of the projection data is in there though CAIRO and MORPS are using early drafts of their projections so there will be updates later.
- New ADP/Auction Data: Aside from ESPN, all data sources should now be available, including FantasyGameday.
- New Rankings: Some new sources have been added in and my own rankings are now in the cheatsheets as well.
There will likely be a few other modifications over the next month but this is a near-complete version of this year’s sheets. You are now locked and loaded if you have an early draft this year. Click the links below to download.
To better understand all of the features of these special little cheatsheets, feel free to watch the video below. This video is a tutorial for the first version of the roto draft cheatsheet but I’ll be posting an update to this video with the new features and posting similar videos for the Auction and Point League cheatsheets too.
Please note that these sheets are designed on Microsoft Excel and utilize macros which will make them unable to be used on Mac versions of Excel. 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. A full write-up with instructions for how to use the sheets will come later for those who are unfamiliar and perhaps a bit confused. For now, please refer to my introduction about what my WERTH values are as a point of reference.
Have fun playing around with the latest version of the cheatsheets! I’ll be continuing to release these a bit earlier on Twitter if I can so make sure to follow me there for updates.