Home | Webstore
Latest News: OOTP Hotfix 21.1.33 - OOTP 21 Available - FHM 6 Available

OOTP Baseball 21 Available 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, 10:39 AM   #1
RoteLaterne
Minors (Triple A)
 
RoteLaterne's Avatar
 
Join Date: Jun 2009
Location: Germany
Posts: 247
Thanks: 89
Thanked 19x in 19 posts
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 10:55 AM.
RoteLaterne is offline   Reply With Quote
Old 03-23-2020, 11:08 AM   #2
skep
Minors (Double A)
 
Join Date: Apr 2019
Posts: 118
Thanks: 49
Thanked 81x in 41 posts
Lemandria was kind enough to put this together.

Ratings
__________________
The FTP Challenge!





skep is offline   Reply With Quote
Thank you for this post:
Justinw303 (03-23-2020)
Old 03-23-2020, 11:14 AM   #3
Lemandria
Major Leagues
 
Join Date: Sep 2019
Location: Chicagoland
Posts: 443
Thanks: 51
Thanked 130x in 96 posts
It's update time, new leagues= new data.

Get a new version up in the morn, if I can.
__________________
We plunder the streets of your town.

Warm Beer Themed FTP

River Valley States Themed FTP
Lemandria is offline   Reply With Quote
5 thanks for this post:
Justinw303 (03-23-2020), kq76 (03-23-2020), Kushiel (03-23-2020), RoteLaterne (03-23-2020), X3NEIZE (03-24-2020)
Old 03-23-2020, 11:17 AM   #4
RoteLaterne
Minors (Triple A)
 
RoteLaterne's Avatar
 
Join Date: Jun 2009
Location: Germany
Posts: 247
Thanks: 89
Thanked 19x in 19 posts
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, 04:07 PM   #5
Lemandria
Major Leagues
 
Join Date: Sep 2019
Location: Chicagoland
Posts: 443
Thanks: 51
Thanked 130x in 96 posts
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/
__________________
We plunder the streets of your town.

Warm Beer Themed FTP

River Valley States Themed FTP
Lemandria is offline   Reply With Quote
4 thanks for this post:
kq76 (03-23-2020), RoteLaterne (03-24-2020), ScudDawg (03-24-2020), skep (03-23-2020)
Old 03-23-2020, 07:42 PM   #6
kq76
Global Moderator
 
kq76's Avatar
 
Join Date: Nov 2002
Location: Vancouver, Canada
Posts: 8,914
Thanks: 1,238
Thanked 952x in 538 posts
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?
__________________
Support the Personal Bodyguard DH or the one-and-done DH
(I think they're both better than both the AL and NL games)
With the advent of openers, I prefer the Personal Bodyguard over the SP-only DH
and more flexible substitution rules.



kq76 is offline   Reply With Quote
Old 03-23-2020, 08:08 PM   #7
Lemandria
Major Leagues
 
Join Date: Sep 2019
Location: Chicagoland
Posts: 443
Thanks: 51
Thanked 130x in 96 posts
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.
__________________
We plunder the streets of your town.

Warm Beer Themed FTP

River Valley States Themed FTP
Lemandria is offline   Reply With Quote
Thank you for this post:
kq76 (03-23-2020)
Old 03-25-2020, 01:14 PM   #8
KleineBiere
Minors (Single A)
 
KleineBiere's Avatar
 
Join Date: Dec 2018
Posts: 87
Thanks: 31
Thanked 80x in 50 posts
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
2 thanks for this post:
Jeff1787 (03-25-2020), RoteLaterne (03-26-2020)
Old 03-25-2020, 01:26 PM   #9
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,021
Thanks: 444
Thanked 420x in 336 posts
Is there a simple formula for FIP?
Jeff1787 is offline   Reply With Quote
Old 03-25-2020, 02:32 PM   #10
Lemandria
Major Leagues
 
Join Date: Sep 2019
Location: Chicagoland
Posts: 443
Thanks: 51
Thanked 130x in 96 posts
Update time again; v1.2 now available.

Spreadsheets
__________________
We plunder the streets of your town.

Warm Beer Themed FTP

River Valley States Themed FTP
Lemandria is offline   Reply With Quote
3 thanks for this post:
Jeff1787 (03-25-2020), kq76 (03-25-2020), RoteLaterne (03-26-2020)
Old 03-25-2020, 02:36 PM   #11
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,021
Thanks: 444
Thanked 420x in 336 posts
Is there a way to add additional lines to list more players?

For KleineBiere
Jeff1787 is offline   Reply With Quote
Old 03-25-2020, 02:42 PM   #12
Lemandria
Major Leagues
 
Join Date: Sep 2019
Location: Chicagoland
Posts: 443
Thanks: 51
Thanked 130x in 96 posts
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.
__________________
We plunder the streets of your town.

Warm Beer Themed FTP

River Valley States Themed FTP
Lemandria is offline   Reply With Quote
Old 03-25-2020, 02:46 PM   #13
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,021
Thanks: 444
Thanked 420x in 336 posts
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, 02:47 PM   #14
Lemandria
Major Leagues
 
Join Date: Sep 2019
Location: Chicagoland
Posts: 443
Thanks: 51
Thanked 130x in 96 posts
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.
__________________
We plunder the streets of your town.

Warm Beer Themed FTP

River Valley States Themed FTP
Lemandria is offline   Reply With Quote
Old 03-25-2020, 02:51 PM   #15
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,021
Thanks: 444
Thanked 420x in 336 posts
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, 03:26 PM   #16
Lemandria
Major Leagues
 
Join Date: Sep 2019
Location: Chicagoland
Posts: 443
Thanks: 51
Thanked 130x in 96 posts
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.
__________________
We plunder the streets of your town.

Warm Beer Themed FTP

River Valley States Themed FTP
Lemandria is offline   Reply With Quote
Old 03-25-2020, 06:32 PM   #17
<Pion>
All Star Starter
 
Join Date: Mar 2006
Posts: 1,410
Thanks: 111
Thanked 373x in 222 posts
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, 10:38 PM   #18
X3NEIZE
All Star Reserve
 
Join Date: Aug 2012
Posts: 565
Thanks: 157
Thanked 253x in 165 posts
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
Thank you for this post:
RoteLaterne (03-26-2020)
Old 03-26-2020, 06:54 AM   #19
RoteLaterne
Minors (Triple A)
 
RoteLaterne's Avatar
 
Join Date: Jun 2009
Location: Germany
Posts: 247
Thanks: 89
Thanked 19x in 19 posts
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 01:17 AM.
RoteLaterne is offline   Reply With Quote
Old 03-26-2020, 01:13 PM   #20
<Pion>
All Star Starter
 
Join Date: Mar 2006
Posts: 1,410
Thanks: 111
Thanked 373x in 222 posts
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 06:27 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 © 2020 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

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