Jan 28, 2014

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.


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!

Filed Under:

30 comments:

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

    ReplyDelete
    Replies
    1. What changes are you trying to make?

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

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

      Delete
  3. Which version is best for a H2H league?

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

      Delete
  4. 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.

    ReplyDelete
    Replies
    1. 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.

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

    ReplyDelete
    Replies
    1. 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!

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

    ReplyDelete
    Replies
    1. 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.

      Delete
  7. 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!!

    ReplyDelete
  8. 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!

    ReplyDelete
  9. 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.

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

    ReplyDelete
  11. 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!

    ReplyDelete
  12. 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!

    ReplyDelete
  13. 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...

    ReplyDelete
    Replies
    1. 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

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

      Delete
  14. Hey Luke - did you by chance get it fixed and make an update?

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

      Delete
  15. 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!

    ReplyDelete
    Replies
    1. 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.

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

    I keep getting error messages.

    ReplyDelete
    Replies
    1. 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.

      Delete
  17. 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!

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

    ReplyDelete