Last week, I mentioned that there are often great ideas for new features to add to the fantasy cheatsheets that are suggested by readers here. I was very excited about introducing the Custom Projections feature last week and there will be more written about that soon. But, this week, I took on the task of tackling the feature that has been asked for the most year after year. Yes, the spreadsheets will now be able to handle NL-Only and AL-Only leagues! Not only that, if you’re in a league that allows for certain teams from both leagues but not all teams, you can do that too. For certain folks, this will be a huge addition as you’ll finally be able to use these sheets for your specific league type. I encourage you to check out the update and play around with it prior to draft day.
In this latest and greatest update, I also did a bunch of other tweaks for point-based leagues (including adding a Points Per Plate Appearance and Points Per Innings Pitched stat). In addition, all of the projections are up-to-date as well as the average draft position and average auction value data.
With the features that were added last week and the addition of ADP from Fantasy Gameday, I feel that the cheatsheets are way better than they’ve ever been. But, definitely toy with them and let me know if you find any bugs or oddities.
Now for the standard disclaimers that accompany each release…
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:
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.4 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
- 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
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
03/12/2013 at 7:36 PMAny chance of adding HR allowed as a pitching stat in next pts. league release?
Only other things on my wish list are:
Ability to refresh data sources from within sheet.
Ability to add additional data sources manually (once formatted), such as PECOTA if one is a subscriber.
Ability to choose weightings used only for playing time (in addition to hitting weights and batting weights).
Ability to double-sort by position and then by projected pts.
Thanks for the great work
Luke
03/13/2013 at 3:39 AMGood ideas all around. Could you expand a bit on your playing time weights idea?
MP
03/13/2013 at 5:23 AMSure. The premise is that certain projection sets are going to be good at rate projections but bad at playing time projections (E.g., Marcel and Oliver), and others vice versa. So ideally, one would be able to choose a custom weighted (say, 50/50 Steamer/Rotochamp) playing time projection source. Then the hitting and pitching projections (each using its own source-weighting) would be pro-rated up or down to match the playing time forecast.
So let's say your custom playing time forecast projects 650 PA for Pujols. Then each of your hitting projection components would be pro-rated to 650 PA for that player. So if, say, Steamer projected stats for 600 PA for Pujols, you would multiply Steamer's projected HR, R, RBI, SB by 650/600 = 1.083 to get the final projected counting stats.
It's basically what Fangraphs is currently doing to Steamer projections: converting them to per-PA and per-IP projections and then multiplying by Fans' playing time projections.
Hope this makes sense.
P.S. Some alternative research on forecast accuracy, with special attention to playing time vs. rates: http://razzball.com/fantasy-baseball-projections-review-2012/
Jason Hitt
03/13/2013 at 6:51 PMHi Luke, thank you for these sheets. They are a great tool. I was wondering if you could add a "comments" column to the right side of the draft central tab so that notes on individual players/narcos, etc could be visible right along with the projections. I've added notes on a separate tab, but would love for it to be all visible together and governed by your codes for sorting by position, etc and hiding when players are drafted. The protection on the sheets seem to make this impossible though. Thanks for any help you can offer!
Luke
03/13/2013 at 9:12 PMI like that idea, Jason. I had a similar feature in a very early version of the cheatsheets years ago but it got scrapped somewhere along the way. I'll get it added back in.
And, good idea as well, MP. I'll see what I can do but might be tricky for 2013.
Brian Stanley
03/14/2013 at 2:45 PMHow can I best utilize this spreadsheet in a Head to Head League where points are awarded by each category at the end of the week?
al
03/16/2013 at 9:26 PMThanks for the sheets!
I have a question about the Current Projected dollar values.
During a draft today I entered the Winning bids into the sheet, and followed the Curr Proj $ Value. However, for my 12 team $260 budget league, I was getting a total sum of (Winning Bids + Curr Proj $ Value) to be less than the $3120 league budget. It was giving me something around $2700-$2800 during the middle of the draft.
Any idea if I did something wrong?
Luke
03/16/2013 at 11:46 PMVery odd… I can't replicate the error on my end. Did you save the sheet at the end? If so, could you send me a copy of it so I can try to see what may have caused it? My e-mail is lgloeckner at gmail dot com.
Rachel Johnson
03/17/2013 at 8:45 PMLuke, love the sheets. I put in a 10 team league and when I look at live standings team 10 is not on there but team 11 is. So if I enter Mike Trout for team 10 for $10 it doesn't show up under live standings, he does show up under team summary but the money isn't subtracted from the total.
Luke
03/17/2013 at 9:34 PMThanks! I see what the problem was and updated a new version of the Roto Auction sheet that fixes it.
eric
03/24/2013 at 3:39 PMLuke,
Great sheets you have created here. I am using the auction sheet and when I click on customize to hide drafted players, it seems to be hiding everybody. Any suggestions? Maybe I am doing something wrong?
Thanks again for providing these. They are a huge help
Luke
03/25/2013 at 3:33 AMAh! Nope, it's not just you. I messed up that setting with my latest update there. I'll post an updated version soon (though I assume your draft may already be done).
mike maxey
03/26/2013 at 12:55 AMThis is awesome!
Is there a v1.5 coming out that will update the source ADP files?
Thanks!
Mike
Luke
03/26/2013 at 3:48 PMI plan on doing the "final" update in the next day or so and that would include the most up-to-date ADP and projections.
mike maxey
03/26/2013 at 5:44 PMMost excellent! Look for my donation via paypal!
Luke
03/27/2013 at 1:52 PMThanks so much, Mike. I'm humbled and appreciative! Good luck in the drafts (also, latest version is up with new ADP and projections).
Danielle DeVries
03/27/2013 at 8:51 PMThe new sheet won't sort correctly for "points"!
Luke
03/27/2013 at 9:15 PMGood catch! Thanks for that. When I added a new Notes column, that messed the sorting. I've uploaded the corrected versions.
Jeff
03/29/2013 at 8:05 PMWhich sheet should I use for Head to Head? The points cheatsheet? That's the one that seems to value pitchers more which transfers over to head to head.
Thanks!
Luke
03/29/2013 at 8:45 PMIs it Roto H2H?