So I am stuck at work all weekend, and I figured I would play with Excel a little, and compile some of the Flames offensive stats. I used to do it on an old 286 when I was a kid, but we didn’t have the internet, so I would read the scoring totals from the newspaper into a tape deck and then play it back filling in each cell as I went along.
The internet makes it easier.
(This is a great way to learn about spreadsheet formulas BTW. Everything I know about excel I learned when I was 14 and filling in Flames scoring statistics)
This only deals with scoring. Defensive play, team play, toughness, plus minus are not included in any sense. Pure, hockey poolie scoring, nothing more.
Code:
Projected
Name GP G A Pts
Iginla 82 57 60 117
Langkow 80 30 42 72
Juice 82 32 37 70
Tanguay 82 17 52 70
Phaneuf 82 15 45 60
Lombo 82 17 25 42
Aucoin 80 12 27 40
Conroy 82 10 20 30
Nolan 80 15 10 25
Regehr 82 7 12 20
Bubba 70 2 12 15
Moss 60 2 10 12
Sarich 82 5 5 10
Nystrom 57 2 7 10
Yelle 70 2 5 7
Sarge 47 0 7 7
Boyd 27 5 2 7
Nilson 57 5 0 5
Smith 57 0 2 2
Godard 72 2 0 2
Hale 47 0 2 2
Primeau 15 0 0 0
Ramholt 2 0 0 0
Here are the projected stats for the Calgary Flames if each player continues their current pace and number of games played. I threw in a couple nicknames just to throw off noobs, thieves, and Soiler fans (and cause I couldn’t get the columns to line up right). This is based on the scoring totals of the Flames prior to the Stl game on Sunday December 16, 2007.
Interesting points
• Iginla obviously having his best statistical year ever. So much for the folks who say he only turns it up for an impending contract year, or that past the age of 30 you don’t set career highs anymore. I hope he is our version of Joe Sakic and pours in points until he retires.
• Daymond Langkow apparently looking to add another 30 goal season to his resume. Mr. Consistency does it again. We really need to resign this guy.
• Lombardi’s totals currently roughly comparable to last season. I would have expected more of an offensive breakout from him after watching the World Championship, but the coaching staff has been using him sparingly in the top 6.
Code:
Pace Career
Name GP G A Pts Name GP G A Pts
Iginla 82 57 60 117 Iginla 82 52 55 96
Langkow 82 31 44 74 Langkow 82 33 44 77
Juice 82 32 37 70 Juice 81 34 43 77
Tanguay 82 17 52 70 Tanguay 82 29 59 81
Phaneuf 82 15 45 60 Phaneuf 82 20 33 50
Lombo 82 17 25 42 Lombo 81 20 26 46
Aucoin 82 13 28 41 Aucoin 81 23 31 44
Conroy 82 10 20 30 Conroy 81 27 48 75
Nolan 82 15 10 26 Nolan 78 44 43 84
Regehr 82 7 12 20 Regehr 82 6 20 26
Bubba 82 3 15 18 Bubba 79 7 25 28
Moss 82 3 14 17 Moss 41 10 8 18
Sarich 82 5 5 10 Sarich 82 5 16 19
Nystrom 82 4 11 14 Nystrom 23 1 3 4
Yelle 82 3 6 9 Yelle 82 13 17 27
Sarge 82 0 13 13 Sarge 79 5 16 19
Boyd 82 15 7 22 Boyd 11 2 1 3
Nilson 82 7 0 7 Nilson 82 15 24 36
Smith 82 0 4 4 Smith 80 9 15 24
Godard 82 3 0 3 Godard 57 2 2 4
Hale 82 0 4 4 Hale 65 0 4 4
Primeau 82 0 0 0 Primeau 72 9 20 29
Ramholt 82 0 0 0 Ramholt 1 0 0 0
Here is the scoring pace each player is on if they were to play a full season. Obviously some guys are still able to do that, others have already missed a few games. But ultimately if you say “scoring at a 20 goal pace” you typically mean, if the player played every game.
Finally you throw in the career years. The point total isn’t the sum of the goal and assist totals in every case – it is the most points the player ever achieved in a given season. Bolded players are scoring at a pace exceeding their career years.
Interesting points
• The good news is that we have 3 players on pace to score 30 goals or more. The bad news is that we only have 3 players on pace to score 18 goals or more – the same guys. Our lack of depth at secondary scoring is pretty clearly exposed.
• Boyd is playing at a 15 goal pace – the equivalent of Owen Nolan, and only slightly behind Lombardi and Tanguay. His scoring pace is also higher than Nystrom, Conroy and Moss despite 4th line duty. That says “talent” to me. He isn’t really ready for extensive NHL duty yet, but he may emerge as an impact player in the next few years.
• Nolan has never played 80 games in a season.
• Robyn Regehr is on pace to surpass his career high of 6 goals in a season, but not his pts high of 26.
• Langkow and Huselius are coming off career years – so it is nice to see them maintain their scoring pace. Interesting that Juice is considered an offensive wizard, but Langkow is the slightly more productive player. Perhaps they do care HOW you score em!
• Alex Tanguay has never had a 30 goal season.
• Adrian Aucoin has never had more than 44 points in a season. For a guy who some suggested would be injury prone and too old to contribute… well he’s on pace to play 80 games and put up 41 points.
• For all the talk of the game moving past Yelle, last season he set a career PPG, and with 3 more points would have tied his all time high in points – despite playing only 56 games. This says to me that his current struggles are a product of Keenan limiting his ice time more than his age. That said, last season was last season, and this season he has been pretty bad in his 5 mins a game. He’s my favorite player, so it bothers me to see him not contributing.
• Phaneuf’s goalscoring has dipped, and that makes sense since he doesn’t seem to unload the cannon as often on the PP. But he is on pace to set career highs in both assists and points. The development of our monster continues.