Here is a very early version of the Ottoneu Surplus Calculator, I have pre-loaded it with dollar values (FGPts only for now!) based on the just released Steamer 2018 projections. I hope to have values for the other three formats loaded sometime in the next week, and right now this early SC has no additional features since last year’s version , but I have some new features I will be testing and adding soon.
A few important instructions before you use the sheet:
The sheet I’ve linked is locked for editing, so you must make a copy and save it to your own Drive to use it. Just click on File:Make a copy to do so.
Once you’ve made a copy of the sheet, enter the league # you want to run through the Calc in B17 on the Team Totals tab, everything else will load automatically once you’ve done that
The Team Roster tab will let you select any team in your league and sort that team using a few different options. There are other tabs showing the Free Agents in your league, and Arb Targets (the positive surplus players for each team).
2/23- Added RotoGraphs FGPts rankings as an option, Free Agents tab now allows sort by $ value AND ownership %
1/29- Fixed broken roster import
1/23- Dollar values updated for all formats
1/16- Added a Lookup tab to lookup individual player info
1/15- Dollar values updated for all formats
12/18- Dollar values updated for all formats
12/1- Created links to external sheet for $ value tabs, which ensures all SC sheets from this version on have up to date $ values
12/1- Updated $ values for all formats based on slight changes to positional baseline assumptions
11/16- Loaded initial $ values for SABR/5x5/4x4 and updated FG
11/7-Loaded initial $ values for FGPts using Steamer '18