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. 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 decent at completing tasks A and B. I know of several game caveats that cause the program to fail. I plan to use my scorecards from the 2009 Pittsburgh Pirates to help identify (and fix, if possible) these shortcomings.

I will keep you posted on my progress, and eventually I will make the workbook available. Until then, you can click on “My Scoresheet” in the Files section on the right-hand side of this page to see a screenshot of the workbook. This printout is the scorecard that I use to score each and every Pirate game.

Trackback

2 comments until now

  1. This sounds like a wonderful project and one I would use. Of course, the dreaded Pirates are not my team. :) Would you be willing to share the macros as currently written?

  2. Thanks for the feedback.

    One or two others have expressed some interest in seeing the actual file, so I do plan to make it available on this site.

    Over the next few days, I’d like to do some additional tweaking, but then I’ll post it.

    Thanks again,
    Ben

Add your comment now