Spritze DB's for OOTP11

[Spritze]

Originally Posted by kagnew35

Redl'd and works fine, only difference, is tried complete history in 1st try, not in 2nd??

There is no history before 1871 so if you start there do not import history.

New set of files on the FTP; updated the fielding stats with new neutralized versions in the case of some players. Updated debut years to Gambo's debut year list.

[dcpcarmona]

what is the ftp?

[Spritze]

You must PM me to get it as it is on my work site until thoroughly tested and then it will be over at Padres site,

[Gambo]

I am currently in the testing phase for my database. If everything goes well I will release it this weekend maybe sooner.


All the MLB,Negro Leaguers,Minor Leaguers and Top 50 Japanese(*NEW*) players with real debut years and real organizations for each year.

[spacer99]

I can"t thank Gambo and Spritze enough. Your hard work really adds to my enjoyment of this game.

[Gambo]

Without Spritze my database would have really been DOA with this years game.

[Elysian Fields]

What's the difference between the two databases... Spritzes and Gambos, I mean? I'm new to the ootp world of sim baseball. Apologies for my ignorance of you guys' stuff.

[Gambo]

Overall the database include all major league players, star minor leaguers, negro leaguers, japanese/korean players and a few others. For all these players their stats have been neutralized according to level (or league) and age.

Both databases include minor league years and post major league seasons (for players played their last major league game prior to 35 years old). Both use the same neutralized statistics so at the core there is no difference.

The idea is that it expands the amount of real players available to you and does not constrict you to using major league players only when they appeared in the majors. Also, these are both in .odb format so there is not the import issues (crashing/time) there were previously.

Spritze includes versions that have all players, only american players and with those two versions that have players debut at 18 (high school) or real debut. Keep in mind real debut means.

My version of the database includes all americans from Spritze (including those who played only foreign ball), any others from Sprize who played in the U.S. and now in this version the top 50 historical Japanese players. Additionally, players will debut when they 1st played professionally. Upon league creation players will be in the organization they were with on opening day of that year. (If they signed with a team on the 2nd day of the season, they're a Free Agent).

The other big difference is that the player and league statistical history will only have Major League statistics wheras Spritze will show their statistics regardless of league and level. The reason I set up mine this way is I want actual Major League History in my league and having the additional stats affects career totals. If I start a league in 1970, Hank Aaron will be chasing Babe Ruth's homerun record of 714. The possible negative part of this is that players like Josh Gibson or Sadaharu Oh will not have any statistics by which to compare their OOTP performance to. However, their Negro League and/or Japanese statistics will not translate to MLB performance anyway. These players will be a somewhat unknown quantity and the player will have to judge their expectations solely on reputation. (Don't worry, the game not showing their real statistics does not mean they are not rated properly as this is pulled from a separate file)

[Gambo]

I will send a copy to Padres Fan tonight. I've run a couple of test to make sure they are no functional issues and the results are right where I would want them to be. Expect to see a version hopefully tomorrow at Padres site, but maybe not for a couple of days.

Also, I will try to get out a second version shortly that makes one change to the setup i currently have. With my standard version players who started tehir pro career in the Negro Leagues or PCL or another non major league will import as Free Agents when importing them as rookies (with assign rookies to actual teams). This includes players like Hank Aaron, Joe DiMaggio, etc. The extra version will be less realistic but cater to those who would like Aaron and Dimaggio etc to go to the Braves and Yankees respectively.

This is no a priority but I will try to have something by the end of the week.

[Gambo]

Have sent it for release...

http://www.ootpdevelopments.com/boar...ml#post2992661

[kagnew35]

Started a 1939 league and have no FA's and average of 26-28 man rosters???

[Gambo]

Originally Posted by kagnew35

Started a 1939 league and have no FA's and average of 26-28 man rosters???

Oh yeah. You have to choose neutralized statistics. If you choose real stats it will be the in game Lahman import. That's an added bonus that it can exist as a regular database also, however it will mess up probably when doing rookies each year as the debut years are different.

Sorry for not explaining that.

[terpsfan101]

Gambo, the teamID's of some players don't match up correctly in your database. For instance, Al Spalding has a teamID of BS1 in the batting2 table, but has a teamID of IND (i.e., free agent) in the pitching2 and fielding2 tables.

[Gambo]

Originally Posted by terpsfan101

Gambo, the teamID's of some players don't match up correctly in your database. For instance, Al Spalding has a teamID of BS1 in the batting2 table, but has a teamID of IND (i.e., free agent) in the pitching2 and fielding2 tables.

Shouldn't matter when importing players. He should still be with BS1 since batting2.csv is the driver. Try it out just to make sure.

[terpsfan101]

The only other minor problem with your database Gambo is that the major league statistics are not neutralized. For instance, Hank Aaron's batting statistics from 1954-1975 are identical to his real life statistics. I was under the impression that all statistics in the "2" tables were neutralized.

[Gambo]

Originally Posted by terpsfan101

The only other minor problem with your database Gambo is that the major league statistics are not neutralized. For instance, Hank Aaron's batting statistics from 1954-1975 are identical to his real life statistics. I was under the impression that all statistics in the "2" tables were neutralized.

Actually no they're not. They are close but they are not the same. There just happens to be very little neutering according the Spritze's formulas for this year compared to past years. In many situations you will only see differences of a few points for batting and a few homeruns. Especially for starters who played in generally neutral ballparks. There used to be more drastic differences as everybody used to be progressed to ~550 AB, but that is no longer the case.

Take a closer look. I had to take a good look at Aaron before I realized it and actually muttered a few curses under my breath. But, they are different.

Now if you're looking at their stats in game, the years prior to the current season should be the real stats. This is intentional and something that couldn't be done last year. IF you look at their real life stats tab you will see the actual and neutralized statistics.

[terpsfan101]

I looked at this issue closer today and discovered that the stats have not been neutralized. All that has been changed is the number of games. On a per game basis the neutratlized statistics are identical to the actual statistics. Well, not 100% identical because of rounding. Take a look at Dante Bichette's actual and neturalized batting line in 1996:

Stat, Actual, Neutral

G: 159, 154
AB: 633, 613
R: 114, 110
H: 198, 192
2B: 39, 38
3B: 3, 3
HR: 31, 30
RBI: 141, 137
SB: 31, 30
CS: 12, 12
BB: 45, 44
SO: 105, 102
HBP: 6, 6
SF: 10, 10
AVG: .313, .313
OBP: .359, .360
SLG: .531, .532

[Gambo]

Is this issue with all versions of the Spritze DB or which ones have you found it in?

[terpsfan101]

I discovered the problem in the Spritze/Gambo database. I didn't check to see if the problem exists in any of Spritze's DB's.

[Gambo]

It may be a good idea to check the other releases too.