Monthly Archives: September 2015

Team Standings Spreadsheet – Update

Posted by Steve Anderson on

Quick update to the Team Standings Spreadsheet:

  • Modified the sort buttons so they stay on screen when scrolling

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

In the upper right corner, you can click on ‘Team Standings’ to get the latest version of the spreadsheet. Over 100 AHA-ers have checked out the blog in less than two days, keep spreading it around.

Thanks for the feedback and positive response,

– Anderson (#27)

Team Standings Spreadsheet – Version 1.0

Posted by Steve Anderson on

Please find below the first version of the Team Standings Spreadsheet for the AHA Hockey Historical Statistics.

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

You’ll be able to filter the data by:

  • Seasons
  • Season Types
  • Divisions
  • Teams

You’ll be able to sort the data by:

  • Team Name
  • Games Played [GP]
  • Wins [W]
  • Loses [L]
  • Ties [T]
  • Overtime Losses [OTL]
  • Points [Pts]
  • Shots For [SF]
  • Shots Against [SA]
  • Goals For [GF]
  • Goals Against [GA]
  • Penalty Minutes [PIMS]
  • Average Shots For for Goal For [SF/GF]
  • Average Shots Against for Goal Against [SA/GA]
  • Goals For per Game [GF/G]
  • Goals Against per Game [GA/G]
  • Goals For to Goals Against Ratio [GF/GA]
  • Penalty Minutes per Game [PIMS/G]

Give it a try, give me some feedback. I’ll be working on a similar spreadsheet for player-level stats in the coming weeks.

– Anderson (#27)

The Plan

Posted by Steve Anderson on

The Game Data: AHAHockey.com only has game data from October 27th, 2011 to present. The league has stated they do have all of game data for the league, which I would love to get my hands on, but for now this project will only entail game data from the 2011-2012 winter season to present. This includes all AHA leagues (Winter/Spring/Summer/Fall) and Tournaments (Fall) that AHA posts game data onto their website. I have been able to pull all of the game data that AHA hosts on the game results pages for each game. This includes Goals, Penalties, Shots, Goalie, and Attendance data for almost 7,000 AHA games and counting.

The AHA Hockey Community: I am hoping that this project will be useful for not only myself and Les Étoiles du Nord, but to the AHA hockey community at large. I encourage everyone to pass the word along within your team and within your AHA hockey network. It’d be awesome to have people from A division to D2 division using this. When you pass the word along, I recommend providing them a link to this blog (https://AHAHistoricStats.wordpress.com) so they can get all updates. The only thing I ask is you give Les Étoiles du Nord and myself credit.

Please contact me with feedback. If there’s a correction or glitch, let me know. If you have questions or recommendations, that’s cool too. Post a comment on the blog or simply e-mail me at SteveReedAnderson@Gmail.com.

Phase One: This weekend, I hope to release the first fruits of my labor. It will be a team standings spreadsheet that will allow anyone to look up team stats from any team that has played in AHA. You’ll be able to Continue reading →

Welcome!

Posted by Steve Anderson on

Welcome fellow AHA players and teams,

About Du Nord: I joined AHA through the Beginner Program during the 2013-2014 Winter Season with my friend Mark Gilmer. Together with our new hockey teammates in beginner we created Les Étoiles du Nord. This translates into ‘The Stars of the North,’ but some translations convert to ‘The French North Stars,’ or ‘The French Toilets.’ All of them work for us.

Like most beginner teams, we moved up to D2 the following year (2014-2015 Winter Season). At the same time, some friends of the team wanted in on the action and joined the 2014-2015 Winter Season’s Beginner Program. Through this relationship, an ‘affiliate’ Du Nord team was created. Going into the 2015-2016 Winter Season, the two Du Nord teams have merged and have formed a C3 and a D2 team. We’re looking forward to the coming season and hoping to expand our ‘Empire’ and have additional teams in the future.

About Myself: Hockey was the one sport I never tried growing up, but always wanted to. I worked part-time for the Wild during and after college (2006-2013) and became a bigger fan of the sport. When Gilmer and I heard about AHA through a coworker who played with the Anchors during their beginner season, we were sold. Over the last two years, I’ve become a ‘hockey rube.’ I typically skate twice a week through JMS at Apple Valley/Burnsville plus whatever AHA league is going on.

I’m a self-described ‘data/spreadsheet dork.’ I went to the U of MN and majored in econ with a minor in math. I’ve always enjoyed numbers and problem solving. I currently lead a Financial Analytics team in the pharmaceuticals industry where I get to play with data all day long. The AHA Historical Stats project has been a side-project that has been a fun challenge and has gotten me to learn new excel skills like VBA programming.

About the Project: The first two years I served as captain for Du Nord and got to sit in on the AHA captains’ meetings. It seemed like almost every meeting, someone asked the league about having historical stats. The league would recognize the demand for it, say it’s a Continue reading →