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…

Hooray for PythagenPuck

Back in November, around the quarter-mark of the NHL regular season, I wrote a piece looking at Expected Winning Percentages for each team, based on their Goals For/Goals Against ratio, using the PythagenPuck method as outlined in Alan Ryder's "Win Probabilities" article over at Hockey Analytics. Since we're approaching the end of the campaign, I thought it worth revisiting the two assertions I made back in November - that the Ottawa Senators were capable of getting back into the playoff race, and that the Boston Bruins were in danger of a freefall to the bottom of the standings.

Just to review, the basic idea behind win probability models like PythagenPuck is that over the course of a season, the Goals For and Goals Against numbers can be used to derive a team's winning percentage, within a a surprisingly narrow margin of error. For instance, if you only had GF/GA information, you could make a very good stab at projecting what the standings would look like. The w…

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…