Good info here. I created a baseball simulation last year but only implemented it for the last couple of months of the season.
The biggest struggle I had was determining how to handle to runners on base. For instance if I had a guy on 2nd, and the batter hit a single...what percentage of the time does he score, what percentage does he end up on 3rd and what percentage is he thrown out? Is there any data out there giving averages?
Secondly, for those that do this, where do you get your data? Right now I just use Team batting stats for all situations: home, away, night, day, etc, but I don't break it down to the individual player. For pitching I use the individual pitcher stats, and a general bullpen. I grab my data by copying and pasting into Excel and running an application to update my database.
I'm looking for ways for improvement, so any ideas are greatly appreciated