|
Found an issue with the program....it appears that the new debut years file works fine except that when you have multiple records in the batting, pitching, fielding files for the same year it will number them as single records. Example if a player had three fielding positions in a year the random update wil give them (1901, 1902, 1903, example) instead of the same year.... This causes problems assigning players the wrong position when importing into the game...
I ended up putting the tables into an access table the creating a new field called modified years and this value is added to the season, birth year and debut year in all the tables. This was simply the debut year - the random year and add this to the year in the tables.
This could probably be done in the new debut year program by creating a random debut year and then taking the debut year -the random year to get the modify year, then just add this number to the season in all the excel tables to get the new year.
|