Jan 27, 2012

2012 Roto Draft Cheatsheet | Initial Release




Today marks the initial release of the 2012 version of my rotisserie fantasy baseball cheatsheet. For those unfamiliar with these, they are powerful Excel spreadsheets which are designed to give you more information than anyone else at your draft in an easy format.

When opening up the spreadsheet, you may be asked to enable macros. Please enable macros as that is the only way this spreadsheet can work! You will then be presented with a form to fill out where you can enter the number of teams and team names for your league. In addition, you must enter what positions you use in your league, what roto categories then finally choose what ADP information, projection systems and expert rankings you want displayed. You can always change this info later! If you just want to look at the sheet, you can just close that form and start looking around.

Within the Draft Central tab, you have all of the draftable players, their basic info, their WERTH roto values (estimated points gained in standings for owning the player over average fantasy starter), their projected stats and then the odds that they'll be available at various points in the draft based on your chosen ADP data. At this point, you can click on the Customize button to choose whether you want to hide certain data or hide players as they're drafted. During the draft, you can select who drafted each player by clicking on the box next to each player's name and selecting the team. This will update the Live Standings and Team Summary tabs. You can also choose how you want to sort the cheatsheet at any time on this page.

On the Live Standings tab, this will take into account the projected starters for each team based on your league settings then it will display the standings based on that info. It will display the total roto values (which should be relatively close to the projected standings as you go) and then the actual projected standings based on drafted players.

On the Team Summary tab, you can view who has been drafted by each team and see who is currently projected as a starter or bench player on those teams. Finally, you can view the Credits & Glossary tab to see where the data is coming from and to find out what various terms mean like ADP or WERTH.

Data included for this release:
  • CAIRO projections
  • RotoChamp projections
  • Fangraphs Fan projections
  • MockDraftCentral ADP data
  • ESPN rankings
  • RotoChamp rankings
  • Roto Summit rankings
  • Combined rankings (average of available rankings)
New features for 2012 version compared to 2011:
  • Team Summary tab added (as explained above)
  • Live Standings now only based on team's starters as opposed to all drafted players
  • Draft Central tab is redesigned to be easier to read and follow
  • Customize button added to have more control over what is shown and not shown
  • Ability to sort by position now added so you can more easily target a specific position when needed
  • Formulas behind the scenes were streamlined to speed up the processing time of the spreadsheet
Poke around, test it out and let me know if you encounter any possible fixes or upgrades before the final version comes out in March!

Filed Under:

16 comments:

  1. Stumbled across your website yesterday, and saw you posted your spreadsheet today, this spreadsheet is quite good! Any chance of adding a couple options? My roto league is an auction, any chance of auction data being added? How about adding holds? All of my leagues include holds, that would be a huge help. Finally, could you add an option to split the OFs into LF, CF, and RF? All my leagues do this as well.

    Thanks for making such a great draft prep tool!

    ReplyDelete
  2. Great ideas, Smitty! I should be able to throw something together for auction values for the next release. As far as holds, I should be able to do that too. Some of the projections don't include holds but it's the same situation for saves and I try to have default save totals to put in for those projections that don't include them.

    And, I like the idea about splitting the outfielders... That one might require some tinkering and such but I like a challenge!

    Thanks for the suggestions, kind sir.

    ReplyDelete
  3. Just came across the site today and I'm thoroughly impressed! I'm a mac user and am having some issues given Excel 2008's lack of support for Macros. This might be outside your purview, but any ideas how to overcome this?

    ReplyDelete
  4. Ah, yes. It's unfortunate that Excel 2008 doesn't support macros despite Excel 2004 and 2011 supporting macros on the Mac (hmm, "macros on the mac" is a funny little statement). I haven't done any testing on a Mac yet but I do have it in my goals to get something working on there too. I hope to do some testing soon and see if I can come up with anything. If so, I'll definitely post a blurb on the site.

    ReplyDelete
  5. Wow, Thanks for all the hard work on this spreadsheet ( I feel like Billy Bean in Moneyball ). The only problem that I have is that after I enable the macro's," I get runtime error '380'. "Could not set the ControlSource property. Invalid property value. " I am running this under excel 2011 mac version.

    any suggestions are appreciated and again thank you


    Mark Willmes

    ReplyDelete
  6. Thanks, Mark... Or should I call you Billy Beane?

    Unfortunately, I haven't tested on the Mac yet. It was built in Windows in Excel 2010. Before I post the next version of the cheatsheet, I'll test it a bit on the Mac to see if I can get it running there too. Don't want my Mac friends to miss out on the fun.

    ReplyDelete
  7. I am in a 20 team auction league. Can you increase your spread sheet to include 20 teams?

    ReplyDelete
  8. Yeah, that's not a bad idea. In the next version I release, I'll do that.

    Unrelated but related, I'm planning on posting an auction version with LF/CF/RF options in next week. Hold will be added as well soon enough once I figure out what the best way to work them in will be.

    ReplyDelete
  9. Im not sure if you got my tweet, but CBS has holds projections under the "Advanced" stats. I will keep looking to see if I can find anymore so there could possibly be a composite.

    Thanks for hooking up the auction, LF,CF,RF, and holds data!

    ReplyDelete
  10. Ah, no, I didn't see that tweet! Thanks very much for that. That should help me out. I'll probably be releasing an updated standard version of the cheatsheet soon and then the auction version will be a little after that.

    ReplyDelete
  11. Luke, one of the categories we use in our 6x6 league is innings pitched. Can you add this to your projections?

    ReplyDelete
  12. Yup, I can get that added in. I'm in the midst of putting the finishing touches on the roto auction version and then the H2H point leagues version... But the next update on this cheatsheet will include that.

    ReplyDelete
  13. How do you change a player's status from Bench to Starter?

    ReplyDelete
  14. I didn't even think of that actually. I just added that in that column as a way of showing you who the spreadsheet is projecting to be your team starters when it does the projected standings. It might be handy for you to be able alter that though... you're right. I'll see what I can do.

    ReplyDelete
  15. Thanks, the only reason I ask is that I see the Projected values only use team starters and I'm not sure how the program decides who should be my starter. For example, I'm doing a mock draft now and my 3rd round draft pick B.J. Upton is on the bench while my 15th round pick Carlos Beltran is starting. It also put Morse and Werth on my bench too. Otherwise the program is great, thanks for doing this.

    ReplyDelete
  16. Oh, geez, I realized there was something screwy with the logic there for outfielders. I've fixed it now so the starters should calculate correctly.

    ReplyDelete