Here is a link to the Ottoneu Surplus Calc, I have pre-loaded it with $ values based on Depth Charts projections (equal mix of Steamer and ZiPS). I will keep a change log here as I add new $ values and features.
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. I will probably release an Excel version of the Surplus Calc again this year, but not until closer to the keeper deadline in January
- 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
- Any time you change the league # the teams will disappear from the table, this is normal. To get them back click on cell A2 of the Team Totals tab and you will see the Report Editor pop up on the right side of the page. On the bottom of the Report Editor is a Filter drop down, click on that, click select all, and then uncheck “(Blanks)”.
3/6- Added option to use RotoGraphs composite FGPts dollar values
2/27- Updated $ values for all formats (Depth Charts projections-Steamer/ZiPS)
1/19- Updated $ values for 5x5, 4x4 and fixed $ values for FGPTS, SABR
1/18- Updated $ values for FGPts, SABR
12/6- Removed the need to adjust filter in Team Totals tab, added sort option to Team Roster tab
12/5- Updated $ values for all formats
11/11- Initial $ values for all formats now loaded
11/10- Updated FGPTS $ Values using early Steamer 2017
10/17- Added Arb Targets and Team Roster tabs, see here for more info
10/3- Updated FGPTS $ Values with some manual PA/IP adjustments to Steamer600, added Saves/Holds to RP