# Ottoneu Surplus Calculator 2020
**URL:** https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528
**Category:** Baseball Tools
**Created:** [December 13, 2019, 1:41pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528 "2019-12-13T13:41:59Z")
**Posts on this page:** 20
**Page:** 2
### Author:  [@scottegg](https://community.ottoneu.com/u/scottegg)
#### Post date: [December 13, 2019, 8:11pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/21 "2019-12-13T20:11:38Z")
By the way, this is fixed now. Something worked. Thanks!
---
### Author:  [@nivshah](https://community.ottoneu.com/u/nivshah)
#### Post date: [December 13, 2019, 8:13pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/22 "2019-12-13T20:13:21Z")
I made a backend change removing multiple spaces in a row from team names. I deployed it about 30 seconds ago, impressed at how fast you noticed!
---
### Author:  [@scottegg](https://community.ottoneu.com/u/scottegg)
#### Post date: [December 13, 2019, 8:14pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/23 "2019-12-13T20:14:20Z")
Ha. Lucky timing on my part.
---
### Author:  [@KilroySleptHere](https://community.ottoneu.com/u/KilroySleptHere)
#### Post date: [December 13, 2019, 8:49pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/24 "2019-12-13T20:49:36Z")
Thanks, Justin – this is awesome!
When I go to the TeamRoster tab and attempt to sort players by a column besides salary (say, InflSurplus), the entire roster goes blank. I feel like this was doable in the old calculator – am I mixing that up or is there a workaround on this?
---
### Author:  [@vibbot](https://community.ottoneu.com/u/vibbot)
#### Post date: [December 13, 2019, 9:01pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/25 "2019-12-13T21:01:06Z")
Are you using the Sort By dropdown selection on Cell G1 of the TeamRoster tab? You have to use that, you can’t sort that page using Sheets sorting manually.
---
### Author:  [@KilroySleptHere](https://community.ottoneu.com/u/KilroySleptHere)
#### Post date: [December 13, 2019, 9:02pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/26 "2019-12-13T21:02:56Z")
That’ll do it. Thanks!
---
### Author:  [@ltos55](https://community.ottoneu.com/u/ltos55)
#### Post date: [December 13, 2019, 10:46pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/27 "2019-12-13T22:46:57Z")
Thanks so much! I’m a little stuck on what kind of a keeper inflation rate to use for my league. Is it very league dependent? Are there reasonable standards you guys use? Any advice would be welcome.
---
### Author:  [@vibbot](https://community.ottoneu.com/u/vibbot)
#### Post date: [December 13, 2019, 11:29pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/28 "2019-12-13T23:29:04Z")
In my experience actual keeper inflation ends up about 15-20% lower than the Surplus Calc shows by default. So if you enter your league # and the inflation at the bottom in yellow shows as 40%, I’d use 20% as my keeper inflation adjustment.
---
### Author:  [@brandollars](https://community.ottoneu.com/u/brandollars)
#### Post date: [December 14, 2019, 7:49am UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/29 "2019-12-14T07:49:32Z")
Thank you!!!
---
### Author:  [@mwm5062](https://community.ottoneu.com/u/mwm5062)
#### Post date: [December 14, 2019, 4:00pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/30 "2019-12-14T16:00:59Z")
thanks so much for this and all your hard work!
---
### Author:  [@yousmelllikebiscuits](https://community.ottoneu.com/u/yousmelllikebiscuits)
#### Post date: [December 14, 2019, 8:11pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/31 "2019-12-14T20:11:46Z")
Justin: Can you potentially add in the inflation columns to be sortable on the TeamRoster page? I’m in a league where inflation is REALLY high and I’d love to sort by those values as well.
---
### Author:  [@vibbot](https://community.ottoneu.com/u/vibbot)
#### Post date: [December 16, 2019, 1:24pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/32 "2019-12-16T13:24:43Z")
So you want to be able to sort by inflation adjusted $ value on the Team Roster tab? If you sort by “Value” it accomplishes the same thing.
---
### Author:  [@mkirshenbaum](https://community.ottoneu.com/u/mkirshenbaum)
#### Post date: [December 16, 2019, 10:09pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/33 "2019-12-16T22:09:41Z")
Justin – This is an amazing tool as always. Thank you! I have a question about how the values are calculated and how multi-positional eligibility is taken into account. I was looking at the projected value of JD Davis for $5 vs. Ryan McMahon for $10 and wondered why such the discrepancy. McMahon has slightly higher projections from Depth Charts and Steamer, but they are very, very similar and it’s hard to figure how McMahon has twice the value. Is the answer likely to be that McMahon gets a bonus for 1B / 2B / 3B eligibility (vs 1B / OF for Davis)? I think I’ve learned over the years that these projections take into account positional scarcity, but I guess I don’t know how that applies to multi-position players. Thanks for any thoughts!
---
### Author:  [@vibbot](https://community.ottoneu.com/u/vibbot)
#### Post date: [December 17, 2019, 12:58pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/34 "2019-12-17T12:58:57Z")
All multi-position eligible players are valued at their scarcest/most valuable position. Those positions on my sheet from most to least valuable are C/SS/2B/OF/3B/1B. So to answer your question, McMahon is probably worth a $1 or $2 more than Davis based on having slightly higher projections, and another $3 or so because 2B is more valuable than OF.
---
### Author:  [@valis2374](https://community.ottoneu.com/u/valis2374)
#### Post date: [December 19, 2019, 12:35am UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/35 "2019-12-19T00:35:04Z")
I’m interested in understanding how the player values are calculated generally. Is this something you could share?
Thanks for putting this together year after year.
---
### Author:  [@mcampbell4](https://community.ottoneu.com/u/mcampbell4)
#### Post date: [December 20, 2019, 8:12pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/36 "2019-12-20T20:12:24Z")
how do you find your league #? I’ve looked everywhere
---
### Author:  [@stockhfcrx](https://community.ottoneu.com/u/stockhfcrx)
#### Post date: [December 20, 2019, 8:36pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/37 "2019-12-20T20:36:12Z")
It’s in the url
---
### Author:  [@mcampbell4](https://community.ottoneu.com/u/mcampbell4)
#### Post date: [December 20, 2019, 8:39pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/38 "2019-12-20T20:39:26Z")
thank you
---
### Author:  [@D\_Mccarthy](https://community.ottoneu.com/u/D_Mccarthy)
#### Post date: [December 28, 2019, 5:11pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/39 "2019-12-28T17:11:56Z")
Thank you for making available. I downloaded the workbook to my desktop and input my league number (118) and the workbook did not repopulate with my league data. Can anyone provide a suggestion as to what I am doing wrong?
---
### Author:  [@LuckyStrikes](https://community.ottoneu.com/u/LuckyStrikes)
#### Post date: [December 28, 2019, 6:10pm UTC](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528/40 "2019-12-28T18:10:58Z")
Instead of downloading to desktop, trying to copying a version to your own Google Drive so that it can update live
[Previous page](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528.md?page=1)
[Next page](https://community.ottoneu.com/t/ottoneu-surplus-calculator-2020/6528.md?page=3)