Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 21 > Perfect Team 21

Perfect Team 21 Perfect Team 21 - The online revolution! Battle tens of thousands of PT managers from all over the world and become a legend.

Reply
 
Thread Tools
Old 03-23-2020, 11:39 AM   #1
RoteLaterne
Major Leagues
 
RoteLaterne's Avatar
 
Join Date: Jun 2009
Location: Germany
Posts: 387
LeMandria's PT Spreadsheets & KleineBiere's OPSCalculator

The world of Perfect Team is no longer the same without DonkeyKongSr.'s spreadsheet.

Anyone who is offering equal data, please DM me.

Help is hig$$$ly apprecia$$$ted.

Last edited by RoteLaterne; 03-23-2020 at 11:55 AM.
RoteLaterne is offline   Reply With Quote
Old 03-23-2020, 12:08 PM   #2
skep
Minors (Double A)
 
Join Date: Apr 2019
Posts: 174
Lemandria was kind enough to put this together.

Ratings
__________________
FTP Warrior



skep is offline   Reply With Quote
Old 03-23-2020, 12:14 PM   #3
Lemandria
All Star Reserve
 
Join Date: Sep 2019
Location: Chicagoland
Posts: 702
It's update time, new leagues= new data.

Get a new version up in the morn, if I can.
__________________
FOTF victim
Farewell
Lemandria is offline   Reply With Quote
Old 03-23-2020, 12:17 PM   #4
RoteLaterne
Major Leagues
 
RoteLaterne's Avatar
 
Join Date: Jun 2009
Location: Germany
Posts: 387
Quote:
Originally Posted by Lemandria View Post
It's update time, new leagues= new data.

Get a new version up in the morn, if I can.
Great work!
Can sort out all different kind of ratings.

Can I somehow calculate like FIP, OPS or wOBP?
RoteLaterne is offline   Reply With Quote
Old 03-23-2020, 05:07 PM   #5
Lemandria
All Star Reserve
 
Join Date: Sep 2019
Location: Chicagoland
Posts: 702
Quote:
Originally Posted by RoteLaterne View Post
Great work!
Can sort out all different kind of ratings.

Can I somehow calculate like FIP, OPS or wOBP?

Sure you can. But I won't.



v1.1 released

https://facethecurtain.wordpress.com/spreadsheet/
__________________
FOTF victim
Farewell
Lemandria is offline   Reply With Quote
Old 03-23-2020, 08:42 PM   #6
kq76
Global Moderator
 
kq76's Avatar
 
Join Date: Nov 2002
Location: Vancouver, Canada
Posts: 10,668
Thanks! I really appreciate this. It's saved me from inputting so much data it's unbelievable.

One question: I noticed at least one player whose data in your spreadsheet doesn't match what I see in OOTP21. ID#16193 Ryne Sandberg, 64 overall, 96 @ 2B, no other positional ratings. Yet you have him as a 3B with a 3B rating. Is this just you entered data of a copy of a player that someone must have already cross-trained at 3B? I don't suppose there's any way that we can see in OOTP what a mint player's ratings were, is there?
kq76 is offline   Reply With Quote
Old 03-23-2020, 09:08 PM   #7
Lemandria
All Star Reserve
 
Join Date: Sep 2019
Location: Chicagoland
Posts: 702
Quote:
Originally Posted by kq76 View Post
Thanks! I really appreciate this. It's saved me from inputting so much data it's unbelievable.

One question: I noticed at least one player whose data in your spreadsheet doesn't match what I see in OOTP21. ID#16193 Ryne Sandberg, 64 overall, 96 @ 2B, no other positional ratings. Yet you have him as a 3B with a 3B rating. Is this just you entered data of a copy of a player that someone must have already cross-trained at 3B? I don't suppose there's any way that we can see in OOTP what a mint player's ratings were, is there?

You'll get cross-trained players picked up. They usually vanish again on the next update.

You CAN get mint-only players, if you only scan tourney rosters (no training in tourneys). Not a bad way to do things, really; if you scan Open tourneys you get boatloads of perfects.

:shrug: It's valuable information to know other positions your players can train up to, and how high they can go--old training guide sheet might not be accurate any more.

But I can see a desire for virgins-only, too. I gawked the first time I saw an Ozzie trained all the way across the infield.
__________________
FOTF victim
Farewell
Lemandria is offline   Reply With Quote
Old 03-25-2020, 02:14 PM   #8
KleineBiere
Minors (Double A)
 
KleineBiere's Avatar
 
Join Date: Dec 2018
Posts: 108
Quote:
Originally Posted by rotelaterne View Post
great work!
Can sort out all different kind of ratings.

Can i somehow calculate like fip, ops or wobp?



OPScalculatorPT21.xlsx





visible ratings*2-1



Contact Lindor: 76*2-1=151








Babe Ruth in game editor


KleineBiere is offline   Reply With Quote
Old 03-25-2020, 02:26 PM   #9
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,402
Is there a simple formula for FIP?
Jeff1787 is offline   Reply With Quote
Old 03-25-2020, 03:32 PM   #10
Lemandria
All Star Reserve
 
Join Date: Sep 2019
Location: Chicagoland
Posts: 702
Update time again; v1.2 now available.

Spreadsheets
__________________
FOTF victim
Farewell
Lemandria is offline   Reply With Quote
Old 03-25-2020, 03:36 PM   #11
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,402
Is there a way to add additional lines to list more players?

For KleineBiere
Jeff1787 is offline   Reply With Quote
Old 03-25-2020, 03:42 PM   #12
Lemandria
All Star Reserve
 
Join Date: Sep 2019
Location: Chicagoland
Posts: 702
Quote:
Originally Posted by Jeff1787 View Post
Is there a way to add additional lines to list more players?

For KleineBiere

? Oh, looks like it's opening on a view way down at the bottom of the list. Whups.
__________________
FOTF victim
Farewell
Lemandria is offline   Reply With Quote
Old 03-25-2020, 03:46 PM   #13
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,402
Quote:
Originally Posted by Lemandria View Post
? Oh, looks like it's opening on a view way down at the bottom of the list. Whups.
Not sure what you mean?
Jeff1787 is offline   Reply With Quote
Old 03-25-2020, 03:47 PM   #14
Lemandria
All Star Reserve
 
Join Date: Sep 2019
Location: Chicagoland
Posts: 702
Quote:
Originally Posted by Jeff1787 View Post
Not sure what you mean?

^ ditto. What do you mean about adding more rows? It's a spreadsheet, nearly infinite rows are available.
__________________
FOTF victim
Farewell
Lemandria is offline   Reply With Quote
Old 03-25-2020, 03:51 PM   #15
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,402
Quote:
Originally Posted by Lemandria View Post
^ ditto. What do you mean about adding more rows? It's a spreadsheet, nearly infinite rows are available.
I was trying it on his spreadsheet (OPS calculator). Trying to add more lines for additional players but can't figure out how to do it?
Jeff1787 is offline   Reply With Quote
Old 03-25-2020, 04:26 PM   #16
Lemandria
All Star Reserve
 
Join Date: Sep 2019
Location: Chicagoland
Posts: 702
Quote:
Originally Posted by Jeff1787 View Post
I was trying it on his spreadsheet (OPS calculator). Trying to add more lines for additional players but can't figure out how to do it?

No wonder it was so confusing; you weren't talking to me. Mea culpa.
__________________
FOTF victim
Farewell
Lemandria is offline   Reply With Quote
Old 03-25-2020, 07:32 PM   #17
<Pion>
All Star Starter
 
Join Date: Mar 2006
Posts: 1,428
Is there a thread or location for the formulas behind the OPS Calculator (converting ratings into hits, 2B, 3B, HR, etc?
<Pion> is offline   Reply With Quote
Old 03-25-2020, 11:38 PM   #18
X3NEIZE
All Star Reserve
 
Join Date: Aug 2012
Posts: 649
Quote:
Originally Posted by Lemandria View Post
^ ditto. What do you mean about adding more rows? It's a spreadsheet, nearly infinite rows are available.
1,048,576 rows max to be exact.
__________________


X3NEIZE is offline   Reply With Quote
Old 03-26-2020, 07:54 AM   #19
RoteLaterne
Major Leagues
 
RoteLaterne's Avatar
 
Join Date: Jun 2009
Location: Germany
Posts: 387
Quote:
Originally Posted by KleineBiere View Post
OPScalculatorPT21.xlsx
Man, thanks for that help!
Really helps a lot!!!!
So close to realty! Awesome!

Last edited by RoteLaterne; 03-27-2020 at 02:17 AM.
RoteLaterne is offline   Reply With Quote
Old 03-26-2020, 02:13 PM   #20
<Pion>
All Star Starter
 
Join Date: Mar 2006
Posts: 1,428
Anyone have a link to the formulas used to calculate the stat line like is done in the OPS Calculator?
<Pion> is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

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:45 AM.

 

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 - 2024, vBulletin Solutions, Inc.
Copyright © 2020 Out of the Park Developments