Page rendered in 0.1530 seconds
43 querie(s) executed
Hall of Merit
— A Look at Baseball's All-Time Best
Monday, April 05, 2004
KJOK Leagues Parks Stats Converter
From KJOK, post #88 on the 1923 ballot thread:
This is a plea for a little help on something that I think many of you will find to be of benefit.
I have finished “prettying up” and documenting a spreadsheet called “KJOK Leagues Parks Stats Converter”. Basically, this is a spreadsheet that takes all of the different steps I use to convert a player’s stats from one environment to another, different environment. As long as you have most of the basic stats for a player, the basic stats for the league they played in, the basic stats or assumed stats for the league your converting to, and have data or can make some basic assumptions about the relative level of competition between the two leagues and the parks in the leagues, the spreadsheet will spit out 3 different “equivalent” batting lines.
For example, if you want to know the NL, NY Mets approx. equivalent for Kaz Matsui’s 2003 batting performance in the Pacific League for the Seibu Lions, this spreadsheet will do that. If you want to know the NL approx. equiv. stats of Bob Caruther’s AA “big” seasons, this spreadsheet will do that. If you want to know what Oscar Charleton might have done in the AL, it will(assuming you’re willing to make enough assumptions about the leagues he played in) do that.
I’m going to post it to the files section of the HOM egroup. What I’m asking is for those of you who are “in” to this type of thing to take this and test it to make sure I didn’t miss any assumptions and that I didn’t make any careless formula typos when manually entering all of this, AND to also offer any suggestions for clearer documentation or improvements in layout or method.
NOTE: Only the batting conversion has been completed. Hope to have a pitching conversion done in the near future…
Thanks in advance.
Great stuff KJOK!
You must be logged in to view your Bookmarks.
(15 - 7:31pm, Jan 28)
(15 - 2:32am, Jan 28)
(17 - 2:20am, Jan 28)
2016 Hall of Merit Ballot Discussion
(65 - 1:50am, Jan 28)
(12 - 1:40am, Jan 28)
(53 - 4:18pm, Jan 27)
Last: The District Attorney
Most Meritorious Player: 1901 Ballot
(9 - 11:17am, Jan 27)
Last: DL from MN
(108 - 10:51pm, Jan 26)
Last: Kiko Sakata
Most Meritorious Player: 1902 Discussion
(11 - 9:41am, Jan 26)
Last: DL from MN
Vic Willis & Sam Leever
(58 - 2:28pm, Jan 25)
Last: Kiko Sakata
(71 - 8:32am, Jan 24)
Trevor Hoffman and Billy Wagner
(77 - 2:22am, Jan 23)
(30 - 5:45pm, Jan 21)
Last: W. G. Braund
Most Meritorious Player: 1901 Discussion
(39 - 3:36pm, Jan 18)
(87 - 11:44am, Jan 17)
Last: Chris Cobb