In lieu of any wonderful articles this week, the work here has been completely focused on getting the initial cheatsheets released and here’s the last of them. This cheatsheet is for those that are in leagues for point-based scoring instead of roto leagues. You’ll be able to set your scoring system, teams, required starters and all of that fun stuff that you’ve come to know and love.
Here’s the basics info you need to know about these spreadsheets as I’ve gone over previously:
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 all sorts of information about your unique league settings and what projection systems, expert rankings and ADP data that 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 and their project point values, points above average at their position, their projected stats and odds that the player will be available at various points in the draft. 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. 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 and it will also display the team budget. 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 the various parts of the spreadsheet may mean.
Data included for this release:
- CAIRO projections
- RotoChamp projections
- Fangraphs Fan projections
- MockDraftCentral ADP
- ESPN rankings
- RotoChamp rankings
- Roto Summit rankings
- Combined rankings (average of available rankings)
Unique features in the H2H cheatsheet compared to other cheatsheets:
- Ability to set your league’s scoring system and see the projected total points for each player
- Ability to track standings based on projected total points for each team
For you pointy fans of point-based leagues, dive into this cheatsheet and test it out to make sure everything is there for you. Once March comes along, it will be hard to implement any changes or new features so request them now if you spot any possible improvements or bugs! Also, check my Twitter feed to see when minor updates are made that aren’t posted on this site.
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.