Spritze's db for OOTP14 - Page 13

Spritze · 09-13-2014, 12:26 PM

Download the database at http://speedy.sh/sFVBR/stats-HS.zip

The Game · 09-13-2014, 02:16 PM

Quote:

Originally Posted by Spritze

Download the database at stats-HS.zip - Speedy Share - upload your files here

any updates to this vs one from say after April 1st?

Spritze · 09-13-2014, 07:20 PM

Quote:

Originally Posted by The Game

any updates to this vs one from say after April 1st?

5 months worth of updates. At a guess I'd say Major/Minor/Pacific/Negro League updates for 1906, 1907, and 1908.

RANGER11JP · 10-09-2014, 08:21 PM

Quote:

Originally Posted by Spritze

5 months worth of updates. At a guess I'd say Major/Minor/Pacific/Negro League updates for 1906, 1907, and 1908.

Somewhere on the boards, that I can not find right now, there was a summary of what was in the Spritze and Garlon db's. It referred to a "College" version. Would this be the same thing? What is the proper loading procedure?

Thanks for your great work!

JP

Spritze · 10-10-2014, 12:17 AM

The Spritze db is the "college" one. I call it the high school db as players become available after high school and can go pro or to college depending on how you play the game.

RANGER11JP · 10-10-2014, 05:24 PM

Okay, that clears that up.

I was ferreting through the db and noticed many players whose initial team designation is IND. Some of these are players, such as Lip Pike, who started his career with Troy, would enter as free agents. Which, if any, DB would allow me to import players to their correct historical teams (after I altered the teams manually) and still allow Negro League players and others to import as FA's?

I hope this is clear.

Thank you.

JP

Spritze · 10-13-2014, 08:35 PM

Mr. Pike played on a number of teams pre-1901 that OOTP has deemed to not exist. Non-existent teams in OOTP are designated IND in the database of the players record. You can still import them as free agents and assign them to any team you wish. OOTP historicals pre-1901 are real players but fictional leagues and teams.

RANGER11JP · 10-14-2014, 05:43 PM

Quote:

Originally Posted by Spritze

Mr. Pike played on a number of teams pre-1901 that OOTP has deemed to not exist. Non-existent teams in OOTP are designated IND in the database of the players record. You can still import them as free agents and assign them to any team you wish. OOTP historicals pre-1901 are real players but fictional leagues and teams.

Getting deeper into this, does Batting2.csv control what team a player goes to when rookies are imported? I have a league presently running using the Spritze-Gambo DB that is "fictional" with the real teams from history created. Mr. Pike, for example, goes directly to my Troy team (TEAM ID: TRO). I would like to use your HS DB to stock my now existent teams with players who started with them and use others who would be FA's as intended, such as Negro Leaguer's or Career Minor Leaguer's.

I hope this makes some sense to you.

Thank you.

JP

Spritze · 10-14-2014, 06:01 PM

Quote:

Originally Posted by RANGER11JP

Getting deeper into this, does Batting2.csv control what team a player goes to when rookies are imported?
JP

I do not know for sure. OOTP gets its data from various files. Master.csv Debut determines the when, which team is probably determined by the combination of neutered = batting2.csv and unneutered=batting.csv but I do not know for sure.

RANGER11JP · 10-15-2014, 04:22 AM

Quote:

Originally Posted by Spritze

I do not know for sure. OOTP gets its data from various files. Master.csv Debut determines the when, which team is probably determined by the combination of neutered = batting2.csv and unneutered=batting.csv but I do not know for sure.

Thanks. I guess that will limit some of my experimenting time. I'l let youse guys know.

JP

FourSixThree · 11-20-2014, 07:02 AM

It's possible that this has already been called to attention but after performing a few different searches within this thread, I can't find an answer. I'm new to using databases but I started a "test" league and it seemed like I was able to import the database without any problems. The players were all there. I simmed a forward a few years and all players correctly appeared in the draft. Then, I noticed something strange. All of the players from the Negro and PCL's are importing with a "fragile" injury rating. Have I done something wrong?

Spritze · 11-21-2014, 03:39 PM

OOTP only uses a players real Major League record to determine fragility so all non-ML'ers begin as fragile. It does not usually have a detrimental effect.

FourSixThree · 11-22-2014, 07:16 AM

Quote:

Originally Posted by Spritze

OOTP only uses a players real Major League record to determine fragility so all non-ML'ers begin as fragile. It does not usually have a detrimental effect.

I should have figured this out on my own. I've simulated about 10 or 12 years and I haven't seen any unusual injuries for any of these guys.

Thanks for getting back to me and thanks for making this database.

censurerat · 01-23-2015, 05:57 PM

Is the DB updated with 14 rosters or do I have to switch over to the regular one when I reach a specific year?

Spritze · 01-24-2015, 11:59 AM

The db will have 2014 whenever Mr. Lahman makes them available.

TDO · 03-02-2015, 07:06 PM

I've searched unsuccessfully and hope spritze or someone can answer.

I'm using the Spritze DB, but all the incoming rookies are basically major league ready at time of the draft.

I am in the 1870s and right now I have reserve rosters instead of minor leagues.

Am I doing something wrong or are the players "ready" because of the time period I'm in and/or because I do not have minor leagues yet?

I'm doing a historical sim.

Spritze · 03-02-2015, 07:51 PM

Quote:

Originally Posted by TDO

are the players "ready" because of the time period I'm in

Debut players are older in general from 1871-1875-ish. By 1880 they have attained a more standard age range. This is simply due to the 1871 cut-off. Keep in mind baseball goes back to 1843.

majesty95 · 03-29-2015, 05:47 AM

I'm kind of confused (it always happens with these databases lol).

On OOTP Mods it says Gambo/Spritze DB for OOTP 14 (Corrected). Is this Gambos DB with full minors and professional debut (not age 18) and correct actual stats so all records and such will be accurate when you import?

For some reason I always get confused by these on there. I wish there was an info tab that could highlight the basic info of the mod so you knew off the bat if it was what you are looking for.

EDIT: Oh, and you should use the "neutralize stats" option when using one of these DBs right?

majesty95 · 03-29-2015, 06:16 AM

One more question, what is the "right" amount of minor leagues to use with the Gambo/Spritze OOTP 14 DB? Do you use the exact same as real life? Is there an easy way to import those?Is there a general rule of thumb, say if you want to create a fictional league but import historical players?

Spritze · 03-29-2015, 05:20 PM

The answers to these questions are contained in the OOTP Wiki.

OOTP Community Wiki | Spritze's db vs Spritze-Gambo

09-13-2014, 12:26 PM	#241
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	New Host Download the database at http://speedy.sh/sFVBR/stats-HS.zip __________________ It's madness, madness, I tell you! For the love of God, don't do it!

10-10-2014, 12:17 AM	#245
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	The Spritze db is the "college" one. I call it the high school db as players become available after high school and can go pro or to college depending on how you play the game. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

10-10-2014, 05:24 PM	#246
RANGER11JP All Star Starter Join Date: Jun 2002 Posts: 1,353	Okay, that clears that up. I was ferreting through the db and noticed many players whose initial team designation is IND. Some of these are players, such as Lip Pike, who started his career with Troy, would enter as free agents. Which, if any, DB would allow me to import players to their correct historical teams (after I altered the teams manually) and still allow Negro League players and others to import as FA's? I hope this is clear. Thank you. JP __________________ BASEBALL, HOCKEY AND BOXING FAN

10-13-2014, 08:35 PM	#247
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	Mr. Pike played on a number of teams pre-1901 that OOTP has deemed to not exist. Non-existent teams in OOTP are designated IND in the database of the players record. You can still import them as free agents and assign them to any team you wish. OOTP historicals pre-1901 are real players but fictional leagues and teams. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

11-21-2014, 03:39 PM	#252
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	OOTP only uses a players real Major League record to determine fragility so all non-ML'ers begin as fragile. It does not usually have a detrimental effect. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

11-20-2014, 07:02 AM	#251
FourSixThree Bat Boy Join Date: Nov 2014 Location: Pennsylvania Posts: 17	It's possible that this has already been called to attention but after performing a few different searches within this thread, I can't find an answer. I'm new to using databases but I started a "test" league and it seemed like I was able to import the database without any problems. The players were all there. I simmed a forward a few years and all players correctly appeared in the draft. Then, I noticed something strange. All of the players from the Negro and PCL's are importing with a "fragile" injury rating. Have I done something wrong?

01-23-2015, 05:57 PM	#254
censurerat Bat Boy Join Date: Jan 2014 Posts: 6	Is the DB updated with 14 rosters or do I have to switch over to the regular one when I reach a specific year?

01-24-2015, 11:59 AM	#255
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	The db will have 2014 whenever Mr. Lahman makes them available. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

03-02-2015, 07:06 PM	#256
TDO Minors (Double A) Join Date: Jun 2011 Posts: 163	I've searched unsuccessfully and hope spritze or someone can answer. I'm using the Spritze DB, but all the incoming rookies are basically major league ready at time of the draft. I am in the 1870s and right now I have reserve rosters instead of minor leagues. Am I doing something wrong or are the players "ready" because of the time period I'm in and/or because I do not have minor leagues yet? I'm doing a historical sim.

03-29-2015, 05:47 AM	#258
majesty95 All Star Starter Join Date: Apr 2005 Location: San Antonio, TX Posts: 1,755	I'm kind of confused (it always happens with these databases lol). On OOTP Mods it says Gambo/Spritze DB for OOTP 14 (Corrected). Is this Gambos DB with full minors and professional debut (not age 18) and correct actual stats so all records and such will be accurate when you import? For some reason I always get confused by these on there. I wish there was an info tab that could highlight the basic info of the mod so you knew off the bat if it was what you are looking for. EDIT: Oh, and you should use the "neutralize stats" option when using one of these DBs right? __________________ College Football Sim League \| '95 Problems Online League Last edited by majesty95; 03-29-2015 at 05:50 AM.

03-29-2015, 06:16 AM	#259
majesty95 All Star Starter Join Date: Apr 2005 Location: San Antonio, TX Posts: 1,755	One more question, what is the "right" amount of minor leagues to use with the Gambo/Spritze OOTP 14 DB? Do you use the exact same as real life? Is there an easy way to import those?Is there a general rule of thumb, say if you want to create a fictional league but import historical players? __________________ College Football Sim League \| '95 Problems Online League

03-29-2015, 05:20 PM	#260
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	The answers to these questions are contained in the OOTP Wiki. OOTP Community Wiki \| Spritze's db vs Spritze-Gambo __________________ It's madness, madness, I tell you! For the love of God, don't do it! Last edited by Spritze; 03-29-2015 at 05:21 PM.