Spritze DB's for OOTP11

[DXMachina]

PM me and I'll give you a link to the corrected commaless db on my work ftp site

Thanks, will do.

[Rastafreaky]

Originally Posted by Gambo

I will have two versions of the database. The 1st will be my standard with players debuting when they made their professional debut in the correct organizations, correct organizations upon import, career minor leaguers and the top ~50 historical japanese players. Dice-K, Ichiro etc will import when they made their foreign debut.

The second version is a tweaked database that works with real transactions turned on, this includes all major leaguers and a good portion of the minor leaguers (the minor leaguers had to be in a MLB organization at some point). Players will import either when they joined their 1st MLB organizations (minors or majors). For players who were drafted or signed during the season, they will import as Free Agents at the beginning of the year and the transaction database will add them to their teams as the season progresses. For example David Clyde will import in 1973 as a Free Agent and in June go to the Rangers. This will also implement the work around for players importing to the correct teams or as a Free Agent as of opening day for the import year. (The real stats will look weird as an additional team is added in some cases). So players who were signed in May will import as Free Agents on opening day.

Both these databases need to use the neutralized stats option and the 2nd version will also function fine without real transactions used. The 2nd version is closest to the "No asians" version Spritze creates.

I will be sending the 1st version to Padres site shortly and hope to finish the 2nd version sometime today also.

*The Gambo/Spritze database uses the same data as the Spritze DB.

Been using your DB in a sim starting in 1921. It's now 1934 and 60 of the top 100 prospects are pitchers. Literally, 1-60. Is that unusual?

[Rainers]

Spritze,

Will you make two High School databases that split up the Japanese and Korean players again this year. When you do the updates on your DB it is like a yearly holiday for me. I have had a single player universe going on for three version of OOTP. Last year I added a Korean League with you obliging me with a split Asian db's. Awesome work, partner.

Rainers

[Scott Vibert]

Originally Posted by Spritze

Thanks, FYI search for quote marks/commas and you'll find all the name errors. There should be no quotes in the base master.csv that comes from the new OOTP guy who changed the names and other base info but he has included a few which is the root cause of your (and our) troubles.

So the solution is to delete all the quotes, or only the quotes next to commas? I see a number of quotes around the college fields. Just want to make sure I'm doing this right.

(Downloaded the 7/10 dated High School file from Padresfan)

[Spritze]

Originally Posted by Rainers

Spritze,

Will you make two High School databases that split up the Japanese and Korean players again this year. When you do the updates on your DB it is like a yearly holiday for me. I have had a single player universe going on for three version of OOTP. Last year I added a Korean League with you obliging me with a split Asian db's. Awesome work, partner.

Rainers

Sure I'll make a Japanese and A Korean to go with the others.

Done - PM me and I'll give you the ftp address.

[Spritze]

Originally Posted by Scott Vibert

So the solution is to delete all the quotes, or only the quotes next to commas? I see a number of quotes around the college fields. Just want to make sure I'm doing this right.

(Downloaded the 7/10 dated High School file from Padresfan)

It is the commas that cause the challenges. The latest version at the Padres site is commaless.

[Scott Vibert]

Great. Thanks

[Spritze]

Originally Posted by Rastafreaky

Been using your DB in a sim starting in 1921. It's now 1934 and 60 of the top 100 prospects are pitchers. Literally, 1-60. Is that unusual?

Prospectulation rankings are determined by the game, not the database.

If you use the predefined rankings checkbox during an amateur draft THAT ranking comes from the db but after you move to the next day those rankings change and become game created rankings.

[Iamnobody]

Ok, I got a dumb question. I want to start in 1901, but I want to have negro players in the MLB as normal. If I use this database will they be drafted as normal?

Also, will this db affect other games we already have started?

[bronco6710]

Alright, I've downloaded the Gambo/Spritze DB and the Spritze/NoAsians DB - both for 12 - and I'm having serious problems with both. I'm using neutralized stats, OOTP development engine on, and drafting each year because I prefer that to assigning players to their actual teams.

There's the comma issue with player names that's been brought up already, hopefully an updated version is up soon because the one on Padresfan seems to still be corrupted - at least the No Asians, I haven't redownloaded Gambo/Spritze

Gambo/Spritze: When I started the league, I got all the mid-career Negro Leaguers and minor/independent leaguers in the FA pool. This is great. However, when I imported the next draft class (1935), there were no Negro Leaguers and I could only find one non-MLB player (PCL-er Brooks Holder).

SpritzeNoAsians: Similar upon starting the league, except the FA pool was different and much smaller (and it assigned Satchel Paige to the Phillies for some reason), and included a stray Japanese player. The draft class did seem to include some Negro League players, but at 138 players, it seemed way too small for a DB that is is so inclusive.

Basically, in both cases, I'm not sure if the game is importing the players from the database properly, because it doesn't feel right, and I'm wondering if I'm doing something wrong settings-wise, or if the kinks with OOTP12 compatibility just haven't been ironed out yet.

[bronco6710]

UPDATE: Using Gambo/Spritze, the 1936 draft class features Brooks Holder again, and about 100 Japanese first-basemen who have no defensive ratings whatsoever. Honestly, this seems pretty broken.

[D. Boon's Ghost]

One thing I noticed - and this could very well be intentional, but just about every negro league player in the 20s has a Fragile health rating. Some I can understand, but someone like Satchel Paige would seemingly be Durable (considering he only had one major injury in his career - and the guy pitched until he was 120).

Regardless, I very much appreciate all the hard work that went into the Gambo-Spritze DB. You guys have provided the means of recapturing the love of baseball I had as a kid. Bravo squared!

[Spritze]

Originally Posted by bronco6710

SpritzeNoAsians: Similar upon starting the league, except the FA pool was different and much smaller (and it assigned Satchel Paige to the Phillies for some reason), and included a stray Japanese player. The draft class did seem to include some Negro League players, but at 138 players, it seemed way too small for a DB that is is so inclusive.

Paige is assigned to the Phillies due to his many years with their AAA team the Miami Marlins. The stray Asian is most likely one of the Hawaiians. I'll test the pool. (No Asians Pool tested just peachy.)

ALL NEW PLAYERS start Fragile in OOTP, that is just the way it is programmed.

138 is the correct number of players for 1935 as the dbs currently only contain extra season stats for 1871-1883, 1940-1972. Currently working on 1884-1900.

I have not tested the Gambo DB so I don't know anything about why you're getting challenges there.

[minid]

Spritz,

First off, thanks a ton for the time you put into this. I'm using your No Asians High School DB for the first time and I am really enjoying it.

I started the league at 1871 and just finished the 1894 season. So far, I have no significant issues.

One thing that I am confused about though is the lack of difference between the minor league stats of guys like Fred Betts, Philip Nadeau and Charles Baum (to name a handful) and their neutralized stats in the game. I had figured they would be adjusted further downward. It seems that their batting averages get a hit, but with very little differnce in power. So my single season home run leader right now is Len Sowders with 35 in 1888, while the other minor league stars usually dominate as well. Fred Betts led the league in HR twice and just put up a .375 20HR line in the admittedly crazy 1894 season.

I have Use Neutralized Stats turned on, and 1 Year Recalc (I've always preferred the craziness of one year recalc, since it mimics the craziness of real life baseball better, IMO).

For the "normal" major league players, is there any neutralization of their stats at all? Just out of curiosity I pulled up the Batting2.csv file and cross checked Hank Aaron. His Batting2.csv numbers are exactly the same as his real numbers on BBREF.

These aren't big issues at all, and I am having an absolute blast with the league. Even with these minor issues the historical accuracy is pretty darn good. So thnaks again and keep up the great work!

[Spritze]

The minor league stats are adjusted to that years major league equivalences, you should notice that as a player moves away from age 27/28 either older or younger his equivalences change as they also do as the league level moves away from the majors. there is an Age/Level matrix that is used for adjustment as well as raw league totals.

What this means generically is that major league players get no adjustment at all as they are already there , a 27 year old AAA minor league player will get a little adjustment and a 27 year old D league player will get a lot of adjustment. Then of course there is the good hitter in a pitchers league adjustments and good pitcher in a hitters league adjustments and all the rest. There are something like 120 total possible adjustments made to each player the amount depending on the things it depends on. Which are a lot of things yes indeedy.

The other challenge is that I've only completely done 1871-1884, 1940-1974. so those years will be most accurate, others less so.

[TribeWarpath]

Originally Posted by DXMachina

First, thanks to both of you for all the work on these databases. They're really great. However, I did come a piece of corrupt data. I was setting up a historical league starting in 1961 using the new Gambo-Spritze DB (without transactions), and the game was telling me that one of the players was named Allegheny County" Bob (with the quote mark included. I took a look at the master.csv file, and the player should be Bob Purkey. Somehow the phrase 'Allegheny County"' wound up in the first name field, and 'Bob' is in the last name field. I don't know if any of the other data for Purkey is off. A lot of the numbers don't seem to match the Lahman version of the file, but I attributed that to neutralizing the stats.

I checked some other versions of both the Gambo-Spritze and the Spritze databases for OotP12, and they all contain bad data. It's no big deal to fix once I figured out who it was supposed to be, but I figured it was best to let you know.

Thanks again for the hard work.

Originally Posted by Spritze

Thanks, FYI search for quote marks/commas and you'll find all the name errors. There should be no quotes in the base master.csv that comes from the new OOTP guy who changed the names and other base info but he has included a few which is the root cause of your (and our) troubles.

Originally Posted by DXMachina

I found six of them in the DB I'm using: Lou Gehrig (!), Harry Little, Bob Purkey, John Simmons, Joe Tepsic, and George Ulrich. I removed the historical database.odb and restarted the league using just the edited csvs. I now see the usefulness of the odbs. The initial load takes forever with the csvs.

Originally Posted by Spritze

PM me and I'll give you a link to the corrected commaless db on my work ftp site

If you are using Gambos contact him for the similar update

Gambo, I was just checking to see if this issue had been corrected yet on your databases. I'd prefer to use the .odb file for importing and do not have the expertise to even attempt editing it. Thanks in advance for your help and for all the work you and Spritze have done in making historical leagues that much more enjoyable.

[minid]

Originally Posted by Spritze

There are something like 120 total possible adjustments made to each player the amount depending on the things it depends on. Which are a lot of things yes indeedy.

The other challenge is that I've only completely done 1871-1884, 1940-1974. so those years will be most accurate, others less so.

120 total possible adjustments? WOW! That is an amazing amount of work. I feel shameful to ask when the other years will be completed, so I will just check back for updates.

As for MLB players, I would like to make park adjustments for those players so that hitters who played their careers in Coors are adjusted downward when neutralized and hitters who suffered in the Astrodome see a power boost. Is there any easy way to do this? Probably not. One idea I had was to copy the Lehman Batting2.csv rows into your Batting2.csv and then use Excel to delete duplicate rows. The problem, however is that Lehman's neutralized numbers are for park and era, right?

Have you thought about doing park adjustments for the MLB players? Considering the work you already have in front of you, it seems crazy to ask.

[Spritze]

The neutered stats do not come from Mr. Lahman. They are OOTP's own concoction and conflageration.

They are neutralized to a team 750 run environment regardless of the year.

[edm]

Sorry if this has already been answered. But its been awhile since I've used this. Are there any instructions anywhere explaining exactly how to setup our league using the SpritzeHighSchoolDBforOOTP12?

I started a 1961 league using it, but many of the players are too young. Do I only start using this database after setting up the league?

If yes, what database should I start the league with. ootp default? And do I use neutralized for both?

Thanks

[Spritze]

You can use the Spritze db from the get go.

All players should be the ages they really were in 1961 so I'm not sure what too young means.