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!
Luke is better known as Mr. Cheatsheet despite his last name not being Cheatsheet. He makes spreadsheets, writes blog posts and his rankings were in the top 10 accuracy among FantasyPros experts in 2014, 2016 and 2017. When he's not doing fantasy baseball things, he can be found playing board games or rating beer.