Today I am releasing the latest and greatest Ottoneu Surplus Calculator for the 2020 season. I have pre-loaded it with dollar values for all four ottoneu scoring types using the Depth Charts projections (Steamer projections with FanGraphs staff playing time assigned). There are a few big changes this year, so I’ll note those first:
-
The Surplus Calculator has been entirely rewritten from the ground up. The old version of the tool was hacked together with features added over multiple years and was getting unwieldy and slow, so I rebuilt it from scratch in order to focus on the features I knew I wanted and to keep it leaner and quicker. You should notice that this year’s version is quicker to load and will also work MUCH better on mobile devices.
-
I’ve added a few features like inflation assumptions for keep/cut on the tool, inflation adjusted surplus, FA prospect list, the Arb Targets tab can now be sorted by Team and by Overall surplus assets, and the ability to paste in Custom $ Values should work better than it did before.
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 SC in B16 on the Team Totals tab, everything else will load automatically once you’ve done that
-
Select Yes or No in B19 of the TeamTotals tab to designate whether you’d like the tool to assume pre-keeper deadline (so the tool automatically flags players as keeps and cuts) or post-deadline (the tool assumes all players on all rosters are keepers). This is currently defaulted to No (pre-deadline).
-
Select Yes or No in B20 to indicate whether your league has auctioned yet or not. If this is set to Yes then the Proj Team Val (the tool’s estimate of final team strength) will assume that teams can use their remaining available salary to acquire 50% in value (so a team post-auction with $10 in available salary gets a $5 bump). If this is set to No then the Proj Team Val will assume that teams will acquire value at auction with their remaining available salary equal to the inflation Discount % (to reflect the premium teams need to pay at auction to acquire assets).
-
Select Yes in B21 if you want to paste in your own custom $ values on the Custom$Values tab in the same format as the standard SC $ values (see the headers on the Custom$Values tab to see which columns you will need for your pasted values). This will load those pasted values instead of the standard SC $ values. If this is set to No the tool will automatically load the standard $ values for your league’s format.
-
The Inflation Assumption in B23 on the TeamTotals tab can be used to change the breakpoint the tool uses to determine keepers. At 0% (the default), the tool behaves just like it did in the past and assumes every player with a salary higher than their $ value will be cut, and all others kept. The higher you sent this % the more players the tool will flag as keepers. By changing this value you can get a better sense of how the projected team totals change and a more accurate view of who will be kept. For example, Trout is projected at $75 for FGPts, it’s unrealistic to expect owners will cut a $79 Trout, so using a 10% Inflation Assumption will allow the tool to flag that Trout as a keep and not a cut.
-
The Team Roster tab will let you select any team in your league and sort that team using a few different options (by Salary, Position, Surplus, and $ Value). This tab now also shows the Inflation adjusted Value (using the Inflation Assumption you enter on the TeamTotals) and Inflation adjusted Surplus.
-
The FreeAgents tab works just like it did before, showing all available FA in your league, with options to sort by Ownership % or $ Value. There is now also a minor league specific FA tab showing just prospects unowned in your league.
-
The RestrictedList tab is useful for leagues that have MiLB offroster systems, showing all players who have been designated on the Restricted List by their league commissioner.
-
The ArbTargets tab lists all players with surplus ($ values above their salary, ignoring inflation) with options to sort by team or overall.
As always, if you have questions about how to use the tool, or suggestions for features to add, please let me know.
Ottoneu Surplus Calculator 2.0 Public 2020
Changelog:
2/19- Updated $ values for all four formats using Depth Charts projections (which now include Steamer + ZiPS)
1/24- Updated $ values for all four formats (which fixed a small bug where some players had appeared twice on the $ values)
12/13- Pushed a small fix to correct a bug with the loading of Custom $ Values
12/13- Initial release of 2020 SC with $ values for all four formats using Depth Charts projections (Steamer only)