Saturday, July 18, 2015

BvP Tweaks

Although the new Batter vs. Pitcher report was released in beta version (for testing and comments) on June 30, it appears that some users were caught by surprise on Friday when they went to access the latest data. First of all, if you were unprepared, that's on you - as there was plenty of warning and an opportunity to suggest modifications and make preparations (which many of you took advantage of). But nevertheless, I found myself responding to a number of inquiries on Friday, and some of those ideas have been implemented.

One user noted that strikeout data was missing from the text versions. That was obviously an inadvertent omission that I was able to quickly fix. But if you had already done some personal coding to adapt to the new text formats, be aware that there's now an extra data element.

Several others asked about how to import the new text versions into excel. The simplest way to import the data is to copy/paste the text into a spreadsheet, and then select Data->Text to Columns->Delimited to parse the data into columns. I did, however, add a new option to produce the text versions without headers, menus, and images, so that you can either copy all, or even read the resulting URL directly into the Excel file->open command. Admittedly, the URL is longer and more complex than before, since you can now apply your preferred filters to the exported data. But if you are capable of manipulating the data in a spreadsheet or any other text-importing program, then you should be able to figure out the new URL format.

Having said all this, the general comments on this new release have been overwhelmingly (although not universally) positive. So I think that, subject to fixing any lingering glitches, the format will remain as is for the balance of the season. Thanks to all who provided feedback over the past several weeks - positive or negative.

No comments:

Post a Comment