|
||||
|
|
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. |
|
Thread Tools |
03-23-2020, 10:39 AM | #1 |
Major Leagues
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 10:55 AM. |
03-23-2020, 11:17 AM | #4 |
Major Leagues
Join Date: Jun 2009
Location: Germany
Posts: 387
|
|
03-23-2020, 04:07 PM | #5 | |
All Star Reserve
Join Date: Sep 2019
Location: Chicagoland
Posts: 702
|
Quote:
Sure you can. But I won't. v1.1 released https://facethecurtain.wordpress.com/spreadsheet/ |
|
03-23-2020, 07:42 PM | #6 |
Global Moderator
Join Date: Nov 2002
Location: Vancouver, Canada
Posts: 10,703
|
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? |
03-23-2020, 08:08 PM | #7 | |
All Star Reserve
Join Date: Sep 2019
Location: Chicagoland
Posts: 702
|
Quote:
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. |
|
03-25-2020, 01:14 PM | #8 | |
Minors (Double A)
Join Date: Dec 2018
Posts: 108
|
Quote:
OPScalculatorPT21.xlsx visible ratings*2-1 Contact Lindor: 76*2-1=151 Babe Ruth in game editor |
|
03-25-2020, 01:26 PM | #9 |
Hall Of Famer
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,420
|
Is there a simple formula for FIP?
|
03-25-2020, 02:32 PM | #10 |
All Star Reserve
Join Date: Sep 2019
Location: Chicagoland
Posts: 702
|
|
03-25-2020, 02:36 PM | #11 |
Hall Of Famer
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,420
|
Is there a way to add additional lines to list more players?
For KleineBiere |
03-25-2020, 02:42 PM | #12 | |
All Star Reserve
Join Date: Sep 2019
Location: Chicagoland
Posts: 702
|
Quote:
? Oh, looks like it's opening on a view way down at the bottom of the list. Whups. |
|
03-25-2020, 02:46 PM | #13 |
Hall Of Famer
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,420
|
|
03-25-2020, 02:47 PM | #14 |
All Star Reserve
Join Date: Sep 2019
Location: Chicagoland
Posts: 702
|
^ ditto. What do you mean about adding more rows? It's a spreadsheet, nearly infinite rows are available. |
03-25-2020, 02:51 PM | #15 |
Hall Of Famer
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,420
|
|
03-25-2020, 03:26 PM | #16 | |
All Star Reserve
Join Date: Sep 2019
Location: Chicagoland
Posts: 702
|
Quote:
No wonder it was so confusing; you weren't talking to me. Mea culpa. |
|
03-25-2020, 06:32 PM | #17 |
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?
|
03-25-2020, 10:38 PM | #18 |
All Star Reserve
Join Date: Aug 2012
Posts: 649
|
1,048,576 rows max to be exact.
__________________
|
03-26-2020, 06:54 AM | #19 |
Major Leagues
Join Date: Jun 2009
Location: Germany
Posts: 387
|
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. |
03-26-2020, 01:13 PM | #20 |
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?
|
Bookmarks |
|
|