How much does your favorite team travel? Check the NHL Super Schedule

With the release of the 2009-10 NHL Regular Season schedule, a favorite summer pasttime of hockey fans (and some team officials) in many cities is about to commence; whining about the burdens of travel, and how the NHL office has the fix in to screw team XYZ out of a successful campaign. Either there are too many long trips, or too many short trips, or too many time zone changes... it seems like just about any aspect of the schedule is picked on as especially painful.

Over the course of the season, however, which teams truly travel more than the others, and which ones play the most games on back-to-back nights? For the answer to those and other questions, I'd like to share with you the 2009-10 NHL Super Schedule, a freely available spreadsheet that I publish, which includes travel distances between each NHL game, days elapsed since the previous game, etc.

Follow after the jump for a look at the spreadsheet, and an overview of travel and back-to-back totals by team...

For discounted tickets to any Preds home game, you can use the Nashville Predators coupon code available for OTF readers.

I'll put the summary right up here at the top. We've got year-to-year comparisons of total travel miles (measured as the crow files from one NHL arena to the next), and the number of back-to-back games that are on each team's schedule. Teams with low mileage and back-to-backs are shaded green, and the harsher numbers are shaded pink:

UPDATE: Corrections made to some teams (Vancouver, Washington, etc.) which have road games on both sides of the Olympic break. Also corrected for teams that went to Europe last year, but those travel miles carried over into the first run of this spreadsheet.

A few notes to consider:

• The NHL schedule makers should be given credit for not increasing the number of back-to-backs, given the Olympic Break which has to be wedged into the same overall timetable. How'd they do this? Well, there are many more games on the total schedule which have one day off in between (1,359 in the upcoming season, as opposed to 1,250 last year). Just as games after 1 day off have gone up, games after 2, 3, or 4 days off have gone down by a similar amount (682 to 581). So basically the NHL took those longer breaks and compressed down quite a bit, while avoiding a rash of back-to-backs. Kudos to them on that score.
• We also see a bit less variance in the number of back-to-backs. Last season, Colorado had just 8 while Columbus had 20, while this year the gap runs from 11 to 19.
• In terms of mileage, it looks like Mike Gillis was successful in lobbying the NHL for relief for his Vancouver Canucks, as they saw a significant reduction in their travel mileage.

The obvious question then is, which team has the hardest or easiest road to travel in the 2009-10 Regular Season? Is it Calgary based on pure mileage, or Chicago which has plenty of flying time, but also the most back-to-backs?

At least now, if you're going to complain about your favorite team's schedule, at least you can do so in an informed manner!

Below is a brief sample of what the spreadsheet looks like. You can access the 2009-10 Google Spreadsheet on your own and download a copy to work with as you wish. There's also the 2008-9 Super Schedule, and the 2007-8 Super Schedule, also via Google Docs, if you wish to run year-to-year comparisons. When you follow the links, you'll get all the columns, which include mileage along with strength of schedule information (various stats for the opponent in a given game). 

Also, if you have any questions, feel free to ask in the comments, email me (the.forechecker @ gmail.com) or catch me on Twitter (@Forechecker).