My 2014 fantasy baseball cheatsheets have been in circulation for a little over a month now and there have been a number of requests for tweaks, fixes or new features. While I wasn’t able to account for every single request out there, this latest update hits on a few requests and introduces a couple new features that I’ve just been wanting to implement on my own. I’m confident that this latest version of the cheatsheets is the best one yet.
Before I go into all of the wonderful new enhancements, I’ll give my usual word of warning that these are cheatsheets that will only work in Microsoft Excel on Windows. The Mac version is more limited. And, if you are checking out the site for the first time, here’s a rundown of what these 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 (or roto H2H), 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.
Without further ado, in version 1.3, the main new enhancements are:
- Positional Worksheet – Inspired by my printable tiered rankings, a new tab within the spreadsheet will allow you to look at the market for each position to see what players are available at a quick glance. As players are drafted, they are automatically marked off on this sheet.
- Change Player Positions – A feature that has been requested for quite some time is finally a reality. By clicking on a player’s position on the Draft Central page, you can now choose from a drop-down to select a new position for that player. Maybe you want Evan Gattis drafted as a Catcher instead of an Outfielder or some other less-common switch. Either way, you can now change that as the player is drafted so your draft tracking stays up-to-date.
- Position-Adjusted WERTH Totals – In addition to the traditional WERTH values which show how far above or below average a player is, there is now a Position-Adjusted WERTH value included too. This compares a player to replacement level at his particular position and calculates WERTH based off of that.
- Six new roto categories – Some of the requested roto categories have been added in. For batters, you can now choose 2B+3B, R+RBI-HR or K’s as roto categories. For pitchers, you can now choose K/BB, Batting Average Allowed or Home Runs Allowed as categories. BAA and HRA are both based off of MORPS projections regardless of what you use as your main projection source.
- Input names for unlisted players – If someone drafts someone not included in the cheatsheets, you can now type in their name when you choose Non-Listed Player from the bottom of the list and you can choose their position too. This will help keep your Team Summary pages up-to-date.
- Various tweaks – Other smaller tweaks have been done such as new logic to some sorting and a few other things behind the scenes.
- ADP updates – New ADP has been added in to keep that current.
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. Within that YouTube channel, I also have a video tutorial for the Roto Auction sheet.
Once the sheet is downloaded and opened, you’ll be prompted with two messages to enable content. After you get past that, you’ll be able to presented with a settings dialog box to setup your sheet. 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.
If you’d like to get these sheets ahead of time, make sure to follow me on Twitter where my followers got these cheatsheets nearly two days before this release.
Have fun and let me know if you run into any major errors with these latest updates. I’d say that any new features beyond this would have to be put on hold until next draft season but I’ll make sure to address anything that hinders usability or functionality.
Update on 3/20: Added in about 20 new selectable players and updated ADP, Rankings and Projections where possible to have the latest data. Made some tweaks to fix some bugs, specifically to fix the Load Settings problem in the Roto Auction sheets.
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.