About This File
EA Speed Analyzer By PaulW EA Speed Analyzer uses baseball stats guru Bill James' new Effective Speed Analysis formula and derives an EA equivilent speed rating for any player of any era as long as the required data is available. The exact formula is used except for two adjustsments: 1. Speed is analyzed for one year only 2. Positional adjustments are based on league average range factors Data needed is: Doubles, Triples, At Bats, Bases on Balls, Caught Stealing, GIDP, Hits, Hit By Pitch, Homeruns, Runs Scored, Stolen Bases and Strikeouts. How to run the program: 1. Go to http://baseball-almanac.com/teamstats/statmaster.php 2. Select the team you wish to analyze 3. Select the stats listed above from the available check boxes 4. Select "Get Stats" 5. Click just left of the first players name and drag your mouse to select all players 6. Once all players are selected hit CTRL-c to copy 7. Place your cursor in the Excel Speed analysis document in the first cell underneath name 8. Hit CTRL-V to paste in the stats from Baseball Almanac You can now sort, select, graph etc. using any Excel function. You'll probably find some interesting results - and sometimes anomalous. My conversion formula attempts to assign speed values in the range of approximately 20 to 100. I haven't gone over 100 yet but it might be possible. Note: If you can avoid hitting any of the hyperlinks in the Excel file you can return to the Baseball Almanac site and enter another team *without* having to reselect the statistics. Contact info: paul.wangerin@cuw.edu
