Saturday, 23 November 2013

Two team +/- logger

Spontaneous Projects is a chronicle of all of my projects, a reference for me, and a way to prevent others from making the same mistakes. 

Despite the number of draw backs of +/- (goals for - goals against while the player is on the ice) as a stat for hockey , it works as an indication of a players performance if it's looked at in comparison to the rest of the team, and as a long term average.

Given that I am usually trying to manage and coach both benches, recording this by hand is tricky.

I found a  few loggers spread across the interwebs, but they suffered from a few drawbacks: generally they had fixed, and small team sizes, and could only be used for a single team. So I decided to write my own for my win 8 tablet.

Full program and VS source:
https://www.dropbox.com/s/7chfwo0mlyv7a48/PM1.2.rar

Given that the primary purpose was a graphical front end it seemed easier to use VB, despite having no prior experience in the language. The original program was designed to be as simple as possible, just select the players on the ice, and hit the home or away goal.
Setting the Player names and numbers, follow the convention if you are looking to export the data

Main page, select the players on the ice, and choose home or away goal. Reset after goal deselects all players after a goal is scored. Save writes the text file with the current date. The check box above quit is required in order to exit, so that you can't exit unintentionally.

Output text file to be imported into Excel

Like many such projects once the basic functionality was working, it suffered from expanding scope, changing the team colours, adding the players separately to the main screen,  and exporting the data as a comma separated text file in such a way that it can be imported into Excel for further analysis




Still to be added is an import function, to make roster be editable ahead of time, other than that it works as required, and with full rosters set, and lines being at least partially set it is probably possible to log both teams at once. The 2 times I've tried I've struggled, but the hope is that I can hand it off to an assistant, who can worry solely about who is on the ice, rather than trying to watch and coach as well.


Now the interesting part, the code:





No comments:

Post a Comment