Spritze's db for OOTP14 - Page 8

The Game · 12-20-2013, 08:48 AM

Ok somewhere I messed up. I have no players using the zip i got from you yesterday.
Let me know what info you need. On the Select path to database I selected Master.cvs vs H D odb Did I need to delete the ODB?

Spritze · 12-20-2013, 10:32 AM

Markus fixed OOTP14 so random doesn't work with other db's anymore.

The Game · 12-20-2013, 11:41 AM

Quote:

Originally Posted by Spritze

Markus fixed OOTP14 so random doesn't work with other db's anymore.

So I can only use default for RD? Thats dumb.

Spritze · 12-20-2013, 01:59 PM

Perhaps this capability was inadvertantly removed? What I think I notice is that the same random players always show up for the same years. But I could be incorrect in the usual way.

thehef · 12-21-2013, 02:09 PM

For MLB players' actual MLB years (not their pro years or post-high school years) I'm wondering about the differences between the neutralized stats from the OOTP database, Spritze-Gambo one, and the Spritze post-High School one.

For examples:
1) In the OOTP neutered db, Andre Ethier's first three MLB years (06-08) appear to be neutralized, whereas the rest of his years (09-12) appear to be actual. In the Spritze-Gambo and Spritze HS db's, however, Ethier's noot stats appear to be actual except for 2009, which is noot...

2) In the OOTP neutered db, all of Ted Williams' MLB years are neutered to one degree or another. In the Spritze-Gambo db, Williams' first three noot years contain actual stats, while the rest of his years are mostly neutered. The Spritze HS db mostly matches Spritze-Gambo, with a few differences here and there.

3) In the OOTP neutered db, all of Jackie Robinson's MLB years are neutered. Both the Spritze-Gambo and Spritze HS db's match OOTP, except for 1949, where Jackie's stats are neutered, but are not the same as the noot stats in OOTP.

Would Mr's Spritze and/or Gambo - or anyone else with knowledge of it - please comment on the theories behind all of this, and what one could expect for differences between these db's?

Thanks in advance.

Spritze · 12-21-2013, 07:36 PM

1) OOTP database neutered stats has all major league players neutered. The degree depends on the team and league they played in.

2) The Gambo db starts with the Spritze one and removes many players and player years while changing the team played for designation. This has not been updated in quite a while.

3) The Spritze db double neuts players in their non-ML years. Once for team and year and once for age and level. Example a 19 year old player in AAA ball who hits .300 in a pitchers league will have much better ratings than a 34 year old in A ball who hits .300 in a hitters league.

mandersen69 · 12-22-2013, 02:28 PM

Spritze, is there a database that is still compatible with ootp5? I solo with the old game and I'm having a hard time finding a compatible db.

Spritze · 12-22-2013, 07:53 PM

Quote:

Originally Posted by mandersen69

Spritze, is there a database that is still compatible with ootp5? I solo with the old game and I'm having a hard time finding a compatible db.

I do not have one.

jazzrack · 12-24-2013, 02:58 AM

Quote:

Originally Posted by mandersen69

Spritze, is there a database that is still compatible with ootp5? I solo with the old game and I'm having a hard time finding a compatible db.

you may find something in here

http://jazzrack.ohbah.com/ootp/rosters

thehef · 12-24-2013, 05:11 PM

Hey Spritze, I see in the OOTP master file and in the Spritze-Gambo master, the positional experience fields (PExp, CExp, 1bExp, etc.) and Range and Error fields are populated, but in your High School db, these fields are blank. Is this because OOTP either does not use these fields and instead uses the data in the fielding.csv file, or reverts to the fielding.csv if the master fields are blank?

Thanks

Spritze · 12-25-2013, 01:07 AM

Neither. They were not going to be used in OOTP14 and then Markus changed his mind. They don't seem to actually do anything since removing them didn't make a difference I could ascertain. For my db I left them off to simplify computation.

Only Markus knows if they are still necessary.

thehef · 12-25-2013, 05:34 PM

Quote:

Originally Posted by Spritze

Neither. They were not going to be used in OOTP14 and then Markus changed his mind. They don't seem to actually do anything since removing them didn't make a difference I could ascertain. For my db I left them off to simplify computation.

Only Markus knows if they are still necessary.

A puzzling reply, for sure! I am of the impressions that many use your db. I would think we would hear from the gallery of peanuts if your db's exclusion of those data elements made a difference... Hmm...

If it appears that OOTP does not use these fields, and also does not use the data in the fielding.csv file, then how would OOTP know that, for example, Bill Russell would primarily be an outfielder at first and then move to the infield? If using neither, wouldn't all players import as either random position players or as Dave Kingmans?

Spritze · 12-25-2013, 07:41 PM

OOTP seems to use the fielding file. Keep in mind that the other is not per year, it is total career. Base fielding on total career is one of the choices when you set up a new game. Moron likely that is what it is/was used for.

I'd add it to my db if anyone used it but it seems they don't. Leastwise nobody never said nothing about it.

thehef · 12-26-2013, 12:15 AM

Quote:

Originally Posted by Spritze

OOTP seems to use the fielding file. Keep in mind that the other is not per year, it is total career. Base fielding on total career is one of the choices when you set up a new game. Moron likely that is what it is/was used for.

I'd add it to my db if anyone used it but it seems they don't. Leastwise nobody never said nothing about it.

Makes sense. Thanks!

Elysian Fields · 12-29-2013, 11:56 PM

Quote:

Originally Posted by Spritze

Markus fixed OOTP14 so random doesn't work with other db's anymore.

I believe random works with Gambo's db. I couldn't get yours to work, but it worked with his db as far as I could tell.

censurerat · 01-07-2014, 08:06 PM

Created a 1961 season with the DB from ootpmods.com. Now I'm at my first draft and I'm starting to think that I'll miss out on some players.. Mikey Lolich for example isn't in the draft, will he enter a later draft or as a free agent? If not, is there some way i can retain all players who have had their minor debutes in the last couple of years?

The Game · 01-07-2014, 08:30 PM

Quote:

Originally Posted by censurerat

Created a 1961 season with the DB from ootpmods.com. Now I'm at my first draft and I'm starting to think that I'll miss out on some players.. Mikey Lolich for example isn't in the draft, will he enter a later draft or as a free agent? If not, is there some way i can retain all players who have had their minor debutes in the last couple of years?

Lolich's rookie year was 1963 not 1962. He was also signed by Detroit in 1958, so if he doesn't show up after 1962 just manually import him.

censurerat · 01-08-2014, 11:39 AM

Quote:

Originally Posted by The Game

Lolich's rookie year was 1963 not 1962. He was also signed by Detroit in 1958, so if he doesn't show up after 1962 just manually import him.

After some time-consuming work I finally got all the missing players!
I read on the last page that you had the problem with players only having 1 pitch etc, did you figure that out? All of the draftees in my league only got 1 pitch, do you know if they gain more while playing in the minors?

The Game · 01-08-2014, 03:25 PM

Quote:

Originally Posted by censurerat

After some time-consuming work I finally got all the missing players!
I read on the last page that you had the problem with players only having 1 pitch etc, did you figure that out? All of the draftees in my league only got 1 pitch, do you know if they gain more while playing in the minors?

Best I can tell it has something to do with the Gambo/Sprizte DB. Spritze DB which players come in the year they were drafted/18 doesn't seem to have that problem.

Jordan · 01-14-2014, 01:12 PM

Just curious, was poking around spritze's site today, what is the "YoungisBad" file and the file for 15 consist of?

12-20-2013, 08:48 AM	#141
The Game Hall Of Famer Join Date: Feb 2012 Location: Inside The Game Posts: 30,807	Ok somewhere I messed up. I have no players using the zip i got from you yesterday. Let me know what info you need. On the Select path to database I selected Master.cvs vs H D odb Did I need to delete the ODB? Attached Images __________________ Go today don't wait for tomorrow It isn't promised, all the time you get borrowed Don't live your life for other people Don't bottle your emotions till they crack and fill a couple just sorrows Take your mind and refocus go get a paper write your goals out Throw your middle fingers to all your haters "Stay Strong" Last edited by The Game; 12-20-2013 at 08:49 AM.

12-20-2013, 10:32 AM	#142
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	Markus fixed OOTP14 so random doesn't work with other db's anymore. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

12-20-2013, 01:59 PM	#144
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	Perhaps this capability was inadvertantly removed? What I think I notice is that the same random players always show up for the same years. But I could be incorrect in the usual way. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

12-21-2013, 07:36 PM	#146
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	1) OOTP database neutered stats has all major league players neutered. The degree depends on the team and league they played in. 2) The Gambo db starts with the Spritze one and removes many players and player years while changing the team played for designation. This has not been updated in quite a while. 3) The Spritze db double neuts players in their non-ML years. Once for team and year and once for age and level. Example a 19 year old player in AAA ball who hits .300 in a pitchers league will have much better ratings than a 34 year old in A ball who hits .300 in a hitters league. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

12-22-2013, 02:28 PM	#147
mandersen69 Bat Boy Join Date: Dec 2013 Posts: 1	ootp5 Spritze, is there a database that is still compatible with ootp5? I solo with the old game and I'm having a hard time finding a compatible db.

12-21-2013, 02:09 PM	#145
thehef Hall Of Famer Join Date: Jun 2006 Posts: 4,856	For MLB players' actual MLB years (not their pro years or post-high school years) I'm wondering about the differences between the neutralized stats from the OOTP database, Spritze-Gambo one, and the Spritze post-High School one. For examples: 1) In the OOTP neutered db, Andre Ethier's first three MLB years (06-08) appear to be neutralized, whereas the rest of his years (09-12) appear to be actual. In the Spritze-Gambo and Spritze HS db's, however, Ethier's noot stats appear to be actual except for 2009, which is noot... 2) In the OOTP neutered db, all of Ted Williams' MLB years are neutered to one degree or another. In the Spritze-Gambo db, Williams' first three noot years contain actual stats, while the rest of his years are mostly neutered. The Spritze HS db mostly matches Spritze-Gambo, with a few differences here and there. 3) In the OOTP neutered db, all of Jackie Robinson's MLB years are neutered. Both the Spritze-Gambo and Spritze HS db's match OOTP, except for 1949, where Jackie's stats are neutered, but are not the same as the noot stats in OOTP. Would Mr's Spritze and/or Gambo - or anyone else with knowledge of it - please comment on the theories behind all of this, and what one could expect for differences between these db's? Thanks in advance.

12-24-2013, 05:11 PM	#150
thehef Hall Of Famer Join Date: Jun 2006 Posts: 4,856	Hey Spritze, I see in the OOTP master file and in the Spritze-Gambo master, the positional experience fields (PExp, CExp, 1bExp, etc.) and Range and Error fields are populated, but in your High School db, these fields are blank. Is this because OOTP either does not use these fields and instead uses the data in the fielding.csv file, or reverts to the fielding.csv if the master fields are blank? Thanks

12-25-2013, 01:07 AM	#151
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	Neither. They were not going to be used in OOTP14 and then Markus changed his mind. They don't seem to actually do anything since removing them didn't make a difference I could ascertain. For my db I left them off to simplify computation. Only Markus knows if they are still necessary. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

12-25-2013, 07:41 PM	#153
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	OOTP seems to use the fielding file. Keep in mind that the other is not per year, it is total career. Base fielding on total career is one of the choices when you set up a new game. Moron likely that is what it is/was used for. I'd add it to my db if anyone used it but it seems they don't. Leastwise nobody never said nothing about it. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

01-07-2014, 08:06 PM	#156
censurerat Bat Boy Join Date: Jan 2014 Posts: 6	Created a 1961 season with the DB from ootpmods.com. Now I'm at my first draft and I'm starting to think that I'll miss out on some players.. Mikey Lolich for example isn't in the draft, will he enter a later draft or as a free agent? If not, is there some way i can retain all players who have had their minor debutes in the last couple of years?

01-14-2014, 01:12 PM	#160
Jordan All Star Starter Join Date: Jul 2003 Location: Chi Suburbs now... Posts: 1,914	Just curious, was poking around spritze's site today, what is the "YoungisBad" file and the file for 15 consist of?