Fall League 2017, Fall Tournament 2017, + mid-season Winter Season 2017-2018

AHAers,

It’s been awhile since the last update, but it’s finally here. I always try to get this update out at around the mid-point of the winter season, but well, life and stuff. Most teams have played 12-14 games and the playoff picture is starting to shape up. I’ll do my best to do another update after regular season is done, but before playoffs hit us the first week in April.

I’ve updated the Fall League 2017, Fall Tournament 2017, and the Winter Season 2017-2018 as of about February 8th, 2018.

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

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

Legs feed the wolf AHAers,

– Anderson (#27, captain of LDN C3)

Summer 2017 Stats + 1st games of Fall League

AHAers,

A quick update that includes the remaining regular season games for Summer 2017, all of the Summer 2017 Playoff games, and Game 1 of all the Fall 2017 League Teams.

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

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

Les Etoiles du Nord Empire will be at the upcoming AHA Bloomington Fall Tournament, with all three teams (C1/C3/D1) participating. Come by and say hi. We’ll also be up at the AHA Duluth Fall Tournament later in October. Always a great time, see you at Grizzlies!

See you on the ice or at the arenas soon!

– Anderson (#27, captain of LDN C3)

 

… also got to show off the banner from summer (Level 5 Bassets)

Belated Update: Winter 2016-2017 Playoffs, Spring 2017, partial-Summer 2017 Stats

AHAers,

I meant to update stats before Summer League got started, but better late than never. Enjoy using it to scout some new players or relishing in past glory.

I’ve updated both the Team Standings and Player Statistics spreadsheet with the Winter 2016-2017 Playoff games, Spring League 2017, and Summer Games posted as of this evening (8/5/2017).

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

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

I’ll plan to do another update sometime after Summer Playoffs and before Winter Season begins.

Thanks for all those who have provided feedback. I’ve enjoyed conversing with fellow Hockey data geeks. See ya on the ice.

– Anderson (#27, captain of LDN C3)

 

Congrats to my C1 Du Nord brothers on hoisting the cup this spring! What a season!

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)

 

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:

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

Spring and Summer 2016 Update – Part I

Hey AHAers,

As promised, below is the updated Team Standings just in time for Fall Tournament and Winter Season scouting.

Update to the Team Standings Spreadsheet:

• Updated for the AHA Spring 2016 Season games
• Updated for the AHA Summer 2016 season games (regular season, beginner season, and playoffs)

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

I’ll have the Player Stats update this labor day weekend as well, but right now I’m off to Target Field to watch the Twins and grab some drinks.

– Anderson #27

End of Season Winter 2015-2016 Update III

Hey Guys,

Sorry it took so long to update the winter stats. Les Etoiles du Nord C3 had a long journey to the semi-finals in the playoffs and it took a bit to recover from the battle. Congrats to all the champions who got to hoist cups! AHA Winter 2015-16 Champion Pictures

Update to the Team Standings Spreadsheet:

• Updated the remaining Winter 2015-2016 games and repulled all previously pulled 2016 games to refresh any updates to the stats.

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

It’s getting late. Look for the player stats update this weekend. As always spread the word about AHA Hockey Historical Stats blog.

See you this summer,

– Anderson #27

 

 

Mid-Season Winter 2015-2016 Update

Update to the Team Standings Spreadsheet:

• Updated with the Winter 2015-2016 games that are currently posted to the AHA website

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

I’m working on updating the player stats as well and should have that soon.

Take it easy,

– Anderson (#27)