It feels a bit wild to say this but, ladies and gentleman, this is the 10th anniversary of Mr. Cheatsheet. I started publishing my fantasy baseball cheatsheets and research online to a little blog that nobody was reading ten years ago. Basically, I had the wacky idea that other people might benefit from the work I was doing to win my own leagues. Despite not getting much attention, I kept going for years and eventually people started to find me. Once that happened, I got tips, ideas and requests on ways to improve the cheatsheets in ways that helped even more people. All of the seemingly crazy requests back then pushed me to get even more creative with my Excel skills and the spreadsheets have come a long way as a result of that.
It’ll be fun to see where we’re at in another ten years. I assume the cheatsheets will just be imprinted onto your eyeballs by that time. For now, my cheatsheets are still being delivered to your computers the old-fashioned way. So, without further ado, let’s jump into the 2019 fantasy baseball season with the first version of my cheatsheets.
My goal when building these cheatsheets was to make them customizable enough that they could handle any type of fantasy baseball league possible. Whether you play in a 10×10 roto league or a custom points league, these sheets can help you during your draft. You open them up in Microsoft Excel (works for both Mac and Windows) then put in your league settings and the cheatsheets will give you player values that are catered to your very special unique league.
Once the draft gets going, you can keep track of it in the spreadsheet. You’ll be able to see projected standings and all sorts of data during your draft so that you can make educated decisions when your time to pick comes up.
If you are in a keeper league, you can enter your keepers in and the cheatsheet will take those into account. If you’re in a roto auction league, you can run it from the cheatsheet and get custom values based on your league settings that change during the draft based on your league’s inflation rates. The possibilities for what these cheatsheets can handle are (nearly) endless.
What Data Am I Pulling In?
Since this is the 10th anniversary, I’m feeling a tad reflective at the moment. Over those years, we’ve seen some projection sources disappear such as CAIRO, CHONE, MORPS, Marcel and many others. We’ve also seen ADP sources go away such as MockDraftCentral and FantasyGameday. I owe a great deal to all of them for their work that has brought us to today.
That being said, we’re in a golden age of projections and draft data. Though the sheer number of options has dwindled a bit, that’s because we have such good options nowadays. For instance, Steamer changed the whole baseball projection world and made other systems obsolete and the same can be said for FantasyPros when it comes to their work with ADP and Rankings.
I pull in lots of data for you to choose from in these spreadsheets. I have a bit of my own data in there but this spreadsheet mostly crowdsources the best baseball minds. Here’s what you can find inside this first version of the 2019 cheatsheets.
- Projections Sources: Steamer, Fangraphs, Clay Davenport
- Average Draft Position Sources: FantasyPros, CBS, ESPN, Fantrax, NFBC
- Auction Values Sources: FantasyPros, CBS, ESPN, Yahoo, RotoChamp
- Expert Rankings Sources: FantasyPros, Yahoo, ESPN, RotoChamp
There will be additional data added into future updates of the 2019 cheatsheet. Notably, you’ll eventually find ZiPS projections and my Special Blend projections.
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.
Download Your 2019 Cheatsheet
The cheatsheets come in three different flavors. There’s a draft and auction version of the cheatsheet for roto leagues (this includes roto head-to-head leagues). If you are in a points-based head-to-head league, there’s a cheatsheet for that as well.
Download the cheatsheet for your rotisserie standard draft leagues
(Current Version: 1.65 uploaded on March 16 at 7:00 PM EST)
Download the cheatsheet for your rotisserie auction draft leagues
(Current Version: 1.66 uploaded on March 17 at 5:00 PM EST)
Download the cheatsheet for your points-based league drafts
(Current Version: 1.65 uploaded on March 16 at 7:00 PM EST)
Hopefully the cheatsheets themselves give you enough instruction inside of them to get the hang of things. If you have questions about anything though, post your questions in the comments below so I can answer for others to see.
While I did a bunch of testing on these prior to their release, it’s hard to test out every conceivable scenario so it’s possible you may encounter a bug or error that I didn’t catch. Let me know about that as well and I’ll post updates as needed. You can keep track of spreadsheet updates by following me on Twitter where I post about any minor updates that may happen.
As new cheatsheet updates are released, you’ll want to utilize the Save Or Load page in the cheatsheet to copy and paste your custom data into new updates.
If you have ideas for new features, post about those in the comments as well and I’ll see what I can do. I know there’s been an outcry for a Points Auction version of the sheets, for instance, which I will work on in addition to other feature updates that you all suggest.
I don’t like asking for money but these do take a ton of work. They are free to whoever wants to use them. There are similar resources out there that charge money and I respect that but I’ve never wanted to go down that road because I’d rather everybody has draft help if they need it. That being said, donations help keep this site afloat because storage and bandwidth and everything else costs money (and I like to think my own time working on these is valuable). Feel free to use the donation buttons below if you want to buy me a beer or a coffee… or a private island.
Have fun exploring the cheatsheets and good luck this season!