The cheatsheets keep on coming! Today, I introduce the first roto auction fantasy baseball cheatsheet from this here website. For all of you auctioneers out there, this handy little spreadsheet will serve you well. As opposed to just looking at ADP data and selecting who drafted who, you’ll be looking at projected dollar values based on your league settings and selecting who picked who and what they paid for them. You’ll be able to track your team and everyone’s budgets within the spreadsheet as well. There’s more information packed into this little spreadsheet than you can shake a metaphorical stick at!
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 expert dollar values 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 WERTH roto values (estimated points gained in standings for owning the player over average fantasy starter), their projected stats and what their auction value would be based on your settings and the current money in the total pool. 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 and then putting the winning bid in as well. 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
- CBS Sportsline auction values
- RotoChamp auction values
- ESPN rankings
- RotoChamp rankings
- Roto Summit rankings
- Combined rankings (average of available rankings)
Unique features in the auction cheatsheet:
- Auction values that change based on your league settings and update as your draft occurs (when someone overpays for a player, it drops the value for all other players because the total pool of money was reduced more than expected)
- View expert auction values that are adjusted to your league settings and thus more relevant to you
- Check team budgets throughout the draft with ease
This is unmarked territory for the cheatsheet so I want all of you auctioneers to test it out and let me know if something isn’t working right. I’m admittedly not the best beta tester in the world and want to make sure everything is working perfectly come draft day.