I’ve discussed the amount of information that you can extract from Retrosheet event files. Using this information, you can perform an almost unlimited amount of analysis on just about any game, player, team, or season in baseball history.

Something that is more difficult is to perform the same type of analysis on information from the current season or from scorecards in your collection. Since Retrosheet releases all of their data at once, at the end of each season, there are no event files to process.

For a long time, I looked for a tool that would help to convert a scorecard into a Retrosheet-formatted event file. Several years back, Heritage Software had a piece of freeware called Official Scorer. This program did a pretty nice job, but it wasn’t capable of handling pitch data, and it had problems with the program crashing at random times. There is/was a program from Diamond Ware called DWENTRY. I believe that this is the program used by Retrosheet to create their files, but I can’t find a copy of it anywhere.

So, after struggling to find exactly what I was looking for, I decided that I should try to build something myself. I’ve done a good amount of programming, but most of it has been web-based and I’m not nearly fluent enough in Java or C to create a full featured program, so I decided that using VBScript macros within a Microsoft Excel workbook would be my best option.

This workbook has been a work in progress for almost 3 years now… not that I’ve been working on it for 3 years… I’ve just slowly pieced it together and improved it when I’ve had time.

It’s not perfect, and nowhere near it. Ideally, this program would have the capability of:

a) looking like a scorecard and being used to score a game
b) creating a Retrosheet-formatted event file
c) importing a Retrosheet-formatted event file and populating the scorecard based on game data

Currently, it’s pretty good at completing these tasks. It does not yet accept pitch-by-pitch data, just play-by-play data. I plan to use my scorecards from the 2009 Pittsburgh Pirates to help identify (and fix, if possible) any shortcomings.

Trackback

only 1 comment until now

  1. […] Ben’s Retrosheet Scorecard April 15, 2009 […]

Add your comment now