Introducing the Ottoneu Value Calculator™

kaufmana315 · January 18, 2021, 10:18pm

Hey all, wanted to share a tool I built that some may find helpful around this time of year. I’m calling it the Ottoneu Value Calculator™.

It starts with Depth Charts projections, and with the help of @vibbot and others it converts them to dollar values. The neat thing is that from there, you can make personal adjustments to players (modifying PPG/PPI or G/IP) and see how the corresponding dollar value changes. Included is also a tab to easily export these custom values to be used in the Surplus Calculator in all its own greatness.

Thanks to the folks in this community who helped me along with this effort. If anyone has questions, comments, or suggestions, I’d be happy to hear them!

Link here: Ottoneu Value Calculator 1-18-2021.xlsx - Google Drive

(Click “Open with Google Sheets” and make a copy to get started!)

denmantaylor · January 22, 2021, 8:49pm

Cool and thanks for sharing!

benembry · January 27, 2021, 8:35pm

This awesome stuff… any suggestion on how to update during the season?

kaufmana315 · January 27, 2021, 9:10pm

Glad you like it! I’d have to update the default dollar values manually during the season, but you should be able to continue to adjust your own personal projections and the corresponding dollar values will adjust accordingly.

benembry · January 31, 2021, 2:43am

Where can I find the otto ID# for players that I want to add?

mallon605 · January 31, 2021, 5:14pm

Im new to ottoneu and just want to clarify what this is…as if I’m right, this will be very helpful to my approach. Im in a first year of a h2h points league. Could this sheet be used to estimate auction values? Is it based on projections from fangraphs? Whose projections? Soto should go for 68?

nivshah · January 31, 2021, 5:18pm

You want to start with the Surplus Calculator

This tool lets you tweak dollar values for the SC via changing point rates, but the SC is the thing.

mallon605 · January 31, 2021, 5:35pm

Thanks! As the season moves on, and projections change, is it hard to update the sheet?

nivshah · January 31, 2021, 5:36pm

A better question for the SC thread and Justin, but I believe he publishes updates through the season.

kaufmana315 · February 1, 2021, 3:16pm

Hey Ben, unfortunately you can’t manually add a player to the sheet. If you have a specific question or think someone is missing I’m happy to look into it for you.

rosborne · February 1, 2021, 3:40pm

Thanks for posting this. How did you determine your replacement value (i.e. why 33 shortstops?).

kaufmana315 · February 1, 2021, 4:05pm

Sure thing! Replacement value is somewhat subjective to be honest. SS and 2B replacement level are determined by retrospectively looking back at the # of MI on Ottoneu rosters needed to hit game caps. Generally speaking, most teams roster somewhere between 5 and 6 MI.

rosborne · February 1, 2021, 4:21pm

Thanks. Noticed that you use P/PA or P/GM for your value calculations, instead of total projected points. Do you worry that some players with limited projected playing time will impact your baseline replacement value?

kaufmana315 · February 1, 2021, 5:24pm

Great question. I did spot check players above baseline to ensure that this wasn’t a huge issue, but stand by using P/PA. It’s another way to identify (and correctly value) players who if given full playing time would be more valuable.