Ottoneu Surplus Calculator (2018 version)

Thank you, this is incredibly helpful to an ottonewb!

I have updated the dollar values for all four formats based on the latest Steamer projections

1 Like

Interesting:

  • Bellinger $25: 146 games @ .354 wOBA
  • Cespedes $24: 143 games @ .351 wOBA
  • Thames $22: 126 games @ .352 wOBA
  • Gallo $18: 147 games @ .358 wOBA
  • Puig $18: 130 games @ .364 wOBA

Puig’s PA/G really hurts his value, huh?

Pretty much, he and Gallo are both under 4.0 PA/G, while Bellinger/Cespedes/Thames are all over 4.19 (Thames is at 4.38)

1 Like

Another question: I see that your list of players above replacement includes 33-34 players per team and about $380 per team. Does this account for the fact that most drafts do not end with an owner filling out their entire 40-person roster, and having $20 left over to use in free agency? And how might that impact dollar values of players if more money is spent on the auction?

1 Like

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.

1 Like

I have updated the dollar values for all four formats based on the latest Steamer projections

New feature on the Surplus Calc:

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!

2 Likes

Dollar values for all formats have been updated

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?

Yes, I’ve been meaning to add some inflation specific columns, though no promises on ETA.

1 Like

SC broken? It’s giving up on about 1/2 the rosters in my league

Nvm - I got a new copy and it’s werkin

I’ve added the team’s internal ID to the roster export. I mention it on this thread in case it breaks the Surplus Calculator…

I think it did, unfortunately.

Any chance this can get resolved before Wednesday?

I’m working on fixing this now, but I don’t know how long it will take.

Okay, the roster import that was broken is now fixed, everyone will need to download the latest version of the surplus calculator.

3 Likes

kind of frustrating that four days before the cut deadline, a change just had to be made that would break it. couldn’t have waited niv?

Justin already fixed it because he’s the best.

1 Like