Surplus Value-based Trade Calculator for OOTP

[southside_hitmen]

Hi all,
I posted this on reddit a few days ago, but since everyone doesn't sojourn to that area of the internet, I'm reposting here as well

I made a surplus value based trade calculator for OOTP you can use for unleashing your inner Jerry Dipoto.

It's a frankenstein of WARcels (for MLB future WAR calculation), Fangraphs prospect valuation, and surplus value as a whole. Methodology links in the sheet.

Not meant to be a golden hammer, but should give you a sniff test of controlled war and surplus value you would get from trades. Includes options for cash, salary retention, and should work with 20-80 ratings or stats only/mostly.

LINK FOR TRADE CALCULATOR: Surplus Value Trade Calculator

Methodology:
Surplus value
Prospect valuation
MLB WAR Projection

Happy Trading!

[Bobfather]

Has anyone ever come up with a draft trade value chart? Like the NFL uses?

[southside_hitmen]

Originally Posted by Bobfather

Has anyone ever come up with a draft trade value chart? Like the NFL uses?

Great idea! I'm about 90% there with the above gsheet. I can prob put something together for it once I look at where picks usually "land" on fangraphs big board in terms of future value and try to incorporate it into the calculator.

[southside_hitmen]

Made some updates/enhancements to the first tab based on feedback. Should make it easier to wrap your arms around how to use this thing.

It will also now show a sniff test of the trade in the analyzer

[ThePride87]

Originally Posted by Bobfather

Has anyone ever come up with a draft trade value chart? Like the NFL uses?

Yea, Fangraphs has an article about the value of mlb picks....and having tested it on OOTP, they're surprisingly on-point.

https://blogs.fangraphs.com/an-updat...e-draft-picks/

[Bobfather]

Originally Posted by ThePride87

Yea, Fangraphs has an article about the value of mlb picks....and having tested it on OOTP, they're surprisingly on-point.

https://blogs.fangraphs.com/an-updat...e-draft-picks/

Thanks!

[southside_hitmen]

Originally Posted by ThePride87

Yea, Fangraphs has an article about the value of mlb picks....and having tested it on OOTP, they're surprisingly on-point.

https://blogs.fangraphs.com/an-updat...e-draft-picks/

Thanks! This is perfect. I can add it in to the trade calculator this week as well

[nuwildcat]

I really like this tool but I am having an issue. When I download the sheet, for some reason all of the empty MLB slots appear to add value to the trade. Also, the Value calculation seems to have an error. Attached is the initial screen I get after downloading the spreadsheet.

[southside_hitmen]

Originally Posted by nuwildcat

I really like this tool but I am having an issue. When I download the sheet, for some reason all of the empty MLB slots appear to add value to the trade. Also, the Value calculation seems to have an error. Attached is the initial screen I get after downloading the spreadsheet.

I would try re-copying the file. Can't promise it will play nice in excel since I only have google sheets, but it seems like something gets messed up in the conversion to excel

[southside_hitmen]

Originally Posted by nuwildcat

I really like this tool but I am having an issue. When I download the sheet, for some reason all of the empty MLB slots appear to add value to the trade. Also, the Value calculation seems to have an error. Attached is the initial screen I get after downloading the spreadsheet.

I had some help from a friend who has excel to test, and something was def up in the conversion from sheet to excel (tl;dr - excel is more strict on type checking)

Should work better now for excel. Thanks!

[southside_hitmen]

Hi all, I updated my surplus value trade calculator to handle draft picks and a number of quality life improvements for excel

LINK: https://docs.google.com/spreadsheets...it?usp=sharing

[Galeg]

I've had some fun playing around with this. Haven't used it enough to get a feel for accuracy or anything, but it is definitely a cool tool. Thanks for putting in the work!

Question: On the first sheet it shows you can alter the cash/war value, but I don't see that anywhere on the second sheet...?

[southside_hitmen]

Originally Posted by Galeg

I've had some fun playing around with this. Haven't used it enough to get a feel for accuracy or anything, but it is definitely a cool tool. Thanks for putting in the work!

Question: On the first sheet it shows you can alter the cash/war value, but I don't see that anywhere on the second sheet...?

Thanks! You set the $/WAR value on the first sheet and it's used throughout the file.

[ddrewitz11]

This tool seems pretty cool, any thoughts to having it calculate without the potential and overall ratings where you go off contact/stu type ratings instead?

[darkcloud4579]

Originally Posted by ddrewitz11

This tool seems pretty cool, any thoughts to having it calculate without the potential and overall ratings where you go off contact/stu type ratings instead?

Ratings aren't helpful because every league plays so differently based on what system you're using, so stats + overall ratings makes it a lot easier.

But you could fork the spreadsheet and try doing this on your own and share it back with folks, always fun to see how people tweak tools to accommodate how they play.