Spritze DB's for OOTP11 - Page 25

Spritze · 10-02-2013, 10:58 PM

All major league as well as many minor league players now have their full career (minors and majors) added to the Spritze "High School" database. 1871-1900 have been updated and finished and put to bed.

Now I'll start on 1901-1940 (1941-1974 are done already)

I may take a detour and add the Seamheads Negro league data as I go.

I'd also like to finish the AAGPBL data.

1901 has been finished and all the pre-1901 Negro players who appeared in white leagues as well.

Spritze · 12-01-2013, 08:19 PM

BTW the db update can be found in the usual place.

Spritze · 12-28-2013, 04:13 PM

1902 Update concluded and 2013 Major League has been added. 1903 has about 200 players that need updating, a normal year has about 85 but many players have been added to the db lately so maybe the new normal is 200.

Spritze · 12-30-2013, 10:46 AM

Another database update has been loaded to the ftp server. This one makes players less than 24 years old stats badder so OOTP will give them worse ratings and they will be less likely to make the show at 19 or 20. But you never know.

thehef · 12-31-2013, 05:55 PM

Quote:

Originally Posted by Spritze

Another database update has been loaded to the ftp server. This one makes players less than 24 years old stats badder so OOTP will give them worse ratings and they will be less likely to make the show at 19 or 20. But you never know.

Does this update apply to all players? Or just certain groups, such as Major Leaguers (as opposed to career minor-leaguers and/or Negro-leaguers)?

Spritze · 12-31-2013, 09:50 PM

All non-major league years for all players in all non-major leagues.

thehef · 01-09-2014, 04:00 PM

Mr Spritze: My understanding - which may be completely wrong - is that for non-major-league seasons there are two types of neutered stats in the Spritze HS database: 1) those based upon real stats, and 2) those that are intelligently made up. Based upon real stats would be those where the real stats for a particular season are reduced so that, for example, a PCL guy who hit .325 with 25 homers would not be rated as a .325/25 guy in the majors. Intelligently made up are those where actual stats for subsequent years are used (to some degree) as the basis for previous (minor-league) seasons in order to come up with realistic minor-league-level stats & ratings.

Is the above true? Or in the ballpark?

If so, then which stats - based on real or intelligently made up - are used for which portions of the following examples?

- Career minor-leaguer
- Player who plays several years in each of PCL (or other minor league) and Majors
- Player who plays a few years in minors and then has a significant major-league career
- Player who plays most of his career in the minors but whose career includes a a short major-league career (perhaps a few full seasons, or perhaps just a cup of coffee)

Would the answers to the above be any different for Negro-league portions of a career instead of minor-league time?

I realize that some of these are in-progress based upon "1871-1902 have been updated" and "1941-1974 are done already," but I'm also not quite clear exactly to whom - and what portion of their careers - this applies.

Hope these questions make sense. Thanks in advance.

Spritze · 01-10-2014, 02:45 PM

Quote:

Originally Posted by thehef

Mr Spritze: My understanding - which may be completely wrong - is that for non-major-league seasons there are two types of neutered stats in the Spritze HS database: 1) those based upon real stats, and 2) those that are intelligently made up. Based upon real stats would be those where the real stats for a particular season are reduced so that, for example, a PCL guy who hit .325 with 25 homers would not be rated as a .325/25 guy in the majors. Intelligently made up are those where actual stats for subsequent years are used (to some degree) as the basis for previous (minor-league) seasons in order to come up with realistic minor-league-level stats & ratings.

Is the above true? Or in the ballpark?

True

Quote:

Originally Posted by thehef

If so, then which stats - based on real or intelligently made up - are used for which portions of the following examples?

- Career minor-leaguer
- Player who plays several years in each of PCL (or other minor league) and Majors
- Player who plays a few years in minors and then has a significant major-league career
- Player who plays most of his career in the minors but whose career includes a a short major-league career (perhaps a few full seasons, or perhaps just a cup of coffee) .

Real stats are always used where available. Available = 1871-1902 and 1940-1974. I have about 16,000 players yet to update with their real stats.

Quote:

Originally Posted by thehef

Would the answers to the above be any different for Negro-league portions of a career instead of minor-league time?
.

No

Quote:

Originally Posted by thehef

I realize that some of these are in-progress based upon "1871-1902 have been updated" and "1941-1974 are done already," but I'm also not quite clear exactly to whom - and what portion of their careers - this applies.

Hope these questions make sense. Thanks in advance .

This applies to all players in the db. If they are 'done" it means their Major,Minor,Japanese,Korean,Negro League, Cuban League, Mexican League etc Real stats have been located and entered and used to create player ratings. Obviously the more stats the greater the ratings accuracy.

thehef · 01-10-2014, 03:33 PM

Quote:

Originally Posted by Spritze

Real stats are always used where available. Available = 1871-1902 and 1940-1974. I have about 16,000 players yet to update with their real stats.

Thanks for providing the background on this... So in the example of a PCL player whose career spanned somewhere in those gap years - between 1902 & 1940 - his stats would be based upon what? I spot-checked a few and it looks like the batting.csv stats are either exact or pretty close to the real stats. So I'm guessing that based upon real stats is in play for generating the neutered (batting2.csv) stats for some of these gap (betw 1902-1940) guys. Correct?

Spritze · 01-11-2014, 12:05 AM

Yes. But the gappers will have many missing years until they get finished. So their career ratings will be based only on PCL and major league stats to start. When done their ratings will be based on their career at every level.

Spritze · 01-11-2014, 05:10 AM

The before attachment shows his career Lahman only record which OOTP uses to create ratings. The after attachment shows his career after all the real minor league missing years have been added.

dcundy · 01-11-2014, 09:24 AM

based on your last image. do you use a table to edit players

Spritze · 01-11-2014, 10:58 AM

Microsoft Access Tables, Queries, Forms and Macros. The complete database uses four 1.25 gb databases plus one of photos.

Spritze · 02-02-2014, 04:30 AM

1871-1903 finished and 2013 rookies added. DB in the usual place.

Carlton · 02-11-2014, 10:29 AM

Damn, I shouldn't use this then even though I am starting in 1901

Or could I?

Do you know offhand if the imports for 1902 are relatively the same?

BTW

You had 2 Phil Nadeuas(sp?) one was Phillip
You had Walter Clarkson in 10 years too early
and some PCL guy with the first name Abraham is actually named Lincoln as his full name was Abraham Lincoln something
and players born in Lansingburgh NY were actually born in Troy, NY as that town was annexed

Just some trivial things...I apologize, I wanted to take notes to send to you for these easy fixes but I am trying to test some things before I template a 1901 all in one for version 15

Two questions
Is the DOB still a year off if you don't use a draft?
Why are nicknames not imported?

Are these both OOTP issues?

Spritze · 02-11-2014, 10:57 PM

Quote:

Originally Posted by Carlton

Two questions
Is the DOB still a year off if you don't use a draft?

Players are born on whatever date their mama says. The rest is OOTP.

Quote:

Originally Posted by Carlton

Why are nicknames not imported?

They used to be until Markus got complaints from some players who did not like them. So he made them go poof. Pisses me off but there it is.

Quote:

Originally Posted by Carlton

Are these both OOTP issues?

Yes they are.

Carlton · 02-12-2014, 09:00 AM

Thanks Spritze

I am anal and look up every player that comes in anyway on wikipedia and bbref and make changes to those sites if something is amiss (usually bad links) was just wondering if it was an OOTP issue or if I could use a workaround

Carlton · 05-05-2014, 10:15 AM

When you say DB is in the usual place, you mean OOTPMods? Says it hasn't been updated since 2011

Did you upload it somewhere else?

Spritze · 06-02-2014, 10:09 PM

Quote:

Originally Posted by Carlton

When you say DB is in the usual place, you mean OOTPMods? Says it hasn't been updated since 2011

Did you upload it somewhere else?

Yes, PM me.

Spritze · 06-02-2014, 10:12 PM

New decapitated db available - Major League and PCL through 1905, Negro and Cuban League through 1901.

Decapitation fixes some OOTP14 and 15 challenges.

10-02-2013, 10:58 PM	#481
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Final Update of 19th Century baseball posted All major league as well as many minor league players now have their full career (minors and majors) added to the Spritze "High School" database. 1871-1900 have been updated and finished and put to bed. Now I'll start on 1901-1940 (1941-1974 are done already) I may take a detour and add the Seamheads Negro league data as I go. I'd also like to finish the AAGPBL data. 1901 has been finished and all the pre-1901 Negro players who appeared in white leagues as well. __________________ It's madness, madness, I tell you! For the love of God, don't do it! Last edited by Spritze; 12-01-2013 at 03:27 PM.

12-01-2013, 08:19 PM	#482
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	BTW the db update can be found in the usual place. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

12-28-2013, 04:13 PM	#483
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	1902 Update concluded and 2013 Major League has been added. 1903 has about 200 players that need updating, a normal year has about 85 but many players have been added to the db lately so maybe the new normal is 200. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

12-30-2013, 10:46 AM	#484
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Another database update has been loaded to the ftp server. This one makes players less than 24 years old stats badder so OOTP will give them worse ratings and they will be less likely to make the show at 19 or 20. But you never know. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

12-31-2013, 09:50 PM	#486
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	All non-major league years for all players in all non-major leagues. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

01-09-2014, 04:00 PM	#487
thehef Hall Of Famer Join Date: Jun 2006 Posts: 5,345	Mr Spritze: My understanding - which may be completely wrong - is that for non-major-league seasons there are two types of neutered stats in the Spritze HS database: 1) those based upon real stats, and 2) those that are intelligently made up. Based upon real stats would be those where the real stats for a particular season are reduced so that, for example, a PCL guy who hit .325 with 25 homers would not be rated as a .325/25 guy in the majors. Intelligently made up are those where actual stats for subsequent years are used (to some degree) as the basis for previous (minor-league) seasons in order to come up with realistic minor-league-level stats & ratings. Is the above true? Or in the ballpark? If so, then which stats - based on real or intelligently made up - are used for which portions of the following examples? - Career minor-leaguer - Player who plays several years in each of PCL (or other minor league) and Majors - Player who plays a few years in minors and then has a significant major-league career - Player who plays most of his career in the minors but whose career includes a a short major-league career (perhaps a few full seasons, or perhaps just a cup of coffee) Would the answers to the above be any different for Negro-league portions of a career instead of minor-league time? I realize that some of these are in-progress based upon "1871-1902 have been updated" and "1941-1974 are done already," but I'm also not quite clear exactly to whom - and what portion of their careers - this applies. Hope these questions make sense. Thanks in advance.

01-11-2014, 12:05 AM	#490
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Yes. But the gappers will have many missing years until they get finished. So their career ratings will be based only on PCL and major league stats to start. When done their ratings will be based on their career at every level. __________________ It's madness, madness, I tell you! For the love of God, don't do it! Last edited by Spritze; 01-11-2014 at 12:07 AM.

01-11-2014, 05:10 AM	#491
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Here is a sample of the player I just finished The before attachment shows his career Lahman only record which OOTP uses to create ratings. The after attachment shows his career after all the real minor league missing years have been added. Attached Images __________________ It's madness, madness, I tell you! For the love of God, don't do it!

01-11-2014, 09:24 AM	#492
dcundy Minors (Single A) Join Date: Nov 2002 Posts: 71	what kind of table is this based on your last image. do you use a table to edit players

01-11-2014, 10:58 AM	#493
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Microsoft Access Tables, Queries, Forms and Macros. The complete database uses four 1.25 gb databases plus one of photos. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

02-02-2014, 04:30 AM	#494
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	1871-1903 finished and 2013 rookies added. DB in the usual place. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

02-11-2014, 10:29 AM	#495
Carlton Hall Of Famer Join Date: Mar 2002 Posts: 3,765	Damn, I shouldn't use this then even though I am starting in 1901 Or could I? Do you know offhand if the imports for 1902 are relatively the same? BTW You had 2 Phil Nadeuas(sp?) one was Phillip You had Walter Clarkson in 10 years too early and some PCL guy with the first name Abraham is actually named Lincoln as his full name was Abraham Lincoln something and players born in Lansingburgh NY were actually born in Troy, NY as that town was annexed Just some trivial things...I apologize, I wanted to take notes to send to you for these easy fixes but I am trying to test some things before I template a 1901 all in one for version 15 Two questions Is the DOB still a year off if you don't use a draft? Why are nicknames not imported? Are these both OOTP issues? __________________ "I am at that stage of my life where I keep myself out of arguments. I am 100% self sufficient spiritually, emotionally & financially. Even if you say 1+1=5, you are ABSOLUTELY CORRECT. Enjoy!"

02-12-2014, 09:00 AM	#497
Carlton Hall Of Famer Join Date: Mar 2002 Posts: 3,765	Thanks Spritze I am anal and look up every player that comes in anyway on wikipedia and bbref and make changes to those sites if something is amiss (usually bad links) was just wondering if it was an OOTP issue or if I could use a workaround __________________ "I am at that stage of my life where I keep myself out of arguments. I am 100% self sufficient spiritually, emotionally & financially. Even if you say 1+1=5, you are ABSOLUTELY CORRECT. Enjoy!"

05-05-2014, 10:15 AM	#498
Carlton Hall Of Famer Join Date: Mar 2002 Posts: 3,765	When you say DB is in the usual place, you mean OOTPMods? Says it hasn't been updated since 2011 Did you upload it somewhere else? __________________ "I am at that stage of my life where I keep myself out of arguments. I am 100% self sufficient spiritually, emotionally & financially. Even if you say 1+1=5, you are ABSOLUTELY CORRECT. Enjoy!"

06-02-2014, 10:12 PM	#500
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	New decapitated db available - Major League and PCL through 1905, Negro and Cuban League through 1901. Decapitation fixes some OOTP14 and 15 challenges. __________________ It's madness, madness, I tell you! For the love of God, don't do it!