Oh happy day! There’s been a big ol’ update to the cheatsheets today. This isn’t a data update but rather a features update. We’re still waiting on projections to be released and ADP data to start coming in so it was the perfect time to implement some new requested features. The new features within the cheatsheets allow users to import their own ADP data or projections in addition to loading/saving your data in a sheet to be able to transfer it into future updates or easily access multiple leagues within one file.
First and foremost though, for those unfamiliar here’s a rundown of what the cheatsheets are:
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.1, you still have the same data as version 1.0 but with the following new features:
- Import Projections: If you have a projection system that you may have paid for or even custom projections that you’d like to use within these cheatsheets then you can now import them in and utilize them for your drafts! 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. At that point, it’s just a matter of selecting Imported Projections within the cheatsheet settings and then clicking the Import Projections button.
- Import ADP or Auction Values: Perhaps you have access to some ADP or Auction Value data that I’m not using or you’ve got updated ADP data that you’d rather use. Well then, you can now import your own ADP data into the spreadsheets here. You’ll need to download the ADP or Auction Values Template by visiting the Import page. Get your data formatted correctly and paste it into the templates. Load the cheatsheets, choose Imported ADP or Imported Values and then click the corresponding button and enjoy your new creation!
- Load/Save Settings: Did you punch in all of your keeper league data, team names or league settings and then see that I released a newer version of the cheatsheets so you have to do it all over again? Have no fear! You can now save the data from your cheatsheet then load it into the newer version without losing anything. Huzzah! This can also come in handy if you are in multiple leagues and want to quickly switch between the draft results or draft settings to do your research.
Well, there you have it! In the next releases, I’ll start to add in more projections, updated ADP and auction values and much more. 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. It is specific to the roto draft cheatsheet but I will be posting similar tutorials for the other cheatsheets as well.
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.
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.