Spritze/Garlon DB - Page 7

Spritze · 02-20-2008, 01:26 PM

1. Pop Lloyd is pre 1920 - I am still working on those a bit
2. Played to age 48 which drags his average average down. A 48 year old Pop Lloyd wouldn't have hit much in the majors most likely. I am trying to determine a major league career cut off date for these guys. I think I'll base it on when their OPS plummets rather than just a standard age as some of them were pretty good for a pretty long time.
3. Age 25 to 32 he hits close to .300 or over in my test sim. Finishes with a .273 overall average because he retires at 32 (started at 21) and so his averages didn't get dragged down by playing old.

All that being said I think pre-1920's negro players need a boost to their ratings in general and I think I'll address that today.

Spritze · 02-20-2008, 02:08 PM

A major league Pop Lloyd hits around .215 ages 21-23, .320's and 330's until age 32, .250's ages 33 to 44, and .350 45 to 48. This follows the same curve path his real career took.

I'd probably cut him off at age 35 or so as his skills declined rapidly around then which would increase his overall average to around .300. Otherwise I could leave him in and he could play in the minors until age 48 which in reality he sorta did. Personally I think it would be cool to have him in my minors for next to forever but I'm taking votes. Also his low averages from ages 21 to 23 put him my minors but with good potential ratings. He hit .340 in AA and .284 and then .278 in AAA those years before hitting .296 his first year in the bigs.

Keep in mind these stat lines are approximations of what the player would do in the major leagues at that age, he might tear up the minors at that age even though his ML equivalents would be such that he just isn't good enough to play there just yet.

This db is major league 750 run environment equivilancies only. Everyone is equivalent.

Hate to say this but I had forgotten to include a query in the final db run. This is why the negro league batters came out so low. I had fixed this months ago but just forgot to include it in the final. I still think pre-1920's need more work as my test db did have this update included and I still thought they seemed a tiny bit low.

plannine · 02-20-2008, 03:37 PM

Too many players retire 'no matter what' after a certain point in the game. Ive had Cy Young call it quits after a OOTP 25-3 season (1903). Thats a whole lotta wins short. They only way I can get him to 1911 is freeze his age for a while. So I don't think Pops would make it even with the additional stats.

I know I wanted to try and create a database of only players who had 10 years (or more) of ML experience, then take a number of years (out of the middle of their history) to create the players career. Maybe NL players would be even years and AL players would be odd years.

This game is just too much fun.......and one of these day's I will make it past 1920.

Spritze · 02-20-2008, 05:41 PM

After beer review grr I meanr peer review it will be downloadable.
Contains these additions
1. Changed FieldingOF to allow better usage of outfielders.

2. Changed debut age to 22 where it is not known due to lack of birth year.

3. Added debuts and final game info for players from 1800's as much of that was missing.

4. Set league abbrev for Union Association 1884, Players League 1890, Federal League 1914-1915 to NL

5. Fixed the missing formula concerning negro and japanese players that some fool (me!) left out of build 0.

6. Changed Games Played for pitchers where the formulas created too many games played to get to 200 AB minimum. (resulting in a goofy games played leaderboard)

I also included the back dated Luke Easter (age 22) and Connie Marrero (age 27).

For Ver 2.2 I plan on adding other back dated players like Jackie Robinson and the Asian players like Ichiro. Plus adjusting any more things that need adjusting.

plannine · 02-20-2008, 07:01 PM

"Changes Maid to some batting formulas" Is that anything like Minute Maid or Meter Maid?
Just wondering.

Looking forward to getting the next version (2.1) and starting the "New History of Baseball v22". By v50 I might make it past the 1920 season.

Spritze · 02-20-2008, 07:55 PM

When a maid changes I pay strict attention.

plannine · 02-20-2008, 07:59 PM

Quote:

Originally Posted by Spritze

When a maid changes I pay strict attention.

As one should!!!!

swampdragon · 02-21-2008, 10:07 PM

I am sure the database will be beer reviewed over the next few days.

plannine · 02-22-2008, 07:33 AM

Quote:

Originally Posted by Spritze

After beer review grr I meanr peer review it will be downloadable.

Sometimes beer review is best.
(is 2.1 up yet?)

f.montoya · 02-24-2008, 08:39 PM

I found it. Seems that Spritze uploaded it under OOTP 2006. I moved it and you should see version 2.1 now.

plannine · 03-07-2008, 06:36 PM

First comments on 2.x version.

Negro leaguers are melding in a bit better, Rube (Foster) now overpowers for a few years, then levels out. Actually too many "K's" for the time period, but it's a-lot better then his quick exits with little playing time in previous versions. Overall, the Negro Leaguers 1901-1920 will be leaders but will not dominate year after year (except for Foster for a few years). Babe Ruth (the hitter) is not guaranteed the HR crown every year, but will still leave his mark.

dcundy · 03-12-2008, 04:36 AM

Where can I find the latest version of the db?
Also does anyone know what file I modify to make sure I have the correct teams in the correct leagues for historical accuracy if I am trying to create a modified condensed league.??

Spritze · 03-12-2008, 12:36 PM

teams.csv is where you would modify your league structure.

find it at allsimbaseball.com

plannine · 03-16-2008, 06:26 PM

Leroy "Satch" Paige imports as a First Baseman in the latest verison. Game never sees him as a pitcher.

Spritze · 03-17-2008, 04:34 PM

I'll fix it then.

There are two Paiges in the db

Satchell is whole career and LeRoy is MLB only.

Qrusher14242 · 03-23-2008, 04:33 PM

i cant get this db to work, does it work with ootp8? it just says 'loading of database failed' no matter what year i try

Spritze · 03-24-2008, 04:24 PM

Just make sure you add it to an already existing Lahman set of files. It only contains 5 altered csv files, the rest of the ones you need are the normal Lahman ones.

Garlon · 03-24-2008, 04:37 PM

Spritze - We should probably upload a version that contains all of the files as this seems to be a common issue.

Spritze · 03-25-2008, 02:57 PM

I think we might need Mr. Lahmans permission to alter his work and post it on a web site. It would be the polite thing to do.

Qrusher14242 · 03-25-2008, 06:03 PM

oh yeah, forgot i had to add it to the lahman dir, havent played ootp in a while. Just forgot i guess lol thanks.

02-20-2008, 02:08 PM	#122 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 754	Changes Maid to some batting formulas A major league Pop Lloyd hits around .215 ages 21-23, .320's and 330's until age 32, .250's ages 33 to 44, and .350 45 to 48. This follows the same curve path his real career took. I'd probably cut him off at age 35 or so as his skills declined rapidly around then which would increase his overall average to around .300. Otherwise I could leave him in and he could play in the minors until age 48 which in reality he sorta did. Personally I think it would be cool to have him in my minors for next to forever but I'm taking votes. Also his low averages from ages 21 to 23 put him my minors but with good potential ratings. He hit .340 in AA and .284 and then .278 in AAA those years before hitting .296 his first year in the bigs. Keep in mind these stat lines are approximations of what the player would do in the major leagues at that age, he might tear up the minors at that age even though his ML equivalents would be such that he just isn't good enough to play there just yet. This db is major league 750 run environment equivilancies only. Everyone is equivalent. Hate to say this but I had forgotten to include a query in the final db run. This is why the negro league batters came out so low. I had fixed this months ago but just forgot to include it in the final. I still think pre-1920's need more work as my test db did have this update included and I still thought they seemed a tiny bit low.

02-20-2008, 03:37 PM	#123 (permalink)
plannine Major Leagues Join Date: Mar 2003 Location: Michigan Posts: 388	Too many players retire 'no matter what' after a certain point in the game. Ive had Cy Young call it quits after a OOTP 25-3 season (1903). Thats a whole lotta wins short. They only way I can get him to 1911 is freeze his age for a while. So I don't think Pops would make it even with the additional stats. I know I wanted to try and create a database of only players who had 10 years (or more) of ML experience, then take a number of years (out of the middle of their history) to create the players career. Maybe NL players would be even years and AL players would be odd years. This game is just too much fun.......and one of these day's I will make it past 1920. __________________ "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 : 02-20-2008 at 03:39 PM.

02-20-2008, 05:41 PM	#124 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 754	Ver 2.1 is at all sim baseball After beer review grr I meanr peer review it will be downloadable. Contains these additions 1. Changed FieldingOF to allow better usage of outfielders. 2. Changed debut age to 22 where it is not known due to lack of birth year. 3. Added debuts and final game info for players from 1800's as much of that was missing. 4. Set league abbrev for Union Association 1884, Players League 1890, Federal League 1914-1915 to NL 5. Fixed the missing formula concerning negro and japanese players that some fool (me!) left out of build 0. 6. Changed Games Played for pitchers where the formulas created too many games played to get to 200 AB minimum. (resulting in a goofy games played leaderboard) I also included the back dated Luke Easter (age 22) and Connie Marrero (age 27). For Ver 2.2 I plan on adding other back dated players like Jackie Robinson and the Asian players like Ichiro. Plus adjusting any more things that need adjusting.

02-20-2008, 07:01 PM	#125 (permalink)
plannine Major Leagues Join Date: Mar 2003 Location: Michigan Posts: 388	"Changes Maid to some batting formulas" Is that anything like Minute Maid or Meter Maid? Just wondering. Looking forward to getting the next version (2.1) and starting the "New History of Baseball v22". By v50 I might make it past the 1920 season. __________________ "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)

02-21-2008, 10:07 PM	#128 (permalink)
swampdragon All Star Starter Join Date: May 2002 Location: The Lonely Mountain Posts: 1,728	I am sure the database will be beer reviewed over the next few days. __________________ "The only way to oblige men to speak well of us is to act well." -- Voltaire

02-20-2008, 01:26 PM	#121 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 754	1. Pop Lloyd is pre 1920 - I am still working on those a bit 2. Played to age 48 which drags his average average down. A 48 year old Pop Lloyd wouldn't have hit much in the majors most likely. I am trying to determine a major league career cut off date for these guys. I think I'll base it on when their OPS plummets rather than just a standard age as some of them were pretty good for a pretty long time. 3. Age 25 to 32 he hits close to .300 or over in my test sim. Finishes with a .273 overall average because he retires at 32 (started at 21) and so his averages didn't get dragged down by playing old. All that being said I think pre-1920's negro players need a boost to their ratings in general and I think I'll address that today.

02-20-2008, 07:55 PM	#126 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 754	When a maid changes I pay strict attention.

02-24-2008, 08:39 PM	#130 (permalink)
f.montoya Hall Of Famer Join Date: Nov 2004 Posts: 4,469	I found it. Seems that Spritze uploaded it under OOTP 2006. I moved it and you should see version 2.1 now. __________________ Fidel Montoya Asahi2 Baseball Commissioner(Historical League Since 2004) www.allsimbaseball.com (Hosting for OOTP with LIVE Online Tutorials) Share Your Mods - Free, unlimited and easy to upload to share your Mods instantly(free site registration required) Last edited by f.montoya : 02-24-2008 at 08:40 PM.

03-07-2008, 06:36 PM	#131 (permalink)
plannine Major Leagues Join Date: Mar 2003 Location: Michigan Posts: 388	First comments on 2.x version. Negro leaguers are melding in a bit better, Rube (Foster) now overpowers for a few years, then levels out. Actually too many "K's" for the time period, but it's a-lot better then his quick exits with little playing time in previous versions. Overall, the Negro Leaguers 1901-1920 will be leaders but will not dominate year after year (except for Foster for a few years). Babe Ruth (the hitter) is not guaranteed the HR crown every year, but will still leave his mark. __________________ "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)

03-12-2008, 04:36 AM	#132 (permalink)
dcundy Minors (Rookie Ball) Join Date: Nov 2002 Posts: 43	latest verison of db Where can I find the latest version of the db? Also does anyone know what file I modify to make sure I have the correct teams in the correct leagues for historical accuracy if I am trying to create a modified condensed league.??

03-12-2008, 12:36 PM	#133 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 754	teams.csv is where you would modify your league structure. find it at allsimbaseball.com

03-16-2008, 06:26 PM	#134 (permalink)
plannine Major Leagues Join Date: Mar 2003 Location: Michigan Posts: 388	Leroy "Satch" Paige imports as a First Baseman in the latest verison. Game never sees him as a pitcher. __________________ "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)

03-17-2008, 04:34 PM	#135 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 754	I'll fix it then. There are two Paiges in the db Satchell is whole career and LeRoy is MLB only.

03-23-2008, 04:33 PM	#136 (permalink)
Qrusher14242 All Star Reserve Join Date: Feb 2002 Location: CA Posts: 980	i cant get this db to work, does it work with ootp8? it just says 'loading of database failed' no matter what year i try __________________ "Go then, there are other worlds than these"

03-24-2008, 04:24 PM	#137 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 754	Just make sure you add it to an already existing Lahman set of files. It only contains 5 altered csv files, the rest of the ones you need are the normal Lahman ones.

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

03-24-2008, 04:37 PM	#138 (permalink)
Garlon All Star Starter Join Date: Jun 2004 Posts: 1,111	Spritze - We should probably upload a version that contains all of the files as this seems to be a common issue. __________________ Arod23Garlon2006DB available HERE 1871 Quickstart file available HERE

03-25-2008, 02:57 PM	#139 (permalink)
Spritze All Star Reserve Join Date: Dec 2001 Location: Redmond Posts: 754	Mr. Garlon I think we might need Mr. Lahmans permission to alter his work and post it on a web site. It would be the polite thing to do.

03-25-2008, 06:03 PM	#140 (permalink)
Qrusher14242 All Star Reserve Join Date: Feb 2002 Location: CA Posts: 980	oh yeah, forgot i had to add it to the lahman dir, havent played ootp in a while. Just forgot i guess lol thanks. __________________ "Go then, there are other worlds than these"