This won’t answer your question, but I thought some insight in how I use the calculator might be useful to you.
I assume the numbers are meant for first year leagues. I’m too lazy to find them right now, but prior articles on Rotographs have talked about inflation being around 25% depending on how old the league is, so I’ve been taking that into account. If you want to use it as a loose guide for what guys might more realistically go for in the draft, in column L on the Team Roster tab put in =J3(asterisk)1.25, go one row down and type =J4(asterisk)1.25, and so on. Again, it’s not perfect, but I think produces more realistic potential auction costs.
Lookup tab, select player name from the dropdown in B1 to see the following information:
*Current owner in league
*Salary
*Average Salary
*2018 projected value per default SC values (specific to league format)
*2015-2017 actual $ value (FGPts only), PPG/PIP, Pts, and G/IP
As always, if you have any suggestions for the calculator please let me know!
My first move when an update comes out is to add columns to team roster and arb targets for inflation indexed values. I add columns for inflation-indexed value, surplus and total value (value+surplus). Any chance of adding these?
I guess I know the main dependency of the Surplus Calculator now! It should be way more stable going forward and I’ll make sure to reach out before I make any future changes to it.
A lot of 3rd party tools use this export (as one might expect) and another dev made a request which resulted in this change.
I’ve added the 2018 RotoGraphs ottoneu rankings as a $ value option, under Team Totals change cell B21 to “Yes” to use those $ values (FGPts only!) rather than the SC default (currently 100% Steamer, soon to be Depth Charts).