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.
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. 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.
Smitty02/07/2014 at 5:14 AM
Didnt the auction sheet used to take into account how much money each team starts with. I think its a large factor, as the larger the pot, the more players will go for.
Luke02/07/2014 at 3:46 PM
It's still there! I guess I hid it a bit more than I thought. Right below the Projections box within Settings, you can scroll through a few different tabs. If you choose the Auction one, that is where you set the values. I actually meant to set that as the default one you view… I'll play around with some ways to make those tabs a little bit more obvious. Thanks for the feedback.
steve359602/09/2014 at 2:36 AM
Any chance in a future update you can allow sorting by Points per Plate Appearance and points per inning? In a head to head point league with daily lineups these might be the most important stats. Just found this site a couple weeks ago and am already looking forward to using this for all my leagues. Love the work.
.02/09/2014 at 3:54 AM
Fantastic tool. Thank you. A couple suggestions, that if possible to implement, would make it even more useful. 1. Possible to have a feature where an individual could enter in their own rankings, in a separate column that would then be one of the options for sorting? 2. Possible to have a feature where an individual could enter in tiers, also sortable? 3. A way when using the sort function to have a secondary sort, meaning, I want to sort by position first, then by WERTH ranking, rather than ADP which seems to be the default? Again, thanks, this is a great draft tool! Love the percentage chance player will be available in the next two rounds, great idea!
Michael Friedman02/09/2014 at 8:08 PM
Great tool love it. Any chance you can provide password to unlock. In auction draft, would very much like to filter row 6 to view only the position that is being auctioned.
Luke02/10/2014 at 3:25 AM
Good call! I thought I had that in there but I'll definitely get it added in there for the next update. Thanks for pointing it out.
Luke02/10/2014 at 3:27 AM
Yeah, the personal rankings could be added in as I just worked on the ability to add in personal projections or ADP and this should be easier.
The tiers idea is interesting. I'll have to think about that one.
Secondary sorting is a good idea too. I'll get that in the next update.
Thanks for the ideas!
Luke02/10/2014 at 3:29 AM
Sorry, I have it password protected because too much can go wrong if things are accidentally changed within any of the cells. But, as far as having filters adding in, that's certainly a possibility and I'll see what I can do.
William Garcia02/10/2014 at 1:54 PM
I love this sheet!!! I've been looking for something like thos for a a long time. Is it possible for you to add XFIP for Pitchers and BABIP for Batters? Just curious.
William Garcia02/11/2014 at 12:47 PM
Again love your cheat sheet. Is It possible that you can add K's for batters and BAA for Pitchers. These two stats are In a few leagues that I'm In. Would be great to have It. Thanks.
BIll Baker02/12/2014 at 3:59 AM
Like these sheets. Few questions.. Having a hard time reaching the save/import buttons at the bottom of the settings screen, like it is not able to be clicked because it is below the screen (any suggestions?). Would love a BS category in the points league as well if possible?
Luke02/12/2014 at 4:26 AM
What version of the sheet are you using that you're having trouble with those buttons?
I added in a bunch of new buttons in this update so I may have to play with that layout a bit more to make it work all screen sizes.
Luke02/12/2014 at 4:28 AM
I think adding both of those stats in are possible. I assume you're talking about Roto leagues, right?
William Garcia02/12/2014 at 11:14 AM
Yes Roto Leagues, In the Batting categories. Thanks a Mil Luke.
Eli Grimmett02/12/2014 at 7:36 PM
This keeps happening to me – "Compile error in hidden module: Sheet2"
I'm using Excel 2007. Any ideas on how I can get it to work? It looks like an awesome resource – I hope I can get it working.
Luke02/12/2014 at 7:49 PM
Cool, I'll check it out. I should be able to diagnose it. Which sheet did you download? Roto, Roto Auction or Points?
Eli Grimmett02/12/2014 at 8:09 PM
I tried both Roto and Roto Auction and the same thing happened in both.
Luke02/12/2014 at 8:11 PM
Okay. And I assume it is happening when you try to open the document?
Eli Grimmett02/12/2014 at 8:16 PM
I open the document and it opens fine, but there's a security warning at the top saying that active content has been disabled. I click options and enable it. Then the settings dialogue box appears and I click create my cheetsheet. That's when the error occurs.
BIll Baker02/13/2014 at 2:11 PM
The most recently updated one. They are too far below my screen and I can't drag it high enough to reach them. Once again.. these sheets are great! Thanks for putting in the time!
Ryan02/14/2014 at 8:11 PM
In the Auction sheet, I note that the calculated $ for pitchers is typically higher than the Experts $ and high end hitters are consistently lower than the experts' projection. I think this is due to your algorithm treating Pitchers and Hitters equally, whereas most systems decide to dedicate 60-70% of a budget to hitters.
Can you add an option under the Settings tab to dictate how much of the budget is to be put towards hitters? Without this, we're going to end up overpaying on pitchers and not get any of the hitters we want.
Zachary Pressley02/16/2014 at 9:44 PM
Having trouble opening this up on a mac using microsoft excel for mac, is that a common problem?
Peter Wilcox02/17/2014 at 1:07 AM
Thank you so much for this. One question. If my league has an IF slot, what would be more accurate for the cheatsheet. MI? CI? or Both? Thanks.
Hogtown's Heroes02/20/2014 at 9:26 PM
Hey Luke. I don't mean to be a pest, but when you expect your next update to be released? This early start to the season is making my leagues antsy and they keep pushing for an earlier draft date! Thanks again for all your hard work.
Luke02/20/2014 at 9:47 PM
No worries! I'm with ya. I'm wanting to do an update soon but I've really been waiting on CAIRO and ZiPS projections to come out before I did the update since that would then make available my Special Blend projections and such. However, it looks like I can't wait forever on that so I'll probably do the next update very soon and then another update with that data in early March.
Jason Penrod02/20/2014 at 11:25 PM
Ok, couple of things.
1. How do you sort a column? im trying and the worksheet is protected and you didnt provide us with the password.
2. Secondly, my ADP i am trying to upload, says error. out of range.
I am using your template and no luck.
3. How do i remove columns that arent needed, to make it less cluttered. I am trying to clean it up a little bit. Some of the columns really arent needed.
4. The scring categories need to be expanded. I know I have a deep league with H2H scoring, but there really needs to be a spot for custom categories. Like we use Games started as a category.
Nice work, but I will say that it needs to be adjusted before I will rely on it. Thanks.
Luke02/20/2014 at 11:37 PM
1. There's a dropdown box in the top right corner to allow you to sort by the different columns because having the sheets unlocked causes too many potential disasters with the formulas and macros necessary to make it run. I will make it bigger or move it over in the future to make it more obvious.
2. This is the first version using the ADP upload feature so I'm not surprised there are some bugs. I'll check it out.
3. What columns do you want removed? Click on the Customize button to remove various elements.
4. Sure, the cheatsheets use various projection systems and those don't project every single type of stat but I've had some requests that I think I should be able to add in and will add what I can.
If you don't rely on the cheatsheets, that's fine. I'm just trying to put out a free tool to the public and am glad you took the time to check out my work.
Luke02/20/2014 at 11:39 PM
Yes, the Mac version of Excel is unfortunately extremely limited and cannot utilize the functionality involved in this particular spreadsheet. Sorry.
Luke02/20/2014 at 11:40 PM
Hmm, good question. I'll look into adding an Infield spot in a future update because there really isn't a way to do that now. Thanks for the idea.
BIll Baker02/22/2014 at 3:12 PM
When the updates come out soon, will I be able to use your previous version of the cheat sheet and easily move the data I have been entering to the updated version? If so, how will I do that? Again, Thanks so much for these sheets! They make fantasy life so easy!
Jordan Thieme02/22/2014 at 4:36 PM
I'm in a points auction league, would my best option be to use the roto auction sheet and set my categories to try and be more reflective oh how the points are scored, something like TB, BB, R, RBI, SB for hitters?
These are awesome though and I'll definitely be using this for my other roto auction league! Thanks!
Jim M02/23/2014 at 6:09 PM
Ive tried importing my projections and used your projections template. However when I set up the cheatsheet, I get an error message saying the subscript is too large.
Smitty02/26/2014 at 4:21 AM
When will the Yahoo draft analysis data be added?
Gags02/26/2014 at 4:22 PM
Being able to sort/filter by team would be a great option as well.
Hogtown's Heroes02/26/2014 at 4:25 PM
Any chance of an update before Saturday, March 1? -sobs-
If not I will go with a weighted Steamer/fans projection, but was really hoping to include ZiPS! Damn Replacement Level Yankees and their dragging feet.
JWF02/27/2014 at 12:28 AM
Thanks for the spreadsheet!
Is there any way to change the positional eligibility to Yahoo?
Greg Baumler03/01/2014 at 7:10 PM
Yes I was wondering the same here. Also would second adding k's in the hitter categories as a bad influence on score.
Greg Baumler03/01/2014 at 7:12 PM
If possible that is. This is awesome and I thank you. The few comments I have seen complaining come on now. Luke is helping us on his own time.
Luke03/01/2014 at 7:18 PM
Good call, JWF and Greg… I hadn't thought of having different settings based on site position eligibility. Not sure how long it'll take to implement but I think I'll try to get that in the next update.
Luke03/01/2014 at 7:19 PM
This should be fixed in the latest update. Thanks for pointing it out.