Kukla's Korner

Updating the NHL Super Schedule

My NHL Super Schedule has been a hot topic this week, with the main point of interest being the total travel miles that each NHL team has to endure over the course of an NHL season, as well as the number of back-to-back pairs of games, which varies from the league-high Columbus Blue Jackets (20!) to the Colorado Avalanche (only 8 such contests).

In light of last night’s interview on CHQR radio in Calgary (I hope to post the MP3 later today), a couple new questions came up, so I’ve updated the publicly available Google Spreadsheet to freshen some of the detailed Strength of Opposition data as well as add some new columns…

Columns M through T (Opp Point % through Opp Shots Against/Game), which relate to the opponent a given team is playing that night, have been updated with current data, so you can run your own analysis to determine which teams have the toughest or easiest set of games heading down the stretch.  There are also two new additions are way out there to the right, which are detailed below.

Click here to view the entire spreadsheet.

Column V (“Single Trip?”) was prompted by a question from Mark Stephen, as to how often teams have to make trips for a single game, whether at home or on the road. Those are the situations that really rack up the travel miles, as the alternative is to combine multiple road games on a single journey, such as the typical swings that many Eastern Conference teams will take, hitting Calgary/Edmonton/Vancouver or Los Angeles/Anaheim/San Jose.  Simply look count up the “TRUE” values for your favorite team to see how often those occur (the first and last games of the season, if a single game at home, don’t count).

Column W (“New Time Zone?”) is another TRUE/FALSE field, which simply notes where a team has changed time zones to play that given game; coaches often bring up this aspect of travel as being particularly troublesome, especially for Columbus and Detroit which are the only Eastern Time Zone teams in the Western Conference.

So head over to the Google Spreadsheet, feel free to export it to your own favorite program (Excel, Open Office, etc.) and blast away to your heart’s content. If you have any questions, or additional fields you’d like to see added, please drop a comment below and I’ll see what I can do.

Filed in: NHL Statistical Analysis, | On the Forecheck | Permalink


Be the first to comment.

Add a Comment

Please limit embedded image or media size to 575 pixels wide.

Add your own avatar by joining Kukla's Korner, or logging in and uploading one in your member control panel.

Captchas bug you? Join KK or log in and you won't have to bother.

Commenting is not available in this channel entry.