Gambo DB for 2008

[Gambo]

Hey guys! Just to let you know I am working on a database update for 2008. As of right now I essentially have it done but I am just working on a few things that I want to add before I release it.

Some of the things I fixed/changed already are...
1. Error's in teams : I noticed some errors on teams in which changed such as Milwaukee/Atlanta where players would be coded with Atlanta but the team was still in Milwaukee therefore causing them to import as Free Agents.

2. Players will now import on the team they were on on opening day. Even if they didn't play for that team or were free agents. If the team played there opening day game on April 3rd and signed Joe Nobat on April 5th, he will be imported as a free agent. I checked the schedules for every team when I did this.

3. The Federal League stats have been adjusted to be the equivalent of a AAA.

4. The Negro League stats I previously used are now adjusted to be midway between AAA and MLB.

5. Managers who didnt make the majors will have their stats more realistically depicted according to their best available minor league statistics (I am still working on this - almost had it done then deleted the file)

6. Stats (including real minor league organizations and "statistics") are updated through the 2007 season.

Essentially, there is not enough difference whereas if you were using my previous database you will not be able to continue with this one instead but there may be some conflicts. Duplicate/skipped players will be rare if any in your league (and will only affect one year)

(An example of this is the Mark Lansing factor, in previous databases I used his import year as the year the Marlins signed him. Instead now it will be the year he was signed by the Independent Miami team)

I don't know when I will release it but I hope by the time spring training is about to end. There is still some stuff I want to add to it but I may not get to.

[Coreyettinger]

You are the man.

[Gambo]

Its ready I'm just holding it for some odd reason. In case I come up with some errors or something...

[kagnew35]

Any word on a host, Gambo?

[Gambo]

Havent heard anything yet... kinda annoying...

[Gambo]

Here is an excerpt from the readme for you though...

This is the latest version of my database. These are the list of additions/changes which I have made for the 2008 version. I would like to thank Microsoft for letting Excel 2008 increase the amount of lines per worksheet.

There is not enough difference whereas if you were using my previous database you will not be able to continue with this one instead but there may be some conflicts. Duplicate/skipped players will be rare if any in your league (and will only affect one year)

(An example of this is the Mark Lansing factor, in previous databases I used his import year as the year the Marlins signed him. Instead now it will be the year he was signed by the Independent Miami team)

1. Updates
a. The statistics have fully been reworked from scratch for all players through 2007.
b. Players are now more accurately assigned to the team they were with as of opening day for that year. (If a player signed April 1st, but the the team they started with played their 1st game March 30th then they will import as a free agent) I checked the schedules for every team when I did this.
c. Fixed ALL players who played in both Japan and the Majors Leagues with their MLE’s for the years in Japan. Players who started their career in Japan will still import as a rookie Free Agent when their career started in Japan. This has been updated for 2006 and 2007 MLB rookies.
d. Tweaked the statistics for players who played in the Majors and Negro leagues where needed.
i. The Negro League stats I previously used are now adjusted to be midway between AAA and MLB. I did this after doing some research and determining that they seemed to be rated a bit too high.
e. Managers who didnt make the majors will have their stats more realistically depicted according to their best available minor league statistics
i. Gave stat lines to new managers from 2006 and 2007 who never made the majors such as Manny Acta, Gonzalez.
f. Lines up correctly the proper organizational coding for all players. (No more players importing as a free agent because I have them coded for Atlanta when the team was still in Milwaukee)
g. Federal League stats have been adjusted to be the equivalent of AAA
2. Additions
a. I added 85 minor leaguers with their MLE’s. This list includes every top ten draft pick from 1978-2000 who didn’t make the majors (incl. Brien Taylor), 1984 Olympic players (incl. Flavio Alfaro), multi sport athletes (incl. John Elway) and for now two players who played in Japan but not the Majors (Gene Bacque and Bobby Marcano), prospects from the Yankees (incl. Chris Cumberland) and some players I have had the pleasure of growing up with, playing with or coaching from the New York area (incl Sammy Rodriguez). I had planned on adding some Japanese stars but did not include due to time constraints.
i. I know many may not want these players in their leagues so all that needs to be done is open the Master.csv in the Import and Yearly directory and delete each player line after 17044. Note the master file also has numerous players who played in Japan but are not from there. These players do not have player codes or stat lines so they can be discregarded. If you want to pick and choose who you want delete only the lines you wish to remove.
3. Future Plans
a. I am going to stop with this for a while so I am not going to make any future plans. I would like however, in the future to add more minor leaguers and Japanese players but I do not know if I will do this. Any future updates will be minor additions to facilitate 2008 and on rookies.