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)

 

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:

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

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 II

AHAers,

I’m back from Target Field, and I have finished updating the Player Statistics spreadsheet.

Update to the Player Statistics 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 – Player Statistics – 2016.09.04.xlsm

See you guys at Bloomington Ice Gardens at the end of the month.

– 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