|
I've attached my template here if you want to do something similar.
All the Lahman data is already in there so all you have to do is export the csv files from the game. Filter them to just just be the Major league data and years you are interested in. Paste the players data in to the Master tab, career batting stats in to Batting Stats and career pitching stats into Pitching Stats. The last thing is to make sure the formula in columns AF:AG of the batting stats and AY:AZ of the pitching stats reach the bottom of the pasted data.
After its calculated the graphs should be on the final two tabs. Should only take 5 minutes and is a useful check.
|