Full Database of Players with OPS & FIP Calculations
 

*****THIS DATABASE WILL NO LONGER BE UPDATED - DKS 3/11/19*****

Now that the final cards have been released and OOTP XX is upon us, I've decided to go ahead and post my player database. It's accessible at the link below and is mostly complete, except for a small handful of batters and starters, plus a decent chunk of SP as RP (if you didn't already know, their Stuff changes). If you can contribute any of the missing players listed in the first reply to this post, I'll update the database.

OOTP19 Perfect Team Player Database


NOTES:

• There are 3 tabs: batters, starting pitchers, and relief pitchers. The RP tab includes SP converted to RP. Batting and pitching stats are available for nearly all players in case you want to look at 2-way potential.
• Batters are only Bronze+ and Pitchers are only Silver+. Sorry if you are looking for lower players, but they just cluttered up the lists and I never use them anymore, so I dumped that data awhile ago.
• All the columns are conditionally color-coded to show relative ranks. The keys are at the tops of the tabs. EDIT: Oops, Google Sheets killed the Conditional Formatting. Sorry, but I'm not going to spend the time to fix it. :(
• All the OBP/OPS/FIP columns are ranks vs. the population. You can unhide the formulas to the left, but the numbers aren't going to match anything in the game. They are directionally pretty solid for comparing player potential.
• The OBP & OPS calculations are based on formulas found around the site (sorry, I don't have a name to credit). They are a good guide to compare players, but the more I play in the higher leagues, the more evident the lack of Avoid Ks in the formulas is a problem. Really low Avoid Ks guys will underperform a ton.
• The FIP formulas are based on ASURay's last iteration from a couple months or so. These generally seem to be really solid.
• All the max defensive position levels are based on another set of formulas I found somewhere on this site. They will vary from reality by +/- 2 points. None of them are actuals from the game, so don't get upset if a player comes stock with an 80 in the game and the table says 82.
• Yellow highlighted names are incomplete stats. Be warned that these players will not show up when you sort by vL or vR, so until I get the data filled in, the split rankings will be missing some really good players.
• The players are listed as FIRST LAST - OVERALL (AGE) to delineate between the handful of players that have 2 cards with the same Overall.
• Unfortunately, since the database was created using the Export function and you can't export card types (Historical All-Star, etc), that information is not included.

That should probably be enough as long as you know how to manage a spreadsheet. Feel free to download and manipulate the formulas as you like.

*****THIS DATABASE WILL NO LONGER BE UPDATED - DKS 3/11/19*****

INCOMPLETE PLAYERS

If you own these cards, or can find them in your leagues, please PM or post a screenshot of the entire RATINGS tab. Be sure to include the age and handedness parts at the top so I can include those. I'll chop the list down as I update the spreadsheet.

BATTERS

• Mickey Mantle - 99 (1956 Top WAR Season)
• Ivan Rodriguez - 97
• Ted Williams - 96 (1946 Top WAR Season)
• Ichiro Suzuki - 93
• Frank Robinson - 91 (1961 Historical All Star)

STARTING PITCHERS

• Jim Palmer - 93
• Tom Seaver - 90

TRUE RELIEF PITCHERS

DONE!

SP->RP CONVERSIONS
(DO NOT SEND ME THEIR SP RATINGS)

• Greg Maddux - 100
• Red Ruffing - 99
• Dwight Gooden - 97
• Cy Young - 96
• Dazzy Vance - 96
• Walter Johnson - 96
• Bob Feller - 96
• Bret Saberhagen - 96
• Lefty Grove - 95 (1931 Record Breaker)
• Old Hoss Radbourn - 95
• Bob Gibson - 94
• Jim Palmer - 93
• Bret Saberhagen - 92
• Tom Seaver - 92
• Cy Young - 91
• Vida Blue - 91
• Robin Roberts - 90
• Brandon Webb - 89
• Herb Score - 89
• Jim Bunning - 87
• Steve Carlton - 87
• Orlando Hernandez - 87
• Lefty Grove - 86
• R A Dickey - 86
• Wilbur Wood - 86
• Warren Spahn - 86
• Jim Palmer - 85
• Pete Schourek - 85
• Dick Ellsworth - 84
• Brett Anderson - 82
• Britt Burns - 81
• Wayne Garland - 80
• Todd Ritchie - 75
• Dave Fleming - 73
• Dave Stewart - 72
• Bruce Hurst - 71

Combed through my leagues to see if I could contribute anything. The only card here that's mine is the Nolan Ryan, but I *believe* the other starters shown are properly set to reliever in the screenshots.

Batters:
Pete Rose Sr. (71): https://i.imgur.com/IpNTRwE.jpg

Starters:
Nolan Ryan (88, CAL): https://i.imgur.com/wYQ5nrh.jpg
Orlando Hernandez (87): https://i.imgur.com/RvZ6Dct.jpg

Relievers:
Hideo Nomo (93): https://i.imgur.com/H8Jtj35.jpg
Johan Santana (90): https://i.imgur.com/JsbRFjJ.jpg
Nolan Ryan (88, CAL): https://i.imgur.com/Jy35ZeH.jpg
Jose Fernandez (88): https://i.imgur.com/38xIP9b.jpg
Walker Buehler (87): https://i.imgur.com/cmgaemj.jpg

Elmer Riddle (84) - RP:

There's a perfect Roy Halladay?!?!

no, he's like a 97 or 98 but he is a monster

Oops, fixed. There may be a few small typos. Most of the database was done through downloads and pasting the data,but there were a few hand entered items that I hopefully didn't mess up.

Wow, he can make a great pinch runner.

Thanks, but need the Ratings tab for full splits.

I posted the 100 Joe Kelley here:

http://www.ootpdevelopments.com/boar....php?p=4441942

Sent from my LG-H910 using Tapatalk

Oh yeah, I forgot to mark it as complete because I didn't have an age...not that it mattered with 1 card for him.

Here are Halladay's splits

Here are Mussina's splits

Quick correction, my original screenshots missed a couple pitches:
Orlando Hernandez: https://i.imgur.com/3J6vfYR.jpg
Hideo Nomo: https://i.imgur.com/vYypPHz.jpg

Also someone posted Kirk Gibson on the discord: https://i.imgur.com/AGgUCw5.jpg

DonkeyKong....I for one just want to say thank you so much for the effort you put into this. It makes analyzing a team so much easier. Kudos !!!

Thanks for all the help so far. Whittling down that list.

If anyone knows how to get Conditional Formatting to copy over from Excel, that would be great, because it's so much easier to sift through with the visual cues...

EDIT: Nevermind, they don't copy over because Google Sheets doesn't have the capability to do "Top X" types conditional formatting. I'd have to just hard set a value for each tier.

Here is 96 Feller