Category Archives: Player Statistics

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

Posted by Steve Anderson on

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

Posted by Steve Anderson on

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)

 

IMG_20170827_212316943

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

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

Posted by Steve Anderson on

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)

 

les_etoiles_du_nord_c1[1]

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

Winter 2016-2017 Regular Season Update

Posted by Steve Anderson on

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

Posted by Steve Anderson on

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

Mid-Season Winter 2016-2017 Update II

Posted by Steve Anderson on

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

Spring and Summer 2016 Update – Part II

Posted by Steve Anderson on

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

End of Season Winter 2015-2016 Update IV

Posted by Steve Anderson on

AHAers,

It didn’t take too long to get the player stats updated. Enjoy!

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

Spread the word about AHA Hockey Historical Stats blog.

– Anderson #27

 

Player Statistics Spreadsheet – Version 1.0

Posted by Steve Anderson on

AHAers,

The long awaited Player Statistics Spreadsheet is here!

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

Please keep in mind that the stats are only as accurate as what was reported on the AHAHockey.com game page data. I’ve tried to explain with some of the ‘Oddities’ posts some of the peculiarities in the AHA data. I still have more ‘Oddities’ to post in the future.

You’ll be able to filter the data on any of the fields, but the main ones that will be helpful to you will be:

  • Player
  • Team
  • Division
  • Season
  • Season Type

You’ll also be able to sort the data by any of the above fields and the remaining fields:

Continue reading →