Mid-Season Winter 2016-2017 Update II

AHAers,

It didn’t take too long to update the Player Statistics spreadsheet. Enjoy using it to scout your opponents in the second half of the winter season and to make that final push to lock-in a playoff spot. AHA Captain’s meeting is next Tuesday, so we should know the cutoff for the playoffs and the details.

Here’s what’s been updated in the Player Statistics spreadsheet:

• Updated for the AHA Fall League 2016 Season games
• Updated for the AHA Fall Tournament 2016 Games
• Updated for the AHA Winter 2016-2017 season games up through February 3rd posted games

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

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

Thanks,

– Anderson #27

Model Updates (Team Standings Spreadsheet)

AHA Data Geeks,

You may have noticed some new options in the latest version of the model. I ended up playing around with things and I am excited to show off some of the new updates. The new model now allows you to easily compare your team to every team in AHA no matter what division or what season. For example, filter on ‘Winter Season 2016/2017’ and turn ‘off’ divisions and you can then sort by various stats to see the leaders in all of AHA so far this Winter Season:

• Least Shots For / Goals For (i.e. Accuracy of Shots or it takes X shots to get 1 Goal)
  • Summit (A Division) with 5.22 SA/GF
• Most Shots Allowed / Goals Allowed (i.e. Accuracy of Stopping Shots or it takes X shots to allow 1 Goal)
  • Saints (C1 Division) with 14.00 SA/GA
• Most Shots For / Game
  • Outlaws (B1 Division) with 42.33 SF/G
• Least Shots Allowed / Game
  • Troopers (D2 Division) with 20.00 SA/G
• Most Goals For / Game
  • Summit (A Division) with 7.09 GF/G
• Least Goals Against / Game
  • Spartans (C3 Division) with 2.08 GA/G
• Most Goals For / Goals Against (i.e. You get X goals for every 1 goal you allow)
  • Moose (D2 Division) with 3.04 GF/GA
• Most PIMs / Game
  • Summit (A Division) with 13.27 PIMs/G 
• Least PIMs / Game
  • Polar Bears (D2 Division) and Moose (D2 Division) both with 2.18 PIMs/G

 

Update Notes:

• Added ability to turn on/off Sub-Division breakouts (e.g. East/West/South/North)
• Added ability to turn on/off Division breakouts (e.g. A/B1/B2/B3/C1/C2/C3/D1/D2)
• Added ability to turn on/off Seasons (e.g. Winter 2014-2015/Winter 2015-2016)
• Updated ‘Clear Filters’ button to also reset the new breakout buttons
• When Divisions or Seasons breakouts are turned off, Team Name now displays the division and/or season
• Added League (e.g. Spring/Summer/Fall/Winter) filter
• Fixed ‘Print Area’ glitch so there’s not blank pages at end

Mid-Season Winter 2016-2017 Update I

Hey AHAers,

A bit later than I planned, but I’ve finally got around to updating the Team Standings Spreadsheet. There’s some new stuff in the Team Standings Spreadsheet. I’ll post about it tomorrow, but in the meantime, I hope you enjoy!

Update to the Team Standings Spreadsheet:

• Updated for the AHA Fall League 2016 Season games
• Updated for the AHA Fall Tournament 2016 Games
• Updated for the AHA Winter 2016-2017 season games up through February 3rd posted games

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

I’ll update the Player Stats model tomorrow, or in the next week at the latest.

Stay tuned and spread the word,

– Anderson #27