My fantasy draft cheatsheets should be the one reason that you visit this website. There’s a reason why this site is called Mr. Cheatsheet after all. Starting today, you can download the 2014 version of my Excel spreadsheets that will give you complete and utter control over your fantasy draft day.
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.
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
Within this release, there are a number of data sources available for projections, rankings and average draft positions. However, there will be many more sources of data coming in the releases between now and April including more projections and updated average draft position data.
Enjoy the cheatsheets and let me know if you have any issues or suggestions for new features! Now is the time to ask!
Joe B.
01/30/2014 at 9:06 PMExcel won't let me make any changes to the sheet, it says that I need a password.
Luke
01/30/2014 at 9:14 PMWhat changes are you trying to make?
Joe B.
01/30/2014 at 9:20 PMTried to put "Player Notes" in and it won't let me type in that column.
Luke
01/30/2014 at 10:01 PMAh, good catch. I'll make the change and post an update soon.
Jim M
01/31/2014 at 2:03 AMWhich version is best for a H2H league?
Jim P
01/31/2014 at 4:42 AMHi Luke, these cheatsheets are great. I have two simple requests: make home runs allowed (HRA) and strikeout to walk rate (K/BB) a category for the pitchers. Right now there's K-BB, but a K/BB would be really helpful.
Hogtown's Heroes
01/31/2014 at 6:16 PMSolid gold. Love the new clean look too. Can't wait for the updated version!
David
02/01/2014 at 2:52 PMI can answer our own question…the roto draft spreadsheet would prob be best for H2H.
Craig Connelly
02/01/2014 at 6:59 PMAnyway to get an "undo" button to reverse errant draft assignments and still keep the pick counter intact?
Luke
02/02/2014 at 3:56 PMI don't think getting K/BB will be too tricky but I may or may not be able to do HRA depending on what the projections I'm using have to offer.
Luke
02/02/2014 at 3:59 PMThank ya, sir! I'm glad someone noticed the more minimalized look 🙂 I hope it will make it easier on the eyes for everyone.
I'm looking forward to getting the updates out too and I'm really excited about some new features I have planned!
Luke
02/02/2014 at 4:00 PMGood idea. I'll see what I can do. In the meantime, if you click on "Show Drafted Players" under Customize then you can go to that player and reassign the team or just click on the team name and punch the Delete button on your computer to clear it out.
Jeff Evanoff
02/02/2014 at 7:09 PMHi Luke- Love the site, as I used it last year for the first time. I apologize if this is a stupid question and I'm missing something obvious, but is your "Special Blend" projections located on the '14 Cheatsheets? I downloaded the Roto version a few mins ago and didn't see the special blend…let me know and thanks a bunch for this awesome site!!
Kent Hinterman
02/04/2014 at 6:05 PMThanks for this! I used it last year and ended up in 2nd place. Not bad for a first time Fantasy Baseball Player. The only stat that is missing from the sheet that is in our league is Total Bases Allowed for pitchers. Is there any way to add this? Thanks again!
Travis Jansen
02/04/2014 at 8:01 PMHow is this free? Amazing!! We're debating going to an auction league, I'm definitely going to try and use this for my draft.
Rocky Parise
02/12/2014 at 1:05 PMCan you make this available in a Google Spreadsheet? Great work!
JordanBartels
02/26/2014 at 9:32 PMI would love to be able to download and use this tool, is there anyway to make it work on a mac or to have it converted to a google doc? Even though I havent seen or used the spreadsheet yet thanks for taking the time to help us all out!
Noah Bodner
02/27/2014 at 8:34 PMIs there anyway to add a name to the non-ranked player? We draft 2 minor leaguers and I would like to add names so they show up on draft summary. This is awesome by the way!
Noah Bodner
02/27/2014 at 9:01 PMAlsoo, for whatever reason one of my teams is not calculating money spent, money left or rank. I am able to select them and draft their players and it shows up under team summary but it does not tabulate correctly…
Noah Bodner
02/27/2014 at 10:10 PMIt appears the issue is when you select a 10 team league, it works fine if i select 12 teams and just leave 2 teams blank, of course that probably messes up projected values and what not though
Luke
02/27/2014 at 10:15 PMAh, yes, I see what you're talking about. I know the fix and will get it resolved and updated tonight.
Noah Bodner
02/28/2014 at 4:57 PMHey Luke – did you by chance get it fixed and make an update?
Luke
02/28/2014 at 4:59 PMYup, I just posted the new cheatsheets this morning and it should include a fix for that.
Tyler
03/07/2014 at 10:56 PMThis would be awesome.
Calvin Kennedy
03/11/2014 at 2:01 AMBest tool I have seen in many years of fantasy baseball – thanks! Is there a way to add eligibility to a player so that he shows up in multiple positions? In my league Edwin Encarnacion is eligble at 3B as well as 1B.
Thank you again!
Stephen Allen Richards
03/11/2014 at 1:16 PMI'm using a mac, is that an issue?
I keep getting error messages.
Luke
03/11/2014 at 1:23 PMYes indeed, sorry. I forgot to put my usual disclaimer for Mac users in this post but the Mac version of Excel lacks some capabilities that make it able to run this sheet. If I have the time to tackle it, I may post a simplified version of the sheet for Mac users that does some of the basic tasks.
Luke
03/11/2014 at 1:24 PMThank you so much! I'm working on making it possible to change positions part of my next update. Hopefully it all works out and is released soon.
Zachary Omaley
03/20/2014 at 9:31 PMWhen I open the spreadsheet it only gives me option to enable content. I did and it does not give me option to enter my league settings in. What do I need to do? Thank you!
Zachary Omaley
03/20/2014 at 9:33 PMWhen I click on the settings and hit "proceed to step one", it just takes me back to draft page.