As Boyz II Men once said so eloquently, we have come to the end of the road. Opening Day is nearly upon us and this is the final release of the 2013 cheatsheets. If you have a draft coming up this weekend, you get the honor of having the hottest and freshest version of these Excel masterpieces. This latest version doesn’t add any new features but gets all of the data up-to-date. All of the ADP and auction values are as fresh as they can be and all of the projections are from the current datasets. In addition, I’ve finally added in the Marcel projections (disclaimer: Tom Tango owns the Marcel projections and opted not to run them this year so this is a third-party version of the usual Marcel projections). Also, this version contains my custom projections which weight the projections individually for each stat based on my previous research.
So, if you love your cheatsheets and you want them to have the most current data around for your upcoming draft then you got it in this latest update.
As for the usual words of warning:
For those completely new to these fantasy baseball cheatsheets, I encourage you to read the opening post for more information on them.
Before downloading the cheatsheets below, please be forewarned that these cheatsheets are designed to work in Excel 2007-2010 and were designed in Windows. The Mac version of Excel (and older versions of Excel) has been known to have problems when trying to operate these cheatsheets. Also, Microsoft has a few security features which makes opening these spreadsheets more annoying than it should be. If you have the default security settings, you’ll be asked if you want to enable macros when opening this spreadsheet and you must enable macros in order for this cheatsheet to work! In addition, Microsoft may point out that the file originated from an internet location so you will have to click the button that says Enable Editing. You can always change your settings in Excel so you don’t get asked that again but those are two hiccups you might encounter before you get to play around in the sandbox here. Now that you’ve been prepped, go ahead and download your cheatsheet of choice:
After opening the cheatsheet, you’ll be presented with a form to enter some of your league specifications such as number of teams, team names, number of starters at each position, your roto categories and so on. You’ll also choose what sources you want to display information from. Keep in mind that you can always change this info later if you just want to close that and peek around for now.
The Draft Central tab is your home base for these sheets and it is where you’ll see a summary of information for each player throughout the draft and this is where you’ll enter what team drafts each player. Changes on this sheet update the Live Standings and Team Summary tabs. The Live Standings tab will calculate each team’s projected starters and base the current standings throughout the draft on that info. The Team Summary tab shows who is on each team and who is projected to be their starters. The Player Profiles tab allows you to compare players and look at all of the projection and expert data for them. For roto leagues, you’ll also see a calculation of how many points in the standings you may gain (or lose) by drafting that player.
Data included for this v1.5 release:
- CAIRO projections
- Steamer projections
- Steamer (with Fan playing time) projections
- Fangraphs Fan projections
- Oliver projections
- ZiPS projections
- MORPS projections
- Clay Davenport projections
- Custom combined projection option
- “Marcel” projections
- Mr. Cheatsheet’s special combined blend projections
- MockDraftCentral ADP data
- CBS ADP data
- Yahoo ADP data
- ESPN ADP data
- Fantasy Gameday ADP data
- RotoChamp dollar values
- CBS Sportsline dollar values
- Yahoo dollar values
- ESPN dollar values
- Fantasy Gameday average auction values
- ESPN rankings
- RotoChamp rankings
- Hardball Times rankings
- CBS Sportsline rankings
- David Gonos rankings
- Mr. Cheatsheet rankings
- FantasyPros expert consensus rankings
It’s been another great year of fantasy baseball draft preparation and I hope you enjoyed these cheatsheets that I put out to the public. I put in a ton of hours into them and I’m very happy that I can put them out to the public for free this year and I hope I can continue to do that. However, if you’d like to give me a pat on the back or figuratively buy me a beer then feel free to punch that donate button below. Happy drafting, y’all!