AHA Data Oddities #7 & #8

AHAers,

Glad everyone is enjoying the new Player Statistics spreadsheet. Over 300 people have downloaded it in just over 24 hours! Thanks for all the positive feedback as well.

Below I have some more oddities to share with you. Both examples surround subgoalies, which I have deemed as the “bane of my existence.” Subgoalie names appear to be manually typed in by the score keepers and don’t always follow the pattern of “#00 J. Doe”. Typos, misspellings, wrong names and odd formatting can really degrade the quality of the data. It was to the point where I thought it might be cleaner to just default every Sub Goalie’s name to “Sub Goalie,” but you would miss a lot of information. In the end, it was best to convert it to the “Doe, J.” format as best I can, and leave any typos alone. When searching for players, goalies especially, it’s best to be vague with the name to try to capture all of their stats.

Player Statistics Spreadsheet – Version 1.0

AHAers,

The long awaited Player Statistics Spreadsheet is here!

Excel Spreadsheet: AHA – Historical Stats – Player Statistics – 2015.11.02.xlsm

Please keep in mind that the stats are only as accurate as what was reported on the AHAHockey.com game page data. I’ve tried to explain with some of the ‘Oddities’ posts some of the peculiarities in the AHA data. I still have more ‘Oddities’ to post in the future.

You’ll be able to filter the data on any of the fields, but the main ones that will be helpful to you will be:

• Player
• Team
• Division
• Season
• Season Type

You’ll also be able to sort the data by any of the above fields and the remaining fields:

AHA Data Oddities #5 & #6

AHAers,

Below are some of the more head scratching oddities that I’ve observed in the AHA game data. These focus on Player-side stats, specifically some odd goalie stats.