OOTP Developments Forums - View Single Post

MTGian · 04-16-2003, 03:30 PM

Greetings,

I am probably asking for trouble here, but I created normalized databases for OOTP4. They are for Lahman v4.5. For more information, you might be able to do a search for normalized databases and look up the information that I posted in the past. Also, you could try searching for my name (MTGian).

I have the following versions.

1) Looks exactly the same as Lahman database, but each entry is normalized for that year. Approx Size: 4 MB.

2) Starting with #1, I then averaged performances over the players entire career. So, you end up with career average data instead of year-by-year data. Approx Size: 1 MB

3) Starting with #2, I culled out players who didn't play very much and delayed players debuts if they played very little in their first season or two. Approx Size: 0.5MB

Send me an e-mail, and I will reply with the version that you request. I do not check this bulletin board regularly, so if you want it you MUST e-mail me. My address is mtg0954@rochester.rr.com. Repeat, I will not send you the files unless you e-mail me first, and I can simply reply, then attach, then send.

Hope this helps.

MTGian

P.S. I did not do the normalization by hand. I used Microsoft Access. You could do it with Excel, but it is much harder.

04-16-2003, 03:30 PM	#10
MTGian Minors (Triple A) Join Date: Jul 2002 Posts: 233	Greetings, I am probably asking for trouble here, but I created normalized databases for OOTP4. They are for Lahman v4.5. For more information, you might be able to do a search for normalized databases and look up the information that I posted in the past. Also, you could try searching for my name (MTGian). I have the following versions. 1) Looks exactly the same as Lahman database, but each entry is normalized for that year. Approx Size: 4 MB. 2) Starting with #1, I then averaged performances over the players entire career. So, you end up with career average data instead of year-by-year data. Approx Size: 1 MB 3) Starting with #2, I culled out players who didn't play very much and delayed players debuts if they played very little in their first season or two. Approx Size: 0.5MB Send me an e-mail, and I will reply with the version that you request. I do not check this bulletin board regularly, so if you want it you MUST e-mail me. My address is mtg0954@rochester.rr.com. Repeat, I will not send you the files unless you e-mail me first, and I can simply reply, then attach, then send. Hope this helps. MTGian P.S. I did not do the normalization by hand. I used Microsoft Access. You could do it with Excel, but it is much harder.