OOTP Developments Forums - View Single Post - 3195

dhill · 03-27-2007, 07:33 PM

I have been thinking about this for awhile, how to replay a MLB year using the stats from that year, like the old table top baseball board games. The table top games gave you cards that had the stats for all of the players for a specific year. I tried this in OOTP2006 using both the use career stats and remaining stats options, but the players’ stats did not match their stats for the real year. So, I decided to play with the Lahman database to tweak it to meet my needs. I used the 1980 season.

For all players that played in 1980, I replaced their historical stats with their 1980 stats. This will keep the number of years that they played, but the overall averages will equal the 1980 stats. If a player had 30 HRs in 1980, then he had 30 HRs for every year of his career until 1980. It was a simple project of copying out the 1980 stats and using vlookup in Excel to replace all of the other stats (including fielding). I do not know if it was necessary to keep the historical stats for the 1980 players, but it seams that OOTP uses the player history to determine age factors. I also deleted all the players that did not play in 1980 and all stats after 1980. The results were very similar to the real results, with team finishing within a few (1 to 8) wins of the real season. I left injuries on to add some variability.

03-27-2007, 07:33 PM	#1
dhill Bat Boy Join Date: Jul 2006 Posts: 6	3195 - Replay A Single Historical Year I have been thinking about this for awhile, how to replay a MLB year using the stats from that year, like the old table top baseball board games. The table top games gave you cards that had the stats for all of the players for a specific year. I tried this in OOTP2006 using both the use career stats and remaining stats options, but the players’ stats did not match their stats for the real year. So, I decided to play with the Lahman database to tweak it to meet my needs. I used the 1980 season. For all players that played in 1980, I replaced their historical stats with their 1980 stats. This will keep the number of years that they played, but the overall averages will equal the 1980 stats. If a player had 30 HRs in 1980, then he had 30 HRs for every year of his career until 1980. It was a simple project of copying out the 1980 stats and using vlookup in Excel to replace all of the other stats (including fielding). I do not know if it was necessary to keep the historical stats for the 1980 players, but it seams that OOTP uses the player history to determine age factors. I also deleted all the players that did not play in 1980 and all stats after 1980. The results were very similar to the real results, with team finishing within a few (1 to 8) wins of the real season. I left injuries on to add some variability.