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

Leave a Comment