Quote:
Originally posted by Tresclub
How did you do this?
|
My conversion technique is probably different from the others here. In my former job I did quite a bit of work converting data files from one format to another format I was using. However, I don't have that software I formerly used at work on my home machine, so to convert from Retrosheet to OOTP-ready, I have been basically using a spreadsheet (the Works version, not even Excel).
I assumed someone more experienced in Windows programming would do something more sophisticated, and it seems one or two others have at least done something different. But it appears no one has yet done what I thought would be optimal in this regard - make a little GUI program similar in appearance to Stickware that nearly fully automates the process.
In the absence of that, if there are a handful of people who have worked some on Retrosheet-to-OOTP conversion, perhaps there can be coordination (or pushing it all onto one person) to produce one set of results, presumably that can come as close as OOTP can to the exacting standards of LGO. Dates and teams cannot really be argued, so game times are the key thing to make uniform, and LGO has now posted above what could probably be general guidelines. Also, there are a few issues I have so far run into with the Retrosheet schedules, notably a handful of apparently incorrect dates in the 1957 file (an "n" at the end of the yyyymmdd, when the dd part is missing a zero?) and how do handle postponed games.