There’s a pretty good reason that this site is called Mr. Cheatsheet and that’s because I specialize in creating powerful, customizable and (most importantly) free Excel spreadsheets that you can use to dominate your fantasy baseball drafts. I am releasing the first version of the 2015 draft cheatsheets to the world today but there will be more updates to come over the weeks ahead.
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.
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 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).
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.
Within this release, there are a number of data sources available for projections, rankings and average draft position. There will be many more sources of data coming in the releases between now and April and there will be updates to the current data as well.
Enjoy the cheatsheets and let me know if you have any issues so I can make sure to get them fixed before your draft rolls around!
Luke
03/02/2015 at 7:35 PMHmm, that's interesting. I don't have that built in there currently but I'll think about ways to possibly add that in.
Luke
03/02/2015 at 7:36 PMThat's odd. I'll be loading an updated version soon so hopefully that'll fix the issue you're seeing.
Luke
03/02/2015 at 7:37 PMI think Errors and Games Started should be easy enough… I'm not sure if I have projections which have any Blown Save or Double Play data though.
Luke
03/02/2015 at 7:37 PMNot sure! I'll test it out and see if I can recreate it. I'll be loading a new version of the sheets soon so maybe that'll fix it for you.
Andrew Hafemann
03/02/2015 at 11:07 PMThanks Luke! Maybe it's not how the sheet is supposed to work. Looked at my sheet from last year and it doesn't seem to have it either. Is the sheet designed to change the projection categories based on the categories you pick in the Settings? If not, then there's no problem. Just thought I'd check. I really appreciate your work and this sheet!
Jason Stini
03/03/2015 at 1:57 AMI love the spreadsheet, it looks great and is pretty the formulas you are using are pretty impressive. I am using the Points worksheet and there seems to be an error in the Draft Odds section. I followed the formula through and it looks like the problem is being caused by column AD. This "Early" field is currently pulling in Team. I believe you just need to adjust which column that formula is pulling, and you may want to double check the "Late" column as well. I think this will fix it, but I'll leave that to you. Looking forward to the update, and thanks for the time you've spent on this
Luke
03/03/2015 at 1:59 AMThanks! Good catch. I had to make a few changes in the first version this year and must have forgotten to update those fields. The new version will be out soon and will have that fixed. Appreciate the feedback.
Luke
03/03/2015 at 2:00 AMAh, yes, I limited the projected stats shown on the Draft Central page to just those basics because it got too crazy with all of the other stats trying to fit on there. As a result, I made that Player Profile tab to show every single stat for each projection even though you can't see them all at a glance on that main page.
Luke
03/03/2015 at 4:39 PMFYI, I uploaded a new version that has Errors and GS at the very least
Luke
03/03/2015 at 4:39 PMGot it fixed. Thanks again!
Luke
03/03/2015 at 4:40 PMFYI, I've added IF as a roster spot in the latest update.
Signia
03/04/2015 at 1:56 PMHi, just FYI you have a bad link to the 2015 spreadsheets on the top and the sidebar. The href is pointing to http://www.mrcheatsheet.com/2015/02/2015-cheatsheets-2.html
Signia
03/04/2015 at 1:59 PMWhen using just Zips projections, the pitchers wins are also being populated in the Save column thus producing incorrect fantasy points on the Points league draft spreadsheet
The Marc
03/04/2015 at 6:04 PMThis comment has been removed by the author.
The Marc
03/04/2015 at 6:05 PMI'm having a problem with all the teams not showing up on the live standings tab (points version).