Skip to main content

Endorsements

Got any good books to recommend?

Greatest Hits from Working the Net:

Harlow Salon - one of the very best hair salons in Nashville TN.

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…

Where are my tickets, Mr. Holland?

While working on a piece about the 10th anniversary of the great Colorado/Detroit game at Joe Louis Arena, I caught myself reflecting on some of the great games I've had the fortune of seeing in Detroit during the 1990's, through a variety of means. Then another thing came to mind - when I'm in attendance, the Red Wings win. I'm on a huge personal winning streak here, so perhaps the Red Wings front office would want to bolster their chances during the upcoming playoffs and make sure I'm in the house for those critical games? I can make myself available...

June 4, 1995: Detroit takes Game 2 of the Western Conference Finals from Chicago, 3-2 (although the Hawks put one of the goalpost as the final horn sounds). Wow, has it been that long since the Blackhawks achieved anything? Ticket courtesy of a college buddy who had a spare.

October 13, 1995: The Wings pummel the Edmonton Oilers in their home opener, 9-0. After the painful Finals sweep against New Jersey the…