Skip to main content

A deeper look at the NHL schedule

Last season the topic of epic NHL road travels came up, with perhaps the worst being a home-and-home series between St. Louis and Colorado which had the teams playing one night in Denver, then traveling some 850 miles to play again the next night in St. Louis. Rather than dig through the schedule line by line and look for similar instances this season, I thought I'd bring the wonderful power of spreadsheets to bear on the problem.

And then I thought, the heck with just distance traveled, let's toss some other information in there as well, and open it up so any out there who wants to examine different aspects of the upcoming NHL schedule can do so on their own. So I'd like to present to you my "NHL Super Schedule", published online over at Google Spreadsheets and free for anyone to download and utilize how they see fit.

It may choke your browser to work with it on Google, but I believe you can easily save it off into Excel or Open Office as you prefer.

So what's in there? Let's walk through the columns I've set up:

Team: The team's 3 letter abbreviation (i.e. ANA, BUF)
Game: The game number within that team's 82-game schedule
Date: Day of game
Visitor: Visiting team's name
Home: Home team's name
Time: Time of game, all in Eastern Time
Days Gap: Days since that team's previous game (i.e. back-to-back = 1)
Distance: Distance in miles (as the crow flies) from the previous game. All Game 1's set to 0. All values obtained from a Google Maps mashup posted here.
Division: Division of the team in question
Opponent: Opponent's 3 letter abbreviation
Opp Win%: Opponent's win percentage from the 2006-7 regular season
Opp G/G: Opponent's Goals Per Game from 2006-7
Opp GA/G: Opponent's Goals Allowed Per Game from 2006-7
Opp 5-5 F/A: Opponent's 5-on-5 Goals For/Against Ratio from 2006-7
Opp PP%: Opponent's Power Play % from 2006-7
Opp PK%: Opponent's Penalty Kill % from 2006-7
Opp Shts/G: Opponent's Shots Per Game from 2006-7
Opp SA/G: Opponent's Shots Allowed Per Game from 2006-7

So how can you use this? Checking out who has the furthest to travel for games on consecutive nights is a start. That honor goes to the Vancouver Canucks, who play at Edmonton on November 20, then have to fly 1,090 miles to play the Wild in Minnesota the next evening. You can summarize and sort the teams based on greatest and least travel. Who's going to face the toughest defensive teams on the road this year? Whose goalie is going to see the most rubber flying his way? How do the divisions compare?

I don't know the answer to many of these questions (yet). But I've done the work in putting this spreadsheet together, and now you can look for them yourself, and probably come up with more interesting questions to ask as well. Enjoy, and by all means leave your suggestions for additional columns. I plan on beefing this up considerably over the course of the season.

Popular posts from this blog

How I'm Trying To Make Money Sports Blogging

To kick off this series of articles general sports-blogging articles here at OTF Classic, I think it's best to start with a comment that Brad left here last week, after I shared my goals for 2012, which include specific revenue targets:
I considered diving into the world of internet marketing myself, but I felt that my friends would hate me for bugging them about stuff. I mean, it's pretty low-risk high-reward, so it's tempting. I wouldn't mind reading about tips on how to maximize impact of blogging in general to make it a legitimate income source. Trying to make money at sports blogging can be a very touchy subject - for the vast majority of us, this is an activity we pursue to both exercise our creativity and share our love of the game, whether it's hockey, football, badminton, whatever, with fellow fans. Mixing that personal conversation with a commercial message can turn people off, especially if it becomes too intrusive for the reader.

It's not unreasonabl…

Canadian Baloney, starring James Mirtle

A tireless refrain from the Canadian media is that Nashville is an absolute failure as a hockey market, and failing to move the team north of the border is an exercise in folly by the NHL.

Our latest exhibit comes from James Mirtle, usually one of the more thoughtful hockey bloggers extant:
But Nashville, quite simply, has proven it cannot sustain an NHL hockey team. Even with the lowest ticket prices in the entire league (I know: I've looked into flying there for a game or two) and a ridiculously forgiving arena lease, the team has had attendance issues despite having one of the best records in the league.

It's not a matter of Canadians not wanting teams in the southern U.S.; I've argued time and again in favour of teams like Dallas and Tampa Bay that have supported their teams and really brought something to the table in terms of bringing news fans and new energy to the game. That's a good thing.

The Predators, however, are not that, not in the beginning and certainly no…

Get Your NHL Super Schedule 2008-9 Right Here!

Click here for the 2009-10 NHL Super Schedule, at my new site,!

The NHL announced the 2008-9 Regular Season schedule today, so of course, it's time right here to publish my very own NHL Super Schedule 2008-9 as well.

For those unfamiliar with what I did last year, the NHL Super Schedule is a spreadsheet that I put together and make publicly available via Google Documents*. It includes an entry for each game in each team's 82-game regular season schedule, with additional information such as how far that team has had to travel since its last game, how many days have passed since that previous game, and various statistics relative to the opponent that evening, such as 2007-8 Winning Percentage, Goals Per Game, Goals Against Per Game, etc. For example, you can total the distance that each team will travel during the upcoming season, or find who plays the most back-to-back games. Check out which team faces the toughest opposing offenses, or which power plays…