spritze db question

saturn2187 · 12-11-2012, 03:35 PM

Hi there.
I downloaded the Spritze DB a few weeks ago and I am very impressed by your level of detail - Im sure a great deal of work went into it and I thank you.

When i first tried to make a 1987 historical season , i selected neutralized stats. I couldn't figure out why the defense numbers were all screwed up (Mike Greenwell at 3B, Chili Davis at C, Jose Canseco at 3B, most outfielders 0 ratings.

Anyway, i did some forum crawling and discovered I needed to use real stats. So, i gave up the season i had already gotten half way into, and reloaded with real stats.

Defense numbers are much better, but still something doesnt seem right. Almost every outfielder now has a "10" defense rating, a rare few may have 11.

Ozzie Smith has a "5" defensive rating?
The positions are now correct for the most part but the fact that nobody at any position has a rating much more than 11 or 12 makes me question if I did something wrong again. jesse barfield has a 20 arm in the default database, but in this one he's a 10 or 11 arm just like every other outfielder.

This isn't a knock, its a lot better than I could have done, and I appreciate whats gone into it. If this is the way it is, fine. But I'd like to just confirm that I've done things correctly.

Thanks!

Spritze · 12-11-2012, 10:53 PM

The database is just the player stats, the ratings come from OOTP.

saturn2187 · 12-11-2012, 11:01 PM

OK. I appreciate your quick response, although I was not asking where stats or ratings come from, just whether the faulty ratings that appear are due to some fault of my own or if they are an attribute that we simply have to live with? If so I can go in manually and make corrections. I was just hoping that by using this database that's exactly what I'd be able to avoid.

The Game · 12-12-2012, 08:11 AM

Quote:

Originally Posted by saturn2187

OK. I appreciate your quick response, although I was not asking where stats or ratings come from, just whether the faulty ratings that appear are due to some fault of my own or if they are an attribute that we simply have to live with? If so I can go in manually and make corrections. I was just hoping that by using this database that's exactly what I'd be able to avoid.

How good is your scout? I have used Spritz DB in many of my leagues and now use Gambo which is base off of Spritz i have never seen anyone so dramatic as the ratings you posted. I have seen Ozzie Smith as low as 5 for his rookie year but was an 8 by his 3rd year. Most players are middle of the road 5-7. Whats happens when you use 100% accuracy?

saturn2187 · 12-14-2012, 10:31 AM

my mistake the ozzie smith rating i had looked at was with neutralized stats.

In this latest league, he doesn't even have a defensive rating at SS , and has a "1" at 3B.

Looks like i'm going to have to go in and manually edit every player!

The Game · 12-14-2012, 08:15 PM

Quote:

Originally Posted by saturn2187

my mistake the ozzie smith rating i had looked at was with neutralized stats.

In this latest league, he doesn't even have a defensive rating at SS , and has a "1" at 3B.

Looks like i'm going to have to go in and manually edit every player!

In the newest league. how old is Ozzie? Spritz players come in the year they were drafted vs their rookie year so many players will be rated far less then what we would think they should be. Try using 100% scouting accuracy vs what your scout thinks, since there are too many variables in scouting.
You should never have to manually edit a real player. I have played from 1871-1926 in a historical league using Spritz DB and I have never had an issue with any player who was already at his actual rookie year. I did have issues with a 18 or 19 yr old Tom Tresh being rated a 3 at C. His rookie year he was 20 or 21?
See what Spritz recommends for neutralized vs real stats. I use real for historical and neutralized for importing.

Darviathar · 12-16-2012, 06:58 PM

I downloaded the database today and am trying to start a historical season in 1980. The league is created with 24 teams per league, rather than 12. Obviously a lot of fictional clubs are created. Am I using some incorrect setting? I want to use this DB to replay seasons from 1980 forward, using historical transactions.

The Game · 12-16-2012, 07:48 PM

Quote:

Originally Posted by Darviathar

I downloaded the database today and am trying to start a historical season in 1980. The league is created with 24 teams per league, rather than 12. Obviously a lot of fictional clubs are created. Am I using some incorrect setting? I want to use this DB to replay seasons from 1980 forward, using historical transactions.

When you go to Create New Game...you want to choose Historical. The rest should be good to go. To use the new DB from the start vs default go to advanced options when you choose historical and select the master.cvs from the new DB. i'll post screenshots if you want.

Darviathar · 12-16-2012, 10:02 PM

Quote:

Originally Posted by The Game

When you go to Create New Game...you want to choose Historical. The rest should be good to go. To use the new DB from the start vs default go to advanced options when you choose historical and select the master.cvs from the new DB. i'll post screenshots if you want.

I've done this, and when I reach step 2 for Historical creation wizard (after importing players) it adds a ton of fictional teams. I'm using the Spritze HS database (updated November).

The roster I end up with is not accurate. It includes some players that would later play for the Dodgers (my team), but were not present in 1980.

Is this database not intended for historical replays?

The Game · 12-17-2012, 06:32 AM

Quote:

Originally Posted by Darviathar

I've done this, and when I reach step 2 for Historical creation wizard (after importing players) it adds a ton of fictional teams. I'm using the Spritze HS database (updated November).

The roster I end up with is not accurate. It includes some players that would later play for the Dodgers (my team), but were not present in 1980.

Is this database not intended for historical replays?

Ok can you give me screenshots of what you are seeing cuz I can't figure it out.
I tried doing a test league and everything was fine except all players were FA's, so I messed up myself somewhere, but here are some screenshots.

The Game · 12-17-2012, 06:36 AM

As far as not having real team names...do you have the Apple store version?

Also Spritz DB's bring in most players from their draft year not their actual rookie year. Try Gambo DB for actual rookie year and since you are starting in 1980 you won't miss any of the additional Nippon league players.

Spritz DB & Gambo DB work great for historical leagues, but I like them more for Pre 1950 leagues.
Try using default and see if you get the same results.

Darviathar · 12-20-2012, 05:15 AM

I am using the Spritze database from his FTP site. It was updated in November. Is there a link to the Gambo database you are referring to somewhere here?

I've followed all the steps you outline above. Would using historical transactions cause any problems? I get players on the Dodger roster in 1983 that historically weren't there for 5 years (Mike Sharperson is one).

Spritze · 12-20-2012, 03:33 PM

There will be a new Spritze db tomorrow that handles the team issue. The teams you see are the ones I use, not what comes via the Lahman. My bad, sneaked in on me.

BUT

1) The Spritze db is only fully complete 1871-1900, partially complete 1901-1974, not at all complete 1975-2011.
2) All players become available at 18 (or earlier if their real debut was earlier)
3) All players are expected to progress through the draft or as independent agents or to go to college or join the military or whatever path is chosen for them.
4) All players have MLE's for each of these available years, this allows them to progress via re-calc in an orderly manner.
5) The Spritze db is not compatible with historical transactions or lineups for obvious reasons. (The inclusion of lifetime Minor League Stars, Japanese, Korean and Negro League players are at the top of that list).

The best way to use the Spritze db is to start in 1871 and have a draft. Everything else is up to you.

saturn2187 · 12-20-2012, 03:58 PM

i tried starting my season with the November database and it also included all the fake teams. i had to use the August database instead.

The defensive ratings are off, almost every catcher has a defensive rating in the low single digits.

I'm about halfway through manually correcting the ratings for players based on their defensive ratings in the default 1987 season.

Spritze · 12-20-2012, 04:13 PM

The database has nothing to do with ratings. OOTP controls that.

OOTP also has lots of issues with that ratification process. It used to work in Ver 12. Now it does not. Plus even if you re-rate everybody OOTP will change them back eventually. It sucks but there is nothing to be done about it.

Darviathar · 12-20-2012, 11:14 PM

No problem. I just thought I might have done something wrong and gotten so many extra teams as a result.

pramsey1843 · 01-03-2013, 05:10 PM

I just downloaded the game, how do I get to the FTP site to download the updated database. Thanks in advance.

pbar25 · 01-13-2013, 11:38 AM

Quote:

Originally Posted by Spritze

The database has nothing to do with ratings. OOTP controls that.

OOTP also has lots of issues with that ratification process. It used to work in Ver 12. Now it does not. Plus even if you re-rate everybody OOTP will change them back eventually. It sucks but there is nothing to be done about it.

I'm having some major issues with defensive ratings -- doesn't this suggest that the database provides different defensive ratings?

My test is simple:
I use the traditional stats folder that comes with the game and import
1983 Ozzie Smith
smithoz01
1983

Real Stats / Career Totats / 3-year Period / 3-year Period -- importing from Master

After 50 imports -- he always comes in with premier defense.

I then use the new Jan 2013 Spritze High School Database
1983 Ozzie Smith
smithoz01
1983

Real Stats / Career Totats / 3-year Period / 3-year Period -- importing from Master

After 50 imports -- he never comes in with premier defense

The only thing that I change each time is which 'stats' folder is within my OOTP folder.

Spritze · 01-20-2013, 12:06 AM

Ratings = Try the newest one i just put up.

The Game · 01-20-2013, 11:35 AM

It seems to change based on each year. I have Ozzie Smith in one of my leagues as a clone. Using defult DB 100% scouting accuracy and in year 4 his SS rating is 3. He was 6 as a rookie. Range is still high around 8 or 9. Isn't OOTP responsible for ratings which has nothing to do with which DB one uses?

12-11-2012, 03:35 PM	#1
saturn2187 All Star Reserve Join Date: Nov 2012 Posts: 519	spritze db question Hi there. I downloaded the Spritze DB a few weeks ago and I am very impressed by your level of detail - Im sure a great deal of work went into it and I thank you. When i first tried to make a 1987 historical season , i selected neutralized stats. I couldn't figure out why the defense numbers were all screwed up (Mike Greenwell at 3B, Chili Davis at C, Jose Canseco at 3B, most outfielders 0 ratings. Anyway, i did some forum crawling and discovered I needed to use real stats. So, i gave up the season i had already gotten half way into, and reloaded with real stats. Defense numbers are much better, but still something doesnt seem right. Almost every outfielder now has a "10" defense rating, a rare few may have 11. Ozzie Smith has a "5" defensive rating? The positions are now correct for the most part but the fact that nobody at any position has a rating much more than 11 or 12 makes me question if I did something wrong again. jesse barfield has a 20 arm in the default database, but in this one he's a 10 or 11 arm just like every other outfielder. This isn't a knock, its a lot better than I could have done, and I appreciate whats gone into it. If this is the way it is, fine. But I'd like to just confirm that I've done things correctly. Thanks!

12-11-2012, 10:53 PM	#2
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	The database is just the player stats, the ratings come from OOTP. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

12-14-2012, 10:31 AM	#5
saturn2187 All Star Reserve Join Date: Nov 2012 Posts: 519	scout my mistake the ozzie smith rating i had looked at was with neutralized stats. In this latest league, he doesn't even have a defensive rating at SS , and has a "1" at 3B. Looks like i'm going to have to go in and manually edit every player!

12-20-2012, 05:15 AM	#12
Darviathar Minors (Single A) Join Date: Feb 2011 Posts: 84	I am using the Spritze database from his FTP site. It was updated in November. Is there a link to the Gambo database you are referring to somewhere here? I've followed all the steps you outline above. Would using historical transactions cause any problems? I get players on the Dodger roster in 1983 that historically weren't there for 5 years (Mike Sharperson is one). Last edited by Darviathar; 12-20-2012 at 05:25 AM.

12-20-2012, 03:33 PM	#13
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	There will be a new Spritze db tomorrow that handles the team issue. The teams you see are the ones I use, not what comes via the Lahman. My bad, sneaked in on me. BUT 1) The Spritze db is only fully complete 1871-1900, partially complete 1901-1974, not at all complete 1975-2011. 2) All players become available at 18 (or earlier if their real debut was earlier) 3) All players are expected to progress through the draft or as independent agents or to go to college or join the military or whatever path is chosen for them. 4) All players have MLE's for each of these available years, this allows them to progress via re-calc in an orderly manner. 5) The Spritze db is not compatible with historical transactions or lineups for obvious reasons. (The inclusion of lifetime Minor League Stars, Japanese, Korean and Negro League players are at the top of that list). The best way to use the Spritze db is to start in 1871 and have a draft. Everything else is up to you. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

12-11-2012, 11:01 PM	#3
saturn2187 All Star Reserve Join Date: Nov 2012 Posts: 519	OK. I appreciate your quick response, although I was not asking where stats or ratings come from, just whether the faulty ratings that appear are due to some fault of my own or if they are an attribute that we simply have to live with? If so I can go in manually and make corrections. I was just hoping that by using this database that's exactly what I'd be able to avoid.

12-16-2012, 06:58 PM	#7
Darviathar Minors (Single A) Join Date: Feb 2011 Posts: 84	I downloaded the database today and am trying to start a historical season in 1980. The league is created with 24 teams per league, rather than 12. Obviously a lot of fictional clubs are created. Am I using some incorrect setting? I want to use this DB to replay seasons from 1980 forward, using historical transactions.

12-17-2012, 06:36 AM	#11
The Game Hall Of Famer Join Date: Feb 2012 Location: Inside The Game Posts: 30,937	As far as not having real team names...do you have the Apple store version? Also Spritz DB's bring in most players from their draft year not their actual rookie year. Try Gambo DB for actual rookie year and since you are starting in 1980 you won't miss any of the additional Nippon league players. Spritz DB & Gambo DB work great for historical leagues, but I like them more for Pre 1950 leagues. Try using default and see if you get the same results.

12-20-2012, 03:58 PM	#14
saturn2187 All Star Reserve Join Date: Nov 2012 Posts: 519	i tried starting my season with the November database and it also included all the fake teams. i had to use the August database instead. The defensive ratings are off, almost every catcher has a defensive rating in the low single digits. I'm about halfway through manually correcting the ratings for players based on their defensive ratings in the default 1987 season.

12-20-2012, 04:13 PM	#15
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	The database has nothing to do with ratings. OOTP controls that. OOTP also has lots of issues with that ratification process. It used to work in Ver 12. Now it does not. Plus even if you re-rate everybody OOTP will change them back eventually. It sucks but there is nothing to be done about it. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

12-20-2012, 11:14 PM	#16
Darviathar Minors (Single A) Join Date: Feb 2011 Posts: 84	No problem. I just thought I might have done something wrong and gotten so many extra teams as a result.

01-03-2013, 05:10 PM	#17
pramsey1843 Bat Boy Join Date: Jan 2013 Posts: 4	I just downloaded the game, how do I get to the FTP site to download the updated database. Thanks in advance.

01-20-2013, 12:06 AM	#19
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Ratings = Try the newest one i just put up. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

01-20-2013, 11:35 AM	#20
The Game Hall Of Famer Join Date: Feb 2012 Location: Inside The Game Posts: 30,937	It seems to change based on each year. I have Ozzie Smith in one of my leagues as a clone. Using defult DB 100% scouting accuracy and in year 4 his SS rating is 3. He was 6 as a rookie. Range is still high around 8 or 9. Isn't OOTP responsible for ratings which has nothing to do with which DB one uses?