Home | Webstore
Latest News: OOTP 26 Available - FHM 11 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 26 > OOTP Mods

OOTP Mods Logos, roster packs, historical databases, OOTP tools, FaceGen files... it's all here!

Reply
 
Thread Tools
Old 05-31-2021, 10:16 AM   #1
southside_hitmen
Minors (Triple A)
 
southside_hitmen's Avatar
 
Join Date: Jun 2006
Location: Chicago, IL
Posts: 201
Surplus Value-based Trade Calculator for OOTP

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!


Last edited by southside_hitmen; 06-01-2021 at 01:53 PM.
southside_hitmen is offline   Reply With Quote
Old 05-31-2021, 08:41 PM   #2
Bobfather
All Star Starter
 
Join Date: Jun 2016
Location: Boston Ma.
Posts: 1,559
Has anyone ever come up with a draft trade value chart? Like the NFL uses?
Bobfather is offline   Reply With Quote
Old 06-01-2021, 09:25 AM   #3
southside_hitmen
Minors (Triple A)
 
southside_hitmen's Avatar
 
Join Date: Jun 2006
Location: Chicago, IL
Posts: 201
Quote:
Originally Posted by Bobfather View Post
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 is offline   Reply With Quote
Old 06-01-2021, 01:44 PM   #4
southside_hitmen
Minors (Triple A)
 
southside_hitmen's Avatar
 
Join Date: Jun 2006
Location: Chicago, IL
Posts: 201
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

southside_hitmen is offline   Reply With Quote
Old 06-01-2021, 03:30 PM   #5
ThePride87
Minors (Double A)
 
Join Date: Feb 2019
Posts: 100
Quote:
Originally Posted by Bobfather View Post
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/
ThePride87 is offline   Reply With Quote
Old 06-01-2021, 05:24 PM   #6
Bobfather
All Star Starter
 
Join Date: Jun 2016
Location: Boston Ma.
Posts: 1,559
Quote:
Originally Posted by ThePride87 View Post
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!
Bobfather is offline   Reply With Quote
Old 06-01-2021, 05:51 PM   #7
southside_hitmen
Minors (Triple A)
 
southside_hitmen's Avatar
 
Join Date: Jun 2006
Location: Chicago, IL
Posts: 201
Quote:
Originally Posted by ThePride87 View Post
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
southside_hitmen is offline   Reply With Quote
Old 06-20-2021, 05:53 PM   #8
nuwildcat
Minors (Single A)
 
Join Date: May 2004
Posts: 53
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.
Attached Images
Image 
nuwildcat is offline   Reply With Quote
Old 06-21-2021, 02:45 PM   #9
southside_hitmen
Minors (Triple A)
 
southside_hitmen's Avatar
 
Join Date: Jun 2006
Location: Chicago, IL
Posts: 201
Quote:
Originally Posted by nuwildcat View Post
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 is offline   Reply With Quote
Old 06-22-2021, 04:09 PM   #10
southside_hitmen
Minors (Triple A)
 
southside_hitmen's Avatar
 
Join Date: Jun 2006
Location: Chicago, IL
Posts: 201
Quote:
Originally Posted by nuwildcat View Post
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 is offline   Reply With Quote
Old 07-20-2021, 01:50 PM   #11
southside_hitmen
Minors (Triple A)
 
southside_hitmen's Avatar
 
Join Date: Jun 2006
Location: Chicago, IL
Posts: 201
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

southside_hitmen is offline   Reply With Quote
Old 07-29-2021, 08:57 AM   #12
Galeg
Major Leagues
 
Join Date: May 2012
Posts: 405
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...?

Last edited by Galeg; 07-29-2021 at 09:00 AM.
Galeg is offline   Reply With Quote
Old 07-29-2021, 11:09 PM   #13
southside_hitmen
Minors (Triple A)
 
southside_hitmen's Avatar
 
Join Date: Jun 2006
Location: Chicago, IL
Posts: 201
Quote:
Originally Posted by Galeg View Post
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.
southside_hitmen is offline   Reply With Quote
Old 07-10-2023, 11:29 PM   #14
ddrewitz11
Bat Boy
 
Join Date: Mar 2017
Posts: 9
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?
ddrewitz11 is offline   Reply With Quote
Old 07-12-2023, 01:53 PM   #15
darkcloud4579
Hall Of Famer
 
Join Date: Jun 2003
Posts: 8,659
Quote:
Originally Posted by ddrewitz11 View Post
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.
darkcloud4579 is offline   Reply With Quote
Reply

Bookmarks


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:39 PM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments