Spritze DB's for OOTP11

[terpsfan101]

I was going to check Spritze's DB's but I couldn't connect to his secret FTP site earlier today. The newer versions of his databases (where he fixed the teamIDs) are posted on the FTP site. If I can't connect to his FTP site, I'll just download the DB's that are posted on the PadresFan website

[terpsfan101]

The neutralized stats are nearly identical to the real life stats in Spritze's DB's as well.

[Gambo]

I posted this on the thread for my database and I figured I would post it here so you know.

Hey guys,

For now use the database with discrection. I know most of you guys are probably waiting to the patch to come out to start a league but it looks like there may be an issue with the neutralization formulas. I am going to get with Spritze to see if we can get it fixed up but I guess you can consider this a beta to check out and see if you like it.

It looks like there is an issue with the neutralization of certain players. It appears for that for years where the guy did not play in the majors it's good but if they had major league statistics it is coverting their plate appearances but not "neutralizing" the statistics. I'll get with Spritze and see how to proceed.

[Spritze]

Originally Posted by Gambo

It looks like there is an issue with the neutralization of certain players. It appears for that for years where the guy did not play in the majors it's good but if they had major league statistics it is coverting their plate appearances but not "neutralizing" the statistics. I'll get with Spritze and see how to proceed.

Atchally the challenge is simply I started with the wrong set of batting, pitching, fielding, and fieldingof CSV’s.



One db makes the standard OOTP neuts and then that set of csv’s makes the 2’s you and I use.



I started with the boring old Lahman instead of the neutered Lahman because I seem to have overwritten the neutered Lahman with the boring old one on accident. So I have TWO(2) boring old std Lahmans sets of CSV’s, one in the folder cleverly labeled BoringOldLahmanCSV and one in the folder labeled NeuteredLahman but nary a sign of the actual neutered CSV’s.



So I’ll need to re-suck up the 2009 newt version and re-run.



I fixed up several “errors” last week anyway. Garlons formulas don’t always produce logical outcomes for the “outlier” player seasons, now they do. Plus there were things he skipped because he didn’t care about them, they have been incorporated. Tiny changes but I like it much better and who better to please than I.

[tripps04]

Quick ? for you guys, using Real Debut Real Teams database, I keep seeing alot of relievers with only a fastball and 1/1 rating in that pitch. Is there something I should be using like recalc or Neut, or something else. Thanks for all the hard work on this it really adds to the game so much

[Bristolduke]

That's a bug in the basic game (the in game DB has the same problem). I don't believe it to be a problem specific to Spritze or Gambo DBs.

[tripps04]

Wow, thats a pretty serious bug, if I have to go in and change pitcher ratings for every draft, oh well just have to deal with it then. thanks for the quick response.

[mikecos23]

So I am running into an interesting "opposite" problem. I've done a 1980 import with the Gambo/Spritze database and off the 713 total pitchers that imported (MLB and MiLB), only 120 of them even have a fastball as a pitch...

Also, I am using the 20-80 scouting scale and the ratings for the fastballs are pretty low, only 10 pitchers (!!) have a rating higher than a 45 for their fastball.

Not sure what would cause this strange import, I imported neutral stats...

Oh and I'm not saying this is a problem related to the database, I just haven't really paid much attention to this in the past. I only noticed because I had Nolan Ryan on the team I was going to take and he wasn't even rated for a fastball!!!
----------------------------------------------------------
OK have an older 1994 MLB historical start with the Gambo/Sprtize and noticed the same thing, almost none of the pitchers in the league have a fastball!!! I quit this one before I was even through the all star break because the offensive #'s were very inflated, i.e. league batting avg was .301!!! Now I may know why...

[Gambo]

Originally Posted by mikecos23

So I am running into an interesting "opposite" problem. I've done a 1980 import with the Gambo/Spritze database and off the 713 total pitchers that imported (MLB and MiLB), only 120 of them even have a fastball as a pitch...

Also, I am using the 20-80 scouting scale and the ratings for the fastballs are pretty low, only 10 pitchers (!!) have a rating higher than a 45 for their fastball.

Not sure what would cause this strange import, I imported neutral stats...

Oh and I'm not saying this is a problem related to the database, I just haven't really paid much attention to this in the past. I only noticed because I had Nolan Ryan on the team I was going to take and he wasn't even rated for a fastball!!!
----------------------------------------------------------
OK have an older 1994 MLB historical start with the Gambo/Sprtize and noticed the same thing, almost none of the pitchers in the league have a fastball!!! I quit this one before I was even through the all star break because the offensive #'s were very inflated, i.e. league batting avg was .301!!! Now I may know why...

Found the problem with this one. Pretty easy catch. In the master.csv I was using there was an extra column that caused the pitches not to be aligned right. The only fastball pitchers were ones the game designated as fastball pitches). I have let Spritze know to double check his and this will fix the problem.

It may (probably not but maybe) also fix up some of the fielding issues some people are seeing.

[dcundy]

using the new db with ootp11 and christy mathewson is a closer

[dcundy]

not sure why this happens but no matter what db i use ty is always not as good as joe jackson?

[majesty95]

I started a 1985 replay with the real teams, real debut DB. I'm starting with the Rangers and was looking for Mitch Williams, who the Rangers got in the Rule 5 draft from the Padres in December of 1984. Mitch is not with either team and I cannot even find him in the game when doing a search.

Also, Dave Hostetler is still with the Rangers even though they traded him to Montreal in Novemeber of 1984. I'm sure this is because he did not appear in the majors in 1985 so I'm not sure this is a bug but thought I would point it out.

Thanks for your diligent work

EDIT: I found "Wild Thing" in the csv file but it loks like his debut year is 1986 but he was actually drafted in 1982. I thought the real debuts, real teams was supposed to be based on the actual year the player was drafted :~\ Yes, I am sure it is pointed to your DB

[majesty95]

OK, so I started another league using neut stats and got more players in my system but a ton of real life stars who are free agents (and still no Mitch Williams). The stars like Rickey Henderson and Ryne Sandberg have no team name listed in their real life stats for certain years. Cubs for Ryno and Yankees for Rickey. Tony Gwynn, Fernando Valenzuela, Orel Hershiser and more all having same issues.

[Spritze]

New Versions uploading to the 'secret' ftp site now.

Fixes are added Garlon's neutralized stats and changed team abbrev to match the new ones in Lahman57

and

added the 'real" teams for pre 1901 leagues. Not quite sure how this works yet. I put it together using info posted in the forums but I didn't understand it all so this bit will be adjusted over the next week until it works easily. Worst case is probably some players will be free agents who shouldn't be.

Fixed the fixes this evening around 7 PM PST. Error in the Real Debuts. I'm going to add the Real Teams to the Japanese and Korean Leagues tomorrow.

[dcundy]

Any chance I could have access to private site.

[Spritze]

Originally Posted by dcundy

Any chance I could have access to private site.

send me a PM and I'll send it to you.

[hfield007]

Ok which database on the site is the one where they all import to the draft at like 18 or so and it includes negro leaguers but no asians?

[plannine]

Originally Posted by Spritze

send me a PM and I'll send it to you.

When starting with 1871 the all-18DB seems to take a nose dive when 1881-2 comes round.

Trying again a third time.

[Spritze]

Originally Posted by plannine

When starting with 1871 the all-18DB seems to take a nose dive when 1881-2 comes round.

Trying again a third time.

What error message do you get or what constitutes nose-diving?

[plannine]

Originally Posted by Spritze

What error message do you get or what constitutes nose-diving?

Only changes to default set up -
no finances
18 man roster/35 man secondary
Let computer play a season, then look at results.
Do the same each year until 1881 with no issues.

1881 season starts - all teams are in one league, 7 old teams and 1 new team.
Each team has players including pitchers.
Autoplay season.
After 2 games in the 1881 season, Goes to Round 1 of playoffs.
then following message:
No Starting Pitcher Found. (click ok)
No Starting Pitcher Found. (click ok)
Game shuts down.
MS Windows Dialog Box appears:
OOTP Baseball has quit working


Was able to recreate again.

If I turn off expansion in 1880, i will make it past 1881 and into 1882 (when I turned expansion back on). The expansion for the 1883 season went fine.

So the problem seems tied to the 1881 schedule/teams.


-----------------------------------------------------
The 25 teams seems a little weird for the 1884 season.

One of the issues I have with so many teams and team movements, is that many, would not have happened if they had a either a winning team, fiscal responsibility, or owners who stayed away from drinking, gambling, Broadway shows and wild women!!

In the test replay, in 1873, Baltimore Marylands went 33-11 . In real life, they were 0-6 getting outscored 152 to 26.
The Elizabeth Resolutes went 2 and 21 in real life, while in the test replay they went 34-13.

Both team were one year failures in real life, but in the replay, they were successful, but still lasted only a season.

Personally, I would eliminate teams that did not exist for more then 4 consecutive full seasons. But that's me.....