Spritze's 1945-1974 Database with full minor league stats

OWill40315 · 05-05-2008, 07:30 AM

I was wondering if Spritze has had a chance to update the database described below. I'd love to get a copy of the latest version if available. I've really enjoyed using a earlier version for a historical league beginning in 1946.

Quote:

I plan on releasing a new version of this db that

A) Covers all players who played from 1945 to 1974
B) Fills in gap seasons like the Garlon/Spritze db
C) Adds a few more negro league and Japanese players than the Garlon/Spritze db has.

There will be many fewer gaps to close as Garlon/Spritze only covers major league careers and the other db covers major and minor careers. Almost nobody whose major league career ended in 1945 did not play quite a few more years in the minors.

I have entered all players A-N who played in 1945 so I still have O-Z left. Should take about 4 weeks to finish them. There were 235 players who ended their major league career in 1945. A normal year is about 70. Which is why it will take a while yet.

Spritze · 05-05-2008, 04:54 PM

Finished 1945 this weekend. So this set is complete for 1945 thru 1974.
I also added the standard Lahmans for 1871 through 1944 and 1975 thru 2007.

So if you start your league in 1871 the first of the added/extended players start appearing in the 1880's and from 1945 to 1975 you have the complete set. From 1975 through 2007 some of the extended players are still there.

What I still need to do is to fill-in the gap/missing seasons. I already coded this and just need to run it. I'll do this in the next day or two.

OWill40315 · 05-05-2008, 05:06 PM

Sounds great! Please let me know how i can get a copy when it's ready.

Spritze · 05-05-2008, 05:15 PM

Will do.

I am in Cape Coast, Ghana today celebrating my sons birthday, it is 10 PM here and we will celebrate until dawn. I'll probably get this done tomorrow assuming I wake up at all.

Spritze · 05-11-2008, 10:40 AM

Should be available soon at that site.

OWill40315 · 05-11-2008, 03:52 PM

Quote:

Originally Posted by Spritze

Should be available soon at that site.

Just downloaded it. Thanks!

Charlie Hough · 05-14-2008, 11:00 PM

I'm not quite sure if I understand this. Where are the minor league stats in the modified database? All I see are the major league stats.

Spritze · 05-15-2008, 02:17 PM

Since OOTP cannot process raw minor league stats into useable ratings those stats have been converted to Major League Equivalents. Otherwise you get ratings that make no sense for the age of the player and the minor league level he played at.

So an 18 yr old who hit .400 in class D might have a Batting Average MLE of only .185. This means IF HE HAD PLAYED in the major leagues what would he have likely produced based on his minor league record.

A 26 year old who hit .300 with 25 HR's in class AAA might have a batting average MLE of .285. with 16 HR's. etc

kagnew35 · 05-29-2008, 12:41 AM

Spritz, is this finished?

Spritze · 05-29-2008, 01:55 PM

Yup....well actually this is an ongoing project, currently I am adding 1944 and the players SABR chose as the major minor league stars.

kagnew35 · 05-31-2008, 01:18 AM

Spritze, forgot to ask, is this db neutralized stats?

Spritze · 05-31-2008, 11:40 AM

Minor league/foreign/negro league stats are neutralized to the major league run environment of each particular year. Major league stats are left as real life.

I can use it as the base set and run it through the Garlon/Spritze 750 run neutralizer. I built that so any Lahman compatable set can be neutered.

As it stands now it is un-neutrered at the major league level.

clamel · 06-02-2008, 08:24 AM

What formula are you using for those minor leaguers ???

Any links to a site or do you have numbers to post.

Planning to add some minors in late 90 until today ....

Spritze · 06-02-2008, 12:28 PM

Using hundreds of formulas as there are hundreds of processes needed to create good MLE's, not just one. Some come from the Garlon historical neutralized db. Some from my own self. Some from various tomes I have read. I just picked up the good stuff as needed.

plannine · 06-14-2008, 06:25 PM

Rube Foster (P) never shows up when starting from 1901 in a few test runs and Satchel Paige and Buck O'neill doesnt when starting in the 30's. (a few others that i see in the database also don't seem to show up, but i wasnt watching for them). Buck also doesnt show up when starting in 1945....Victor Starffin shows up, as well as many Japanese players, but the negro leaguers seem to have gone missing.....

Also, having all the players in All Caps can be annoying. I like those who were not major leagues being all caps, but everybody.......i went and mass changed them - hopefully that didnt make a mess of Foster.

Spritze · 06-14-2008, 06:43 PM

The Rubester's rookie year was 1903 so he oughta be there. Was a 187 game winner in my last sim. Played 17 years.

Spritze · 06-14-2008, 07:16 PM

Checked my current league and he went 71-37 before retiring after 8 years. won 24-13 in 1907 and 26-10 in 1908 his best two years, also was 15-10 in 1906 retired in 1911. Basically only played 3 full years in the bigs.

6 No-Hitters as a minor leaguer though.

plannine · 06-14-2008, 09:25 PM

Looks like when i de-captialized all the names something else got changed. Once i went back to the original, everybody showed up.....

Spritze · 06-18-2008, 12:47 PM

Tested and works just fine with OOTP 9.

Do not use this or ANY other MOD db with the neutralized stats options newly available in OOTP 9.

clamel · 06-18-2008, 03:39 PM

Doesn´t mods work with neutralized version of OOTP9 WHY ???

If you start a historical dynasty with Lahmanns DB (and has done some smaller adding of new players) shouldn´t that work ????

What is the basis that OOTP9 build their historical dynasties on.
Have Lahmanns original DB being doctored with by Markus ???

I thought that all historical stats came "clean" and untouched from Lahmann THEN with a math algorith recalculated based on park-adjusted and neutralized mathematics.... a formula used on true stats.

ISN´T THIS SO ?????

05-11-2008, 10:40 AM	#5 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 643	Uploaded to allsimbaseball.com Should be available soon at that site.

05-29-2008, 12:41 AM	#9 (permalink)
kagnew35 All Star Starter Join Date: Dec 2005 Location: Las Vegas, Nev Posts: 1,196	Spritz, is this finished? __________________ Elder Statesman of the Board http://www.soxxcountry.com/ site with Duffys Tavern Live OOTP Chat Room Soxx World of Baseball Commissioner

05-31-2008, 01:18 AM	#11 (permalink)
kagnew35 All Star Starter Join Date: Dec 2005 Location: Las Vegas, Nev Posts: 1,196	Spritze, forgot to ask, is this db neutralized stats? __________________ Elder Statesman of the Board http://www.soxxcountry.com/ site with Duffys Tavern Live OOTP Chat Room Soxx World of Baseball Commissioner

06-14-2008, 06:25 PM	#15 (permalink)
plannine Major Leagues Join Date: Mar 2003 Location: Michigan Posts: 375	Rube Foster (P) never shows up when starting from 1901 in a few test runs and Satchel Paige and Buck O'neill doesnt when starting in the 30's. (a few others that i see in the database also don't seem to show up, but i wasnt watching for them). Buck also doesnt show up when starting in 1945....Victor Starffin shows up, as well as many Japanese players, but the negro leaguers seem to have gone missing..... Also, having all the players in All Caps can be annoying. I like those who were not major leagues being all caps, but everybody.......i went and mass changed them - hopefully that didnt make a mess of Foster. __________________ "Baseball gives every American boy a chance to excel, not just to be as good as someone else but to be better than someone else. This is the nature of man and the name of the game. Ted Williams (1918-2002) Last edited by plannine : 06-14-2008 at 07:05 PM.

06-14-2008, 06:43 PM	#16 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 643	The Ruber The Rubester's rookie year was 1903 so he oughta be there. Was a 187 game winner in my last sim. Played 17 years.

05-05-2008, 04:54 PM	#2 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 643	Finished 1945 this weekend. So this set is complete for 1945 thru 1974. I also added the standard Lahmans for 1871 through 1944 and 1975 thru 2007. So if you start your league in 1871 the first of the added/extended players start appearing in the 1880's and from 1945 to 1975 you have the complete set. From 1975 through 2007 some of the extended players are still there. What I still need to do is to fill-in the gap/missing seasons. I already coded this and just need to run it. I'll do this in the next day or two.

05-05-2008, 05:06 PM	#3 (permalink)
OWill40315 Minors (Rookie Ball) Join Date: Oct 2007 Posts: 26	Sounds great! Please let me know how i can get a copy when it's ready.

05-05-2008, 05:15 PM	#4 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 643	Will do. I am in Cape Coast, Ghana today celebrating my sons birthday, it is 10 PM here and we will celebrate until dawn. I'll probably get this done tomorrow assuming I wake up at all.

05-14-2008, 11:00 PM	#7 (permalink)
Charlie Hough All Star Reserve Join Date: May 2006 Posts: 675	I'm not quite sure if I understand this. Where are the minor league stats in the modified database? All I see are the major league stats.

05-15-2008, 02:17 PM	#8 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 643	Since OOTP cannot process raw minor league stats into useable ratings those stats have been converted to Major League Equivalents. Otherwise you get ratings that make no sense for the age of the player and the minor league level he played at. So an 18 yr old who hit .400 in class D might have a Batting Average MLE of only .185. This means IF HE HAD PLAYED in the major leagues what would he have likely produced based on his minor league record. A 26 year old who hit .300 with 25 HR's in class AAA might have a batting average MLE of .285. with 16 HR's. etc

05-29-2008, 01:55 PM	#10 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 643	Yup....well actually this is an ongoing project, currently I am adding 1944 and the players SABR chose as the major minor league stars.

05-31-2008, 11:40 AM	#12 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 643	Minor league/foreign/negro league stats are neutralized to the major league run environment of each particular year. Major league stats are left as real life. I can use it as the base set and run it through the Garlon/Spritze 750 run neutralizer. I built that so any Lahman compatable set can be neutered. As it stands now it is un-neutrered at the major league level.

06-02-2008, 08:24 AM	#13 (permalink)
clamel Minors (Triple A) Join Date: Apr 2008 Posts: 229	What formula are you using for those minor leaguers ??? Any links to a site or do you have numbers to post. Planning to add some minors in late 90 until today ....

06-02-2008, 12:28 PM	#14 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 643	Using hundreds of formulas as there are hundreds of processes needed to create good MLE's, not just one. Some come from the Garlon historical neutralized db. Some from my own self. Some from various tomes I have read. I just picked up the good stuff as needed.

06-14-2008, 07:16 PM	#17 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 643	Checked my current league and he went 71-37 before retiring after 8 years. won 24-13 in 1907 and 26-10 in 1908 his best two years, also was 15-10 in 1906 retired in 1911. Basically only played 3 full years in the bigs. 6 No-Hitters as a minor leaguer though.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

06-14-2008, 09:25 PM	#18 (permalink)
plannine Major Leagues Join Date: Mar 2003 Location: Michigan Posts: 375	Looks like when i de-captialized all the names something else got changed. Once i went back to the original, everybody showed up..... __________________ "Baseball gives every American boy a chance to excel, not just to be as good as someone else but to be better than someone else. This is the nature of man and the name of the game. Ted Williams (1918-2002) Last edited by plannine : 06-14-2008 at 09:55 PM.

06-18-2008, 12:47 PM	#19 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 643	Ootp 9 Tested and works just fine with OOTP 9. Do not use this or ANY other MOD db with the neutralized stats options newly available in OOTP 9.

06-18-2008, 03:39 PM	#20 (permalink)
clamel Minors (Triple A) Join Date: Apr 2008 Posts: 229	Doesn´t mods work with neutralized version of OOTP9 WHY ??? If you start a historical dynasty with Lahmanns DB (and has done some smaller adding of new players) shouldn´t that work ???? What is the basis that OOTP9 build their historical dynasties on. Have Lahmanns original DB being doctored with by Markus ??? I thought that all historical stats came "clean" and untouched from Lahmann THEN with a math algorith recalculated based on park-adjusted and neutralized mathematics.... a formula used on true stats. ISN´T THIS SO ?????