All-Time Roster Neutralized Stats Project

[bhrangerfan0809]

I've started a project with the intent of using Neutralized Stats from Baseball-Reference to create a universal scale for batters and pitchers across all eras to use as a blueprint for all-time roster player ratings.

This spreadsheet creates ratings based off each player's three best qualifying seasons (I go by OPS for batters and I use a formula for pitchers to determine those three seasons). This is an attempt at creating a "peak" version of any given historical player. If a player doesn't have three qualifying seasons (20 G for Pitchers or 300 AB for Batters), their career neutralized stat line is used.

To create ratings, you just need to copy and paste the player's standard and neutralized stats (1984 AL for Pitchers and 1993 AL for Batters - both 4.42 R/G) in the appropriate boxes in the BatterCalc and PitcherCalc sections, then sort by either pitcher rating or OPS in descending order. You can then find their "Three Best Seasons" and "Career" stat lines in the middle, which are automatically generated.

Finalized Player Ratings are shaded in teal in the Batters and Pitchers sheets. They are all percentiles based on the entire pool of players, so the more players that are added, the more accurate the numbers become.

I have over 4300 historical players added so far. I only recently added a stamina rating based on IP/G from pitchers' three seasons or career numbers, so more and more pitchers will have their stat lines updated with Stamina ratings as I go year-by-year (I started in 2019 and have added each pitcher with at least 20 games in a season, and I'm now in 2006. I have plenty of other pitchers from throughout history already, but this is how I'm being thorough).

You can view the ratings that I have so far below:

https://docs.google.com/spreadsheets...it?usp=sharing

6/7/2020 UPDATE:

https://docs.google.com/spreadsheets...it?usp=sharing

6/13/2020 UPDATE:

https://docs.google.com/spreadsheets...it?usp=sharing

[cardfan07]

Yo, this is super interesting. Thanks for doing it!

[neek_the_sneak15]

This is very cool.

What does 4+C+P stand for in the Batters tab?

[bhrangerfan0809]

Quote: Originally Posted by neek_the_sneak15

This is very cool. What does 4+C+P stand for in the Batters tab?

That’s sorta my equivalent to an overall rating (or really, percentile) for a batter based on those 4 categories (contact, power, vision, and discipline), but weighted with contact and power counting twice as much (so the average of CON, CON, POW, POW, VIS, DIS).

[vgunn]

Very cool. Are you considering putting an all-time roster out there based on these ratings?

[bhrangerfan0809]

I just linked an updated file in the OP that features neutralized three-year-peak statlines for 5,810 players throughout MLB history, including all pitchers to have had at least 20 appearances for the following franchises:

Athletics
Yankees
Angels
Rangers
Astros
Mets
Padres
Brewers
Nationals
Royals
Blue Jays
Mariners
Rockies
Marlins
Diamondbacks
Rays


I'm focusing just on pitchers right now and will move on to batters afterward.

[bhrangerfan0809]

I made huge progress this week and now have every pitcher to have made 20 appearances for any of the current 30 MLB franchises included. To commemorate this, I'm including below the pitching staffs for each team based on their best players from this spreadsheet (as determined by the Rights column AL and the Rating column AI)


Arizona Diamondbacks
SP1: Randy Johnson - 90
SP2: Brandon Webb - 83
SP3: Curt Schilling - 82
SP4: Dan Haren - 76
SP5: Patrick Corbin - 75
RP1: David Hernandez - 85
RP2: Kevin Ginkel - 79
RP3: Jose Valverde - 78
RP4: Brad Ziegler - 77
RP5: Archie Bradley - 77
RP6: Brandon Lyon - 77
RP7: Matt Mantei/Andrew Chafin - 76

Atlanta Braves
SP1: Greg Maddux - 91
SP2: Charlie Buffinton - 84
SP3: Jim Whitney - 81
SP4: John Clarkson - 81
SP5: Kid Nichols - 80
RP1: Craig Kimbrel - 92
RP2: John Smoltz - 90
RP3: Luis Avilan - 85
RP4: Eric O'Flaherty - 83
RP5: Greg McMichael - 81
RP6: Gene Garber - 81
RP7: Chris Hammond/Mark Wohlers - 80

Baltimore Orioles
SP1: Mike Mussina - 78
SP2: Mike Cuellar - 75
SP3: Nels Potter - 73
SP4: Jim Palmer - 73
SP5: Erik Bedard - 72
RP1: Zack Britton - 92
RP2: B.J. Ryan - 88
RP3: Darren O'Day - 87
RP4: Jim Johnson - 82
RP5: Buddy Groom - 81
RP6: Gregg Olson - 80
RP7: Tommy Hunter - 80

Boston Red Sox
SP1: Pedro Martinez - 96
SP2: Roger Clemens - 91
SP3: Smoky Joe Wood - 86
SP4: Cy Young - 82
SP5: Josh Beckett/Jon Lester - 79
RP1: Jonathan Papelbon - 94
RP2: Koji Uehara - 90
RP3: Tom Gordon - 89
RP4: Derek Lowe - 84
RP5: Mike Timlin - 82
RP6: Scott Atchison - 81
RP7: Dick Radatz, 81

Chicago Cubs
SP1: Jake Arrieta - 87
SP2: Mordecai Brown - 82
SP3: Jocko Flynn - 81
SP4: Larry Corcoran - 80
SP5: Rick Reuschel - 79
RP1: Bruce Sutter - 91
RP2: Sean Marshall - 89
RP3: Pedro Strop - 84
RP4: Lee Smith - 83
RP5: Hector Rondon - 82
RP6: Kyle Farnsworth - 81
RP7: Carlos Marmol - 77

Chicago White Sox
SP1: Ed Walsh - 86
SP2: Eddie Cicotte - 77
SP3: Gary Peters - 77
SP4: Doc White - 76
SP5: Billy Pierce - 74
RP1: Keith Foulke - 88
RP2: Matt Thornton - 88
RP3: Bobby Jenks - 88
RP4: Chris Sale - 87
RP5: Roberto Hernandez - 86
RP6: Damaso Marte - 84
RP7: Hoyt Wilhelm - 83

Cincinnati Reds
SP1: Jose Rijo - 83
SP2: Tony Mullane - 81
SP3: Johnny Cueto - 80
SP4: Noodles Hahn - 78
SP5: Dolf Luque - 76
RP1: Aroldis Chapman - 89
RP2: Bill Henry - 86
RP3: Rob Dibble - 84
RP4: Rob Murphy - 79
RP5: Gabe White - 78
RP6: Jeff Shaw - 77
RP7: Ted Abernathy/Scott Williamson - 77

Cleveland Indians
SP1: Corey Kluber - 84
SP2: Carlos Carrasco - 82
SP3: CC Sabathia - 78
SP4: Bob Feller - 78
SP5: Addie Joss - 77
RP1: Andrew Miller - 90
RP2: Doug Jones - 90
RP3: Joe Smith - 89
RP4: Michael Jackson - 86
RP5: Rafael Betancourt - 86
RP6: Oliver Perez - 85
RP7: Jose Mesa/Paul Assenmacher/Bob Wickman - 83

Colorado Rockies
SP1: Ubaldo Jimenez - 75
SP2: Jhoulys Chacin - 69
SP3: Jon Gray - 68
SP4: German Marquez - 67
SP5: Pedro Astacio - 63
RP1: Darren Holmes - 86
RP2: Steve Reed - 84
RP3: Scott Oberg - 80
RP4: Brian Fuentes - 80
RP5: Matt Belisle - 79
RP6: Chuck McElroy - 79
RP7: Adam Ottavino/Curt Leskanic - 76

Detroit Tigers
SP1: Justin Verlander - 81
SP2: Hal Newhouser - 81
SP3: Anibal Sanchez - 81
SP4: Tommy Bridges - 74
SP5: Denny McLain - 73
RP1: Joaquin Benoit - 87
RP2: Doug Brocail - 84
RP3: Todd Jones - 82
RP4: Willie Hernandez - 81
RP5: Hank Aguirre - 81
RP6: Bobby Seay - 81
RP7: John Hiller - 80

Houston Astros
SP1: Gerrit Cole - 81
SP2: Mike Scott - 80
SP3: Roy Oswalt - 78
SP4: Dallas Keuchel - 78
SP5: Charlie Morton/Larry Dierker - 72
RP1: Larry Andersen - 89
RP2: Billy Wagner - 87
RP3: Will Harris - 86
RP4: Dave Smith - 84
RP5: Tony Sipp - 84
RP6: Octavio Dotel - 83
RP7: Brad Lidge - 82

Kansas City Royals
SP1: Zach Greinke - 86
SP2: Kevin Appier - 82
SP3: Bret Saberhagen - 81
SP4: Mark Gubicza - 72
SP5: Danny Jackson - 69
RP1: Wade Davis - 93
RP2: Greg Holland - 90
RP3: Joakim Soria - 90
RP4: Jeff Montgomery - 88
RP5: Kelvin Herrera - 88
RP6: Steve Farr - 78
RP7: Luke Hochevar - 76

Los Angeles Angels of Anaheim
SP1: Dean Chance - 80
SP2: Nolan Ryan - 79
SP3: Frank Tanana - 78
SP4: Jered Weaver - 76
SP5: John Lackey - 73
RP1: Brendan Donnelly - 91
RP2: Bryan Harvey - 90
RP3: Francisco Rodriguez - 83
RP4: Troy Percival - 82
RP5: Scot Shields - 80
RP6: Kevin Jepsen - 76
RP7: Dave LaRoche/Donnie Moore - 75

Los Angeles Dodgers
SP1: Clayton Kershaw - 92
SP2: Kevin Brown - 87
SP3: Sandy Koufax - 87
SP4: Dazzy Vance - 86
SP5: Don Sutton - 81
RP1: Kenley Jansen - 94
RP2: Eric Gagne - 93
RP3: Takashi Saito - 92
RP4: Hung-Chih Kuo - 90
RP5: Steve Howe - 88
RP6: Jay Howell - 85
RP7: Jonathan Broxton - 82

Miami Marlins
SP1: Jose Fernandez - 82
SP2: Josh Johnson - 78
SP3: Brad Penny - 70
SP4: A.J. Burnett - 69
SP5: Dontrelle Willis - 65
RP1: Steve Cishek - 84
RP2: Kiko Calero - 81
RP3: Randy Choate - 78
RP4: Matt Lindstrom - 77
RP5: AJ Ramos - 76
RP6: Kyle Barraclough - 73
RP7: Matt Turner/Nick Wittgren/Kevin Gregg - 70

Milwaukee Brewers
SP1: Teddy Higuera - 77
SP2: Ben Sheets - 76
SP3: Chris Bosio - 69
SP4: Mike Caldwell - 63
SP5: Yovani Gallardo/Mike Fiers - 61
RP1: Dan Plesac - 82
RP2: Jeremy Jeffress - 82
RP3: Ken Sanders - 78
RP4: John Axford - 77
RP5: Ray King - 76
RP6: Ray Searage - 76
RP7: Mike Fetters/Josh Hader - 74

Minnesota Twins
SP1: Walter Johnson - 92
SP2: Johan Santana - 84
SP3: Bert Blyleven - 81
SP4: Francisco Liriano - 77
SP5: Camilo Pascual - 76
RP1: Joe Nathan - 93
RP2: Pat Neshek - 90
RP3: Juan Rincon - 85
RP4: LaTroy Hawkins - 84
RP5: Glen Perkins - 83
RP6: Ryan Pressly - 83
RP7: Rick Aguilera/Taylor Rogers - 83

New York Mets
SP1: Jacob DeGrom - 86
SP2: Dwight Gooden - 85
SP3: Tom Seaver - 84
SP4: Jon Matlack - 75
SP5: Noah Syndergaard/Jerry Koosman/Al Leiter - 74
RP1: Tug McGraw - 84
RP2: Jesse Orosco - 82
RP3: Jeurys Familia - 82
RP4: Addison Reed - 82
RP5: Randy Myers - 81
RP6: Dennis Cook - 79
RP7: John Franco - 79

New York Yankees
SP1: Russ Ford - 83
SP2: Ron Guidry - 83
SP3: Jack Chesbro - 79
SP4: Lefty Gomez - 78
SP5: Andy Pettitte/David Cone - 78
RP1: Mariano Rivera - 96
RP2: Rich Gossage - 86
RP3: Steve Hamilton - 86
RP4: David Robertson - 83
RP5: Chad Green - 82
RP6: Joba Chamberlain - 80
RP7: Mike Stanton/Adam Warren - 80

Oakland Athletics
SP1: Rube Waddell - 88
SP2: Lefty Grove - 85
SP3: Chief Bender - 82
SP4: Eddie Plank - 79
SP5: Vida Blue - 78
RP1: Dennis Eckersley - 92
RP2: Huston Street - 88
RP3: Andrew Bailey - 87
RP4: Rollie Fingers - 86
RP5: Liam Hendriks - 84
RP6: Blake Treinen - 83
RP7: Justin Duchscherer/Dan Otero - 82

Philadelphia Phillies
SP1: Steve Carlton - 85
SP2: Pete Alexander - 82
SP3: Cliff Lee - 80
SP4: Charlie Ferguson - 79
SP5: Jim Bunning 79
RP1: Ryan Madson - 90
RP2: Ken Giles - 88
RP3: Ron Reed - 81
RP4: Rheal Cormier - 78
RP5: Turk Farrell - 77
RP6: Seranthony Dominguez - 75
RP7: Ricky Bottalico - 74

Pittsburgh Pirates
SP1: Ed Morris - 86
SP2: Babe Adams - 79
SP3: Claude Hendrix - 75
SP4: Deacon Phillippe - 74
SP5: Bob Veale/Sam Leever/Doug Drabek - 73
RP1: Mark Melancon - 93
RP2: Felipe Vazquez - 90
RP3: Tony Watson - 87
RP4: Mike Gonzalez - 84
RP5: Kent Tekulve - 77
RP6: Matt Capps - 77
RP7: Jason Christiansen - 76

San Diego Padres
SP1: Jake Peavy - 79
SP2: Andy Benes - 72
SP3: Chris Paddack - 70
SP4: Ed Whitson - 63
SP5: Randy Jones/Andy Ashby - 62
RP1: Mike Adams - 91
RP2: Trevor Hoffman - 89
RP3: Joe Thatcher - 87
RP4: Akinori Otsuka - 86
RP5: Nick Vincent - 85
RP6: Heath Bell - 85
RP7: Kirby Yates - 85

Seattle Mariners
SP1: Felix Hernandez - 83
SP2: Erik Hanson - 71
SP3: James Paxton - 70
SP4: Freddy Garcia - 70
SP5: Mike Moore - 70
RP1: Arthur Rhodes - 92
RP2: J.J. Putz - 91
RP3: Rafael Soriano - 89
RP4: Carson Smith - 87
RP5: Charlie Furbush - 84
RP6: George Sherrill - 80
RP7: Mike Schooler - 80

San Francisco Giants
SP1: Tim Keefe - 89
SP2: Christy Mathewson - 87
SP3: Mickey Welch - 80
SP4: Tim Lincecum - 80
SP5: Jason Schmidt/Juan Marichal - 80
RP1: Robb Nen - 92
RP2: Sergio Romo - 90
RP3: Rod Beck - 86
RP4: Brian Wilson - 85
RP5: Stu Miller - 84
RP6: Javier Lopez - 79
RP7: Don McMahon - 79

St. Louis Cardinals
SP1: Bob Gibson - 86
SP2: Chris Carpenter - 82
SP3: Silver King - 81
SP4: Dave Foutz - 81
SP5: Bob Caruthers/Harry Brecheen - 80
RP1: Jason Isringhausen - 86
RP2: Lindy McDaniel - 84
RP3: Adam Wainwright - 82
RP4: Al Hrabosky - 82
RP5: Dave Veres - 82
RP6: Joe Hoerner - 81
RP7: Jason Motte - 81

Tampa Bay Rays
SP1: David Price - 78
SP2: James Shields - 71
SP3: Alex Cobb - 69
SP4: Blake Snell - 68
SP5: Scott Kazmir/Chris Archer - 67
RP1: Jake McGee - 93
RP2: Fernando Rodney - 85
RP3: Joel Peralta - 78
RP4: Xavier Cedeno - 78
RP5: Alex Colome - 77
RP6: Jim Mecir - 77
RP7: J.P. Howell - 76

Texas Rangers
SP1: Yu Darvish - 70
SP2: Dick Bosman - 62
SP3: Colby Lewis - 61
SP4: Bobby Witt - 59
SP5: Derek Holland - 57
RP1: John Wetteland - 90
RP2: Francisco Cordero - 88
RP3: Darren Oliver - 87
RP4: Jeff Russell - 84
RP5: Neftali Feliz - 83
RP6: Neal Cotts - 81
RP7: Keone Kela/Brian Shouse - 81

Toronto Blue Jays
SP1: Roy Halladay - 80
SP2: Juan Guzman - 80
SP3: Dave Stieb - 75
SP4: Jimmy Key - 73
SP5: Pat Hentgen - 69
RP1: Roberto Osuna - 89
RP2: Mark Eicchorn - 89
RP3: Duane Ward - 87
RP4: Tom Henke - 87
RP5: Casey Janssen - 87
RP6: Brandon Morrow - 83
RP7: Scott Downs - 83

Washington Nationals
SP1: Max Scherzer - 83
SP2: Stephen Strasburg - 81
SP3: Javier Vazquez - 77
SP4: Dennis Martinez - 74
SP5: Gio Gonzalez - 74
RP1: Sean Doolittle - 88
RP2: Drew Storen - 87
RP3: Jeff Fassero - 82
RP4: Mel Rojas - 81
RP5: Tyler Clippard - 79
RP6: Jeff Reardon - 79
RP7: Tim Burke - 79