We’ve come into the homestretch of draft season. There are major injuries popping up and Spring Training is pretty far along and we have pretty much all the data we’re going to need at this point for our drafts. So, it’s time for one last major update to the cheatsheets for this year. Let’s get all that data in there for you to drool over so you can kick some major butt on draft day.
Before touching upon all of the updates, for those who are finding these cheatsheets for the first time, here is some background for you:
The cheatsheets are interactive spreadsheets that are can be tuned to your personal league settings and preferences. You will be able to use these sheets to see how valuable each player is specifically for your league. The spreadsheets also update throughout the draft so you can easily know when you need to adapt your draft strategy based on how a draft is going. For the data nerds, you get a ton of available projections and draft data right at your fingertips in one easy place.
As for the changes in this version of the cheatsheets, these are mainly data-driven updates. The projections have all been updated where updates were available. The rankings have been updated to reflect the latest info. The ADP and Aucton Value data has all been updated as well. In some projections, there weren’t updates to reflect major injuries such as Yu Darvish being out for the season so pay special attention to the Player Notes column as I updated that with as much injury information as I could.
With all of that being said, go ahead and download your cheatsheets and start customizing and having fun! There are three types of cheatsheets. For rotisserie league owners (whether it’s H2H or traditional), 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 point scoring leagues too.
2015 Roto Draft Cheatsheet
2015 Roto Auction Cheatsheet
2015 Points League Draft Cheatsheet
To better understand all of the features of these special little cheatsheets, skim through this post here that explains each area of the spreadsheets.
Please note that these sheets are designed for Microsoft Excel and utilize macros which will make them unable to be used on Mac versions of Excel (it sucks, I know).
Some of the basic features of these cheatsheets include:
- Choose from countless roto categories options and have the cheatsheets calculate estimated roto WERTH values for your draft pool
- Or, choose from a variety of scoring options for points leagues to generate your projected values
- Choose from a large number of projection sources (like Steamer, ZiPS and more) or import your own or come up with a weighted custom projection system of your own
- Choose from a variety of ADP or Auction Value sources (like from your league sites at ESPN or CBS or Yahoo) so you know what to expect out of your leaguemates on draft day (or input your own!)
- Look at tiered positions for your league and see who is still available
- Compare players and see how each player could increase your team’s projected place in the standings
- See live league standings throughout the draft to know your areas of weakness or strength
- See draft odds to know how likely it is a player may be available if you decide to wait on them
- And, really, a ton of other little minor bells and whistles that you’re welcome to play around with!
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. Once again, if you are a bit confused upon opening the cheatsheets, refer to the how-to post here.
If you had used the previous version of the sheets and entered keepers or data in, feel free to click Save Settings there then come over to the new version and click Load Settings to bring in that old data.
I plan for this to be the last major update to the cheatsheets for this draft season. If there are bugs or weird behavior you find within the cheatsheet, I’ll get those resolved. But, beyond that, this should be what you’re using for your drafts this year so enjoy it! If you want to find out about any minor updates that are released for the cheatsheet from this point forward, follow me on Twitter where I’ll post them there.
Happy drafting!
Updates since this was first published:
v1.31 on 3/18: Fixed the Save/Load Settings so that it would save drafted players (that were being hidden) and your player notes. Also, fixed some weirdness with importing projections and some weirdness with the BAA stat in Roto Auction sheets.
Amit Patel
03/15/2015 at 9:24 PMare these the special blend ranks?
Luke
03/15/2015 at 9:31 PMAre you asking if these spreadsheets contain my projections in them? If so, yes, you can select them as the Projection Source on the last page of the Settings in the cheatsheet. Let me know if you were asking something else though.
Randy Munro
03/17/2015 at 1:54 AMSince I have been doing research, creating notes, adding keepers and teams and such is there anyway to transfer it all over to the new spreadsheet easily or do I have to do it all over again with the new update?
Luke
03/17/2015 at 8:21 AMYes, you can using the Save and Load Settings options. They'll carry over your keepers and teams and such (just make sure you don't have the drafted players hidden). However, I'm going to make a tweak to that and load it tomorrow that will allow you to carry your Notes over too as I hadn't set that before.
Smitty
03/17/2015 at 3:49 PMDo you think it would be possible to add a tool to the draft sheets to show a maximized team based on werth and adp?
Keith
03/17/2015 at 3:52 PMhow can you designate all the players selected as starters vs bench?
Jim Bull
03/17/2015 at 5:20 PMAny way to set one of these spreadsheets up to cover a points league auction?
Keith
03/18/2015 at 1:18 AManother question, how do you back out of a pick if you've entered it incorrectly?
Ezra A
03/19/2015 at 4:49 PMHi, Any way to add a UTIL option to the position setup? Our league has 2 utility offensive positions (that anyone including DH can fill) and I can't find a way to account for it otherwise. Thanks!
Ezra A
03/19/2015 at 6:50 PMAlso, the DH position does not appear on the positional worksheet, so guys like David Ortiz aren't on it.
Unknown
03/19/2015 at 9:07 PMThis!
Mark
03/20/2015 at 1:57 AMThere seems to be an issue with Stan Dev if you enter LF, CF, RF. Any thoughts? Thanks.
Larry Vegas
03/20/2015 at 4:20 PMI'm having trouble when using the cheatsheet on my macbook that I didn't have when using it on my PC at work.
When I click on any cell in the draft central sheet, I get a "Compile error in hidden module: Sheet 2" message. I also cannot edit the settings or search the sheet.
Any input would be appreciated.
Kevin Hall
03/22/2015 at 4:15 AMI love this spreadsheet and the special blend projections. However there is occasionally a projection I'd like to modify and see how it effects auction values. Is there a way to modify specific projections to see how it effects values?
Joel Macke
03/23/2015 at 1:21 AMIs blown saves still a category? I couldn't find it.
MP
03/23/2015 at 8:09 AMLuke, Any chance of unlocking the sheet to allow copying and pasting? I ask bc ideally, I would want to have access to your updated notes with every new release. As it is now, if I load my old settings file, it will always wipe out your (Luke's) notes. I.e., there is now way for me to load custom settings and retain any access to your (valuable) player notes. Thanks.
Jesse Richman / xopchipili
03/24/2015 at 10:22 PMI don't suppose you'll be doing these for Points Auctions?
James Warne
03/26/2015 at 8:19 PMLove these sheets. Another vote for auction points!
Joe Saputo
03/27/2015 at 12:47 AMHaving the same "Compile error in hidden module: Sheet 2" message. Anyone know how to fix that?
Sean.
03/27/2015 at 4:58 AMIs there going to be another update. So many things have changed in the past 8 days. Guys like Bryant are tearin up the preseason rotations are finaliIng and players have earned starting jobs. I'd love to use this site and if it helps I'll donate. Is also love to know how to back out if a pick.
Luke
03/28/2015 at 2:47 PMSorry, I'm just getting caught up on comments now after being away for a while. Starters/Bench are calculated automatically based on ADP and player value.
Luke
03/28/2015 at 2:48 PMSorry, I'm just getting caught up on comments now after being away for a while. This is an idea for the future, definitely, but would be a huge undertaking. I'd have to figure out a way to have an algorithm in place to account for all draft scenarios from that point forward in order to calculate something like that. I'll think it over for future years.
Luke
03/28/2015 at 2:49 PMSorry, I'm just getting caught up on comments now after being away for a while. This is the first year I've really heard requests for those types of leagues but there's been some buzz there so I'll definitely try to get something in place in the future for this.
Luke
03/28/2015 at 2:50 PMTurn on the option to show drafted players (show/hide button) and then just click the delete button on the team name where you accidentally drafted somebody (or just change it to the correct team).
Luke
03/28/2015 at 2:51 PMThe DH option in the settings is the same as the UTIL. The DH means somebody from any position can fill that roster spot.
Luke
03/28/2015 at 2:53 PMAh, that may be the case. I'll have to look and see. Sorry I'm seeing this just now because I was away for a while so it's probably a bit too late to address but I'll try to play with that to get it right moving forward.
Luke
03/28/2015 at 2:54 PMUnfortunately the cheatsheet does not work on Macs. This is because the Mac version of Excel doesn't allow for the use of macros, which drive a lot of the functionality I built into the cheatsheets. Sorry about that.
Justin
03/31/2015 at 3:59 PMWhat is the password to unprotect the excel workbook? Guys like Harvey do not yet have projected stats, and I would like to be able to edit in projections for these players. Thanks!
Unknown
03/31/2015 at 8:45 PMHi Luke,
Question re: projected werth in the player profile section. As you can see in this screenshot – http://i.imgur.com/h4tiYhp.png – it gives Pedroia's projected werth in the hit section as 0.5, and Dozier's as 1.1, despite Pedroia being projected for more hits in every one of the projection options listed.
Any idea why this might be?
John Safrance
04/05/2015 at 3:00 AMHi,
I can't seem to get some missing names to populate on the Auction Cheatsheet. Guys like Ryan Rua and Geovany Soto are missing. Even creating my own ADP and Projections to import are not helping…leading me to believe the list on the Draft Central tab is cross referencing something else?
I tried adding them into the non-ranked player section but they do not get picked up in the team summaries.
John Auten
04/13/2015 at 3:36 PMI have run into an issue with the Live Standings tab. When I do my settings I have the following score categories: AVG, HR, R, RBI, SB, W, S, ERA, WHIP, K/9
When I click on the Live Standings tab the categories are listed across the columns, but the S column is blank. I looked at the formula being used and it looks correct. I can't see the macro code that populates the columns, but I am assuming that the K and S categories have been mixed up. If I chose K and S then both columns display as they should, but if I chose one and not the other then that one is shown as blank. Any help is appreciated!!! BTW, awesome cheatsheet!!!!!
Jason
01/28/2016 at 12:37 AMWhen can we look forward to 2016 sheets? Love and appreciate your work!
Luke
02/03/2016 at 6:07 PMHey Jason. Thanks! I’ve been working on the first version of the sheets. Should be pretty soon!