2014 Fantasy Baseball Draft Cheatsheets (Roto, Auction, H2H) Released

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!

You Might Also Like

  • Joe B.
    January 30, 2014 at 9:06 pm

    Excel won't let me make any changes to the sheet, it says that I need a password.

  • Luke
    January 30, 2014 at 9:14 pm

    What changes are you trying to make?

  • Joe B.
    January 30, 2014 at 9:20 pm

    Tried to put "Player Notes" in and it won't let me type in that column.

  • Luke
    January 30, 2014 at 10:01 pm

    Ah, good catch. I'll make the change and post an update soon.

  • Jim M
    January 31, 2014 at 2:03 am

    Which version is best for a H2H league?

  • Jim P
    January 31, 2014 at 4:42 am

    Hi 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
    January 31, 2014 at 6:16 pm

    Solid gold. Love the new clean look too. Can't wait for the updated version!

  • David
    February 1, 2014 at 2:52 pm

    I can answer our own question…the roto draft spreadsheet would prob be best for H2H.

  • Craig Connelly
    February 1, 2014 at 6:59 pm

    Anyway to get an "undo" button to reverse errant draft assignments and still keep the pick counter intact?

  • Luke
    February 2, 2014 at 3:56 pm

    I 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
    February 2, 2014 at 3:59 pm

    Thank 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
    February 2, 2014 at 4:00 pm

    Good 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
    February 2, 2014 at 7:09 pm

    Hi 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
    February 4, 2014 at 6:05 pm

    Thanks 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
    February 4, 2014 at 8:01 pm

    How 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
    February 12, 2014 at 1:05 pm

    Can you make this available in a Google Spreadsheet? Great work!

  • JordanBartels
    February 26, 2014 at 9:32 pm

    I 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
    February 27, 2014 at 8:34 pm

    Is 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
    February 27, 2014 at 9:01 pm

    Alsoo, 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
    February 27, 2014 at 10:10 pm

    It 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
    February 27, 2014 at 10:15 pm

    Ah, yes, I see what you're talking about. I know the fix and will get it resolved and updated tonight.

  • Noah Bodner
    February 28, 2014 at 4:57 pm

    Hey Luke – did you by chance get it fixed and make an update?

  • Luke
    February 28, 2014 at 4:59 pm

    Yup, I just posted the new cheatsheets this morning and it should include a fix for that.

  • Tyler
    March 7, 2014 at 10:56 pm

    This would be awesome.

  • Calvin Kennedy
    March 11, 2014 at 2:01 am

    Best 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
    March 11, 2014 at 1:16 pm

    I'm using a mac, is that an issue?

    I keep getting error messages.

  • Luke
    March 11, 2014 at 1:23 pm

    Yes 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
    March 11, 2014 at 1:24 pm

    Thank 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
    March 20, 2014 at 9:31 pm

    When 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
    March 20, 2014 at 9:33 pm

    When I click on the settings and hit "proceed to step one", it just takes me back to draft page.