OOTP Developments Forums - View Single Post

SandMan · 01-31-2005, 08:50 PM

The only readme you will need to use for the instructions on this are Sandman's. I enclosed BD3's because originally I used his excel random debut program to create the new debut years. I found errors in his program when assigning years to seasons with multiple batting or fielding records. Example a player may have 10 seasons records and 25 fielding records. the Batting records would show up as 1901, 1902, ... to 1910. The fielding records wouls come in as 1901, 1902, .... to 1925.

I moved only the random years part with a new field that I needed over to MSACCESS and wrote the queries that MSACCESS need to create the new debut files fixing some problems, like players with no birth dates (made them 22 at debut) and then had the ACCESS records written to a new CSV file.

This database is randomized but cannot be used with BD3's random kit because of the fielding record issue. The players cannot be re-randomized in this dataset. Originally I was going to release all my MSACCESS tables and queries required to re-randomize the data but then I had the feeling that I would be trouble shooting a lot of ACCESS questions, so I just randomized it once and released it as a dataset.... hope this explains everything.....

It is actually quite interesting, take a look at the master file and you will get an idea of when your favorites will enter the league...... Hank Aaron is a rookie in 1902...

01-31-2005, 08:50 PM	#7
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	Confusion on Readme files... The only readme you will need to use for the instructions on this are Sandman's. I enclosed BD3's because originally I used his excel random debut program to create the new debut years. I found errors in his program when assigning years to seasons with multiple batting or fielding records. Example a player may have 10 seasons records and 25 fielding records. the Batting records would show up as 1901, 1902, ... to 1910. The fielding records wouls come in as 1901, 1902, .... to 1925. I moved only the random years part with a new field that I needed over to MSACCESS and wrote the queries that MSACCESS need to create the new debut files fixing some problems, like players with no birth dates (made them 22 at debut) and then had the ACCESS records written to a new CSV file. This database is randomized but cannot be used with BD3's random kit because of the fielding record issue. The players cannot be re-randomized in this dataset. Originally I was going to release all my MSACCESS tables and queries required to re-randomize the data but then I had the feeling that I would be trouble shooting a lot of ACCESS questions, so I just randomized it once and released it as a dataset.... hope this explains everything..... It is actually quite interesting, take a look at the master file and you will get an idea of when your favorites will enter the league...... Hank Aaron is a rookie in 1902...