We’re hitting the time where projections for fantasy baseball are all being unleashed officially for the year. This is great for the cheatsheets here as that means that they are nearing their completion as far as what data will be available for 2013. This week, the cheatsheets are bursting at the seams with more projections than ever before as some old favorites have been added and some new contenders thrown in too. But, before you get started, I encourage you to read the opening post for more information if you are new to Mr. Cheatsheet.
The updates in this release include:
- Added MORPS projections as an option to select
- Added Clay Davenport projections
- Added ZiPS projections
- Updated Steamer projections to reflect their default dataset and added a second option for the Steamer projections using Fangraphs playing time projections
- Updated MockDraftCentral and CBS Sportsline ADP data
- Added ESPN ADP data and average auction values
- Updated RotoChamp and CBS Sportsline auction value data
- Updated Player Profile pages to show all ten of the available projections for each player at a glance
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:
2013 Roto Cheatsheet
2013 Roto Auction Cheatsheet
2013 Points League Cheatsheet
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.2 release:
- CAIRO projections
- Steamer projections
- Steamer (with Fan playing time) projections
- Fangraphs Fan projections
- Oliver projections
- ZiPS projections
- MORPS projections
- Clay Davenport projections
- MockDraftCentral ADP data
- CBS ADP data
- Yahoo ADP data
- ESPN ADP data
- RotoChamp dollar values
- CBS Sportsline dollar values
- Yahoo dollar values
- ESPN dollar values
- ESPN rankings
- RotoChamp rankings
- Hardball Times rankings
- CBS Sportsline rankings
- David Gonos rankings
- Mr. Cheatsheet rankings
- Combined rankings (average of available rankings)
I put a lot of work into these obviously and I’m very happy to put these out for free to the public. However, if you’re a nice fellow and would like to send a dollar or two my way to fund my coffee addiction, hit the donate button below.
MP
02/28/2013 at 5:35 AMWould it be possible to add a Games Played stat for pitchers in the Points League Cheatsheet? Thanks.
Also, I tried clicking on Donate above, but it just logged me into my paypal home page. Is there an address to send to?
MP
02/28/2013 at 5:39 AMIs there any way to save settings to use in a future update of the sheet?
MP
02/28/2013 at 5:48 AMOK, last requests (for now!):
Please add pitcher HR allowed as a stat for the points league sheet.
Could the sorting options be expanded to show, say, only hitters and double-sort by position and by proj. pts.? So you'd see:
Player A 1B 400
Player B 1B 350
Player C 2B 375
Player D 2B 300
etc.
Thanks again.
Luke
02/28/2013 at 1:48 PMOh, wow, thanks for letting me know about the Donate button being messed up. I fixed that.
As far as your requests, Games Played should be easy enough to add in. HR Allowed might be trickier but probably can be done too. I'll look into some more sorting options too, sure.
As far as saving settings, if you save the Excel workbook on your computer after you set your settings, it should be saved when you open it again.
David
02/28/2013 at 3:42 PMI might have asked this question last year but it's slipping my mind. At some point, do you add a "composite projected points" option for the sorting? Right now, it seems you have to select a specific projection system whereas ADP and Rankings have a composite option.
Luke
02/28/2013 at 3:45 PMYup, I'll add in a projection that combines Marcel, ZiPs, CAIRO and Steamer projections into one average. I'm waiting for Marcel to get released before I do that.
However, I might alter the logic a bit this year and put certain weights on some projections over others. I need to do some research on that first though.
MP
02/28/2013 at 5:47 PMCool. Would be ideal if you could allow user-defined weights for both rate stat projections and for playing time projections, and for hitters and pitchers separately. So one could do something like 50% Steamer, 50% ZIPs for hitter rate stats, prorated to 100% Fans playing time projections; and some other combo for pitcher stat/playing time projections. A lot to ask I'm sure, but would be nice.