Baseball for the Thinking Fan

Login | Register | Feedback

btf_logo
You are here > Home > Hall of Merit > Discussion
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.

KJOK

Great stuff KJOK!

Joey Numbaz (Scruff) Posted: April 05, 2004 at 06:09 AM | 2 comment(s) Login to Bookmark
  Related News:

Reader Comments and Retorts

Go to end of page

Statements posted here are those of our readers and do not represent the BaseballThinkFactory. Names are provided by the poster and are not verified. We ask that posters follow our submission policy. Please report any inappropriate comments.

   1. KJOK Posted: April 05, 2004 at 07:08 PM (#523536)
Thanks. Version with some additional descriptive columns uploaded 3:05 Eastern Time 4/5.
   2. KJOK Posted: April 07, 2004 at 07:58 PM (#523537)
OK, I got ambitious and finished the pitching converter for version 3, plus made some more minor changes on the batting conversion and made more improvements to the documentation.

Caveats:

1. The pitching line conversion has much less theoretical underpinning than the batting line - in other words, some of the formulas are SWAGS that make the line "reasonable".

2. I haven't added as many checks for missing data or for abnormal calculations on the pitching side, so for data items like Balks that normally don't have high totals, it's possible a calculation might turn out with "-2" balks or "-1" wild pitches, etc. I'll try to fix those in the future, but for now just assume ZERO balks.

3. Again, the pitching conversion could probably be improved, so any ideas for better calculations are definitely welcome!

THANKS,

You must be Registered and Logged In to post comments.

 

 

<< Back to main

BBTF Partner

Support BBTF

donate

Thanks to
Phil Birnbaum
for his generous support.

Bookmarks

You must be logged in to view your Bookmarks.

Hot Topics

2015 Hall of Merit Ballot Discussion
(105 - 11:14pm, Dec 20)
Last: Dr. Chaleeko

Herman Long
(10 - 7:54pm, Dec 20)
Last: The District Attorney

Most Meritorious Player: 1960 Ballot
(10 - 4:34pm, Dec 19)
Last: DL from MN

2015 Hall of Merit Ballot
(93 - 1:16pm, Dec 19)
Last: DL from MN

Most Meritorious Player: 1901 Discussion
(29 - 4:50pm, Dec 18)
Last: John (You Can Call Me Grandma) Murphy

Ben Taylor
(81 - 11:04am, Dec 15)
Last: DL from MN

New Eligibles Year by Year
(962 - 10:09am, Dec 15)
Last: Chris Fluit

Cristóbal Torriente
(82 - 11:34pm, Dec 14)
Last: Brent

Brian Giles
(59 - 4:08pm, Dec 14)
Last: Joey Numbaz (Scruff)

Most Meritorious Player: 2014 Discussion
(38 - 12:16pm, Dec 13)
Last: lieiam

Larry Doby
(95 - 10:00pm, Dec 12)
Last: Howie Menckel

Pedro Martinez
(159 - 6:44am, Dec 11)
Last: bjhanke

Most Meritorious Player: 1960 Discussion
(25 - 2:12pm, Dec 09)
Last: DL from MN

Most Meritorious Player: 2014 Results
(7 - 9:24pm, Dec 05)
Last: Chris Fluit

Most Meritorious Player: 2014 Ballot
(29 - 4:20pm, Dec 05)
Last: DL from MN

Syndicate

Page rendered in 0.1691 seconds
45 querie(s) executed