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.
2014 Roto Draft Cheatsheet
2014 Roto Auction Cheatsheet
2014 Points League Draft Cheatsheet
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.
Hogtown's Heroes
02/28/2014 at 3:08 PMYay!
Luke
02/28/2014 at 3:22 PMThought you might be happy! The CAIRO data is from November and the MORPS data is from an early draft so it's not 100% perfect but I'm pretty excited about this release!
LVHawk
02/28/2014 at 4:14 PMVery cool stuff. Would it be possible to add IF as a position and net SB as a stat category?
Wac
02/28/2014 at 9:20 PMI am having trouble when I try and input my league settings that the box is too big for my screen and I cannot get to the save settings button on the bottom. Is this something I can fix? Or is my excel version to old for the spreadsheet. I do have macros on.
Luke
02/28/2014 at 9:23 PMAh, yeah, I need to release an update that is designed for smaller screens. I get a little overzealous and made those setting pages too big. Stay tuned as I'll do an update in the near future… In the meantime, not sure if there's a zoom out button or anything within Excel that may help. Sorry about that.
Jimmy Red
03/03/2014 at 1:18 AMIs it possible to have the $ function be able to handle cents and just not whole dollars? I'm in a long time league (20 plus years) that use .50cents as min bid and then goes up in 5cent increments($75 cap). Seems strange now but 10 years ago when we went to Auction it was all we knew. It's a keeper league so a change is tough. Otherwise the cheatsheet.
Jimmy Red
03/03/2014 at 1:19 AMOtherwise love the cheatsheet
Rob Shaffer
03/03/2014 at 4:55 PMStumbled across your site and I'm really impressed. I'm in an auction league and am trying to figure out what some of the columns mean. You mentioned that you will be doing an instructional video for the auction cheatsheet. Any idea when that might be completed? Thanks so much.
Michael Friedman
03/04/2014 at 1:32 PMThis is awesome… is there a way to sort by position so you can see all the OFs or Pitchers?
NoisyFlowers
03/04/2014 at 2:04 PMA bunch of the fields under Expert Dollar Value and Projections appear blank. I can't, for instance, find the special sauce.
Gerald Head
03/04/2014 at 10:22 PMGreat work. Love it.
Randy Munro
03/08/2014 at 10:29 AMHey there! Such a great thing site you have here!! Any chance you were thinking about adding the espn projections into the spreadsheet?
If not, is there an easy way for me to do it myself?
Cheers,
Randy
Luke
03/12/2014 at 3:17 AMI plan to have a new update before the weekend that will have ESPN ADP in there. I typically limit the projection sources to the algorithm-based ones (http://www.mrcheatsheet.com/2014/01/projections14.html)
If you'd like to import your own projections, download these templates (http://www.mrcheatsheet.com/p/2014-import-templates-for-mr-cheatsheet.html) and put in your data then choose the Imported Projections option in the sheet.
Robert Wright
03/12/2014 at 9:19 PMWill this download to MAC?
Tim Starmack
03/13/2014 at 12:07 AMAny chance at adding more player projections to the cheatsheet? I'm in a NL-Only (2 catcher) league and the NL-Only player list is short on catchers and OFs. Not to mention it also seems to missing some important players (ie- any of Pittsburgh's 1B- Lambo and Sanchez). I know it may be a little late, but I just stumbled across this and really want to use it for my draft. Even if you can't add more players I will still probably try to make it work because of the sheer awesomeness this spreadsheet embodies.
Excellent work and I have a new bookmark in my browser.
Cheers
Seth M
03/17/2014 at 1:01 AMIn the Rotodraft Cheatsheet, Ian Kinsler is listed as OF. Wouldn't a 2B tag be more appropriate?
Luke
03/17/2014 at 1:03 AMHmm, weird. Not sure why that happened. The positions are editable so you can change him on your own in the cheatsheet (just click on the position and a drop-down appears) but yeah Ill get that changed.
Brad Hults
03/19/2014 at 8:40 PMWow! Truly awesome! I am an electrical engineering major and I know how much time and effort had to be put in for these sheets. I will definitely donate!
I play in a h2h auction keeper. 10 man, 260 budget, c,1,2,3,ss,mi,ci,4 of,2 util, 8 p, 8 bn.
Keeper rules are:
4 years max, year 1 is auction price, year 2; no increase, year 3; +$5, year 4; +$10.
All of the projections I see are for roto, and if you have ever played H2H, you know that players can be more valuable in roto than h2h (jay bruce e.g.). I am an offense heavy drafter, as we have 8 bn spots and I usually draft such a good offense that I can devote all of my bench spots and 4/8 P spots to starting pitchers with high k/9 rates, and win at least 3/5 categories in pitching ( k, qs, sv) simply by throwing more innings than my opponent.
Do you think 80/20 is too much of a split? Also, gimme some guys who you think I should target, knowing that this is my preferred drafting strategy.
Also, I dont tend to overvalue rookies, and most of my keepers are usually post hype guys, or proven players coming off a bad season.
Luke
03/20/2014 at 12:45 PMThat's a pretty harsh split but I do think you can find good pitching value for cheap. For some ideas of cheap names (and pitchers who should fit your criteria), I'd check out this post of mine: http://www.mrcheatsheet.com/2014/03/2014-sp-targets.html
Based off your point about Jay Bruce, what do you foresee as the biggest differences between a player's value in Roto versus a H2H Roto league? Just trying to mine for ideas about future tweaks to the sheets and analysis.