Winter 2016-2017 Regular Season Update

AHAers,

I’ve updated both the Team Standings and Player Statistics spreadsheet with all Winter Season 2016-2017 regular season games. Just in time for the playoffs next week!

Excel Spreadsheet: AHA – Historical Stats – Team Standings – 2017.03.30.xlsm

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

Enjoy the updated sheets, I’ll make a final Winter Season update after the playoffs are done.

All three (C1/C3/D2) Les Etoiles du Nord teams made the playoffs. Show your appreciation for the stats and go root on the green-black-white and gold next week!

Good luck to all teams, should be a fun week,

– Anderson (#27, captain of LDN C3)

 

Player Statistics Update

AHAers,

I got distracted this weekend working on some new Macros to automate the process of updated the Player Statistics sheet and exporting it. I got it in a good place now, and I’ve learned (I think) some more VBA programming stuff. Anyways, without further ado, the updated Player Statistics spreadsheet:

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

As with the Team Standings spreadsheet, these stats are updated to games posted as of March 18th, 2017. It looks like the last game is March 29th, so I’ll probably be able to update both spreadsheets with all of the regular season games finished and posted that weekend… just in time to do some scouting before the playoffs start the next week.

Please provide any feedback (Ideas/Bugs/Etc..) and continue spreading the word within the AHA hockey community.

Thanks,

– Anderson #27

Big Model Updates (Team Standings Spreadsheet)

AHA Data Geeks,

C3 West is done playing games and Les Etoiles du Nord C3 has an amazing 24-day break until Game 1 of playoffs. In other words, I got nothing better to do that open up Excel this weekend.

I’ve updated the Team Standings to games posted as of March 18th, 2017. I plan on updating one more time right before playoffs once all teams have finished their regular season games.

Excel Spreadsheet: AHA – Historical Stats – Team Standings – 2017.03.18.xlsm

More importantly, I have made the following updates and added the following new features to the model: