Tag Archives: Microsoft Excel

Vegas Golden Knights 2018-19 Season Projections

It’s forecasting season, well, actually it’s the regular season and I’m just a little behind, but until I pointed that out, you didn’t know I was behind on my little passion project here, did you?

I know I wrote “[i]n the coming days I’ll reveal what teams I’ll be forecasting/tracking all season long, so stay tuned because it’s about to get messier than ever before and I’m up for the challenge,” in my Boston Bruins 2018-19 forecast, but life and the fact that I’m moving all my data into a new format has slowed my turnaround for the time being.

Nevertheless, my Vegas Golden Knights forecast for 2018-19 is here and let’s pretend the first week of the regular season hasn’t already happened or something.

Additionally, if you’re wondering what other teams I’m preparing to post (before we get too far into the first quarter of the season) they are the Carolina Hurricanes and Columbus Blue Jackets.

I always keep tabs on the Bruins every year because I grew up a Boston fan and I decided to track Vegas last season because there hadn’t been nearly as much hype surrounding an expansion team since Columbus and the Minnesota Wild in 2000. Additionally, I’ve previously tracked the Arizona Coyotes simply because they follow us on Twitter (and I’ll get back around to them hopefully before season’s end, if you’re interested).

But I’m adding Carolina and Columbus to my forecast portfolio this season because 1) the Hurricanes are supposed to be better than last season, plus they have some exciting youth in the lineup and 2) a lot of Blue Jackets fans are also fans of our brand around here, so shouts 5th Liners.

Please be patient on the timeline for when I’ll get my Hurricanes and Blue Jackets forecasts posted– it’ll be by the end of the month for sure.

Anyway, on with the Golden Knights, shall we?


Vegas is coming off of their inaugural season having finished 1st in the Pacific Division with 109 points and a 51-24-7 record under head coach Gerard Gallant. Not only did they finish at the top of their division in their first season, but they did so with over 100 points and a 50-plus win season.

Oh yeah and they played the Washington Capitals in the 2018 Stanley Cup Final.

Despite the loss in five games to Washington, the Golden Knights were and still are well ahead of owner Bill Foley’s “Cup in three [seasons]” masterplan– what with General Manager George McPhee‘s offseason additions of Paul Stastny and Max Pacioretty and everything.

This year, of course, the competition has gotten a lot tougher. There are expectations now when opponents play the Golden Knights.

Gallant and his Vegas lineup are going to have to get more creative than ever before in franchise history to avoid the hangover of a Stanley Cup Final appearance run and to avoid getting too predictable.

Things are different now. They’re no longer the new kids on the block. They’re the 2018 Western Conference champions and a team to beat.

As always, I’d like to remind you my degree is in communication– not math– therefore anything that looks wrong is either adjusted with a little gut-feeling and/or Microsoft Excel’s fault. My expertise resides in the written, spoken and nonverbal language of communicating– not numbers on a spreadsheet.

These forecasted stats are to be seen as an utopian perspective, as though nothing bad could happen this season at any point to any player– where every player at least lives up to their forecast and then some.

Some will pan out and some will fall flat. It’s a suggested outcome for a sport that’s played on ice in a highly unpredictable collective environment of action and sheer puck luck.

vegas_golden_knights_logo

Vegas Golden Knights Forecast Through 0 Games (82 Games Remaining)

This slideshow requires JavaScript.

After a breakout 78-point season (43 goals, 35 assists) for William Karlsson, the Golden Knights number-one center is prime for a respectable 41-point season as part of the natural regression of the game– unless Karlsson is truly an outlier, like he was coming from Columbus to Vegas last season.

Meanwhile, Reilly Smith (19-27–46 expected totals) and Jonathan Marchessault (28-35–63 expected totals) bolster the Golden Knights first line with respectable performances of their own, while the point spread has really been shared with the second line.

Newcomers Paul Stastny (22-43–65 expected totals) and Max Pacioretty (33-30–63 expected totals) are set to become the key contributors to the fiery Vegas offense in their first season with the club.

The Golden Knights top-six core of forwards is deeper than last season, whereas the majority of their offense was reliant upon Marchessault, Karlsson and Smith. This year there’s more emphasis on Alex Tuch and Erik Haula inside the top-nine.

On defense, Gallant’s crew will have to do without Nate Schmidt for the first 20 games of the season while Schmidt serves a suspension for a performance enhancing drug.

Luckily, Brad Hunt, Colin Miller and Shea Theodore are prime for an uptick in time-on-ice and production, with Hunt and Miller expected to reach the 30-point plateau, while offseason addition, Nick Holden should see a pleasant rebound from his 17 points split between the Bruins and New York Rangers last season to a 25-point effort in 2018-19 with Vegas, provided he can remain in the top-six on the depth chart.

Upon Schmidt’s return, he should still have 4-23–27 totals from the blue line, which is not great like last season’s 5-31–36 totals, but not terrible for a top-four defender.

In goal, Marc-Andre Fleury is expected to return to Earth from his superhuman season last year (a 2.24 goals against average and .927 save percentage in 46 games) to a 2.49 GAA and .913 SV% in 2018-19. As the Golden Knights starter continues to get older, limiting his workload to keep him fresher for the postseason is the way to go.

Granted, Fleury’s playing time was limited last season due to a concussion, he still went on to have solid regular season numbers and an impeccable 2018 Stanley Cup Playoff run up until the Stanley Cup Final.

Meanwhile, Malcolm Subban‘s 2.68 GAA and .910 SV% in 22 games played look to be improved upon to a 2.65 GAA and .911 SV% in somewhere around 30 appearances as the backup netminder for Vegas.

As always, we’ll get more into the goalies once the team has played through a quarter of the season.

Numbers Game: March to the Playoffs

First of all, it’s March, which means it’s officially the best month of the year, but not for any of the reasons you’re thinking. College basketball can stay on the back burner– especially when there’s playoff hockey to look forward to next month when, oh yeah, that NCAA championship game actually occurs.

Save your “March is the worst month of the year” takes for the next person in line, thanks.

Anyway, at this point in the season it’s worth noting that the trade deadline has come and passed. While acquisitions like Rick Nash for the Boston Bruins, Derick Brassard for the Pittsburgh Penguins, Tomas Tatar for the Vegas Golden Knights and Paul Stastny for the Winnipeg Jets will certainly impact their teams, the following projected standings are merely an educated guess at how things should pan out.

There are simply too many variables that Microsoft Excel cannot account for, namely injuries, roster changes and well, whether or not a player woke up on the right side of the bed that day.

To that end, some projected points totals had a little Gut Feeling 2.0 added to them. In other words, the Toronto Maple Leafs are not going to end up with 130 or 131 points like a couple of models showed– there’s simply not enough games remaining for them to almost match an NHL record.

Therefore, more realistic measures have been added for some teams to account for “reality”.

Some teams like the Chicago Blackhawks, for instance, had a little win-percentage on the season taken into account for their 19 remaining games on the season– and then reflected in the total number of points they should earn.

As with all stats and analytics, try not to get too bogged down on one or another. A holistic viewpoint goes much further than trying to survive on heart and grit alone.

Especially in today’s NHL, where speed and skill are more present than ever before.

With that, here’s a glance at how the standings should shake out for all 31 NHL clubs based on their performances through February 28, 2018.

As always, my degree is in communication, not math. In other words, throw everything mentioned above out the window, strap yourself in and good luck surviving the adrenaline rush that is the Stanley Cup Playoffs.

Oh, your team’s not going to make it, you say?

My condolences, Ottawa Senators, Buffalo Sabres, New York Rangers, Carolina Hurricanes, Blackhawks and Arizona Coyotes fans. Next year is totally your year.

Maybe.

2017-2018 Projected Standings after Five Months

Eastern Conference

Atlantic Division

  1. y-Tampa Bay Lightning, 106 points (64 GP so far)
  2. x-Boston Bruins, 105 points (61 GP so far)
  3. x-Toronto Maple Leafs, 105 points (66 GP so far)
  4. Montreal Canadiens, 78 points (63 GP so far)
  5. Detroit Red Wings, 75 points (63 GP so far)
  6. Florida Panthers, 75 points (60 GP so far)
  7. Buffalo Sabres, 68 points (64 GP so far)
  8. Ottawa Senators, 65 points (62 GP so far)

The Atlantic Division was already determined in December. Nothing should surprise anyone, except for how close it should be coming down the wire for first place in the division.

It might seem crazy considering the Tampa Bay Lightning really bolstered their defense with Ryan McDonagh at the trade deadline, but Boston and Toronto have as much speed and offense to remain in the hunt for that little “Y” next to their names down the stretch. Plus it helps that the Lightning, Bruins and Maple Leafs aren’t playing each other every night, so that has to factor in their somehow.

Between 4th and 6th in the division it’s anyone’s game. The Montreal Canadiens, Detroit Red Wings and Florida Panthers are all teetering on the edge of either a rebuild or just a few steps away from a re-tool-on-the-fly.

Neither of them are inherently “ideal”, but they can’t do anything else to compete with Tampa, Boston and Toronto.

It’s worth noting that the Buffalo Sabres will barely climb out of the basement of the division this year. And that’s without Jack Eichel (fractured ankle).

Simply put, the Ottawa Senators are beyond bad.

Metropolitan Division

  1. z-Pittsburgh Penguins, 108 points (64 GP so far)
  2. x-Philadelphia Flyers, 99 points (63 GP so far)
  3. x-New Jersey Devils, 97 points (63 GP so far)
  4. wc1-Columbus Blue Jackets, 96 points (63 GP so far)
  5. wc2-Washington Capitals, 94 points (64 GP so far)
  6. New York Islanders, 87 points (64 GP so far)
  7. Carolina Hurricanes, 75 points (63 GP so far)
  8. New York Rangers, 72 points (64 GP so far)

After much turbulence leading up to this month in the Metropolitan Division, it seems by the end of the month, we’ll have a clear picture of who’s really a contender, who’s making a Second Round exit and who’s just pretending to be on the ice when they’re actually sending out some pretty high-tech holograms on the ice.

In other words, the Pittsburgh Penguins are suited for a three-peat as long as Matt Murray can stay healthy. Even still, they’re beginning to peak at the right time as they have done every year with Mike Sullivan behind the bench.

But who’s that neighbor of theirs in Pennsylvania? They might have to re-grease some poles in Philadelphia, because the Flyers are surging right now and it should carry them into decent playoff position.

The New Jersey Devils, Columbus Blue Jackets and Washington Capitals all remain competitive, but sadly fall victim to First or Second Round exits simply because have you seen the rest of the Eastern Conference? Yeah, I thought so too.

One of these years if the Carolina Hurricanes look to actually spend a little more money they’ll be able to take their money-puck approach back to the postseason for the first time since 2009, but this year is not that year. They didn’t do anything at the deadline and it shows.

Western Conference

Central Division

  1. p-Winnipeg Jets, 116 points (63 GP so far)
  2. x-Minnesota Wild, 104 points (63 GP so far)
  3. x-Nashville Predators, 100 points (62 GP so far)
  4. wc2-St. Louis Blues, 92 points (65 GP so far)
  5. Dallas Stars, 92 points (63 GP so far)
  6. Colorado Avalanche, 85 points (63 GP so far)
  7. Chicago Blackhawks, 70 points (63 GP so far)

Your President’s Trophy winners, ladies and gentlemen, entering March 2018 should be the Winnipeg Jets.

That’s right, the team in Winnipeg, Manitoba with a seating capacity of a little more than 15,000 fans at Bell MTS Place. That one. Winnipeg. The Western Conference’s Carolina Hurricanes. They aren’t big spenders, yet they bought exactly what they needed at the trade deadline in Paul Stastny.

Meanwhile, apparently Eric Staal‘s first hat trick in a little over five years is enough to catapult the Minnesota Wild on a surprising run down the stretch. Though they are currently 3rd in the Central Division, Minnesota is coming alive.

It’s hard to knock the Nashville Predators off of their game– especially while they’re in command of the division– but something just doesn’t go exactly as planned this month for the Preds.

They’ll still beat Minnesota in the First Round and set themselves up for quite a matchup with Winnipeg in the Second Round though. Obviously the winner of that is going to battle the Vegas Golden Knights for the Clarence S. Campbell Bowl.

A warning to the St. Louis Blues– keep up this downward trend and the Dallas Stars will replace you in the wild card.

Whatever upper body injury is plaguing Corey Crawford is only making things worse for the Chicago Blackhawks.

In some models, they should be a lot better than they are right now, but that’s due to their impressive streak of success from 2010-17. Now, in 2018, the wheels fell off and the floor fell out from under them– on top of the Crawford injury.

Pacific Division

  1. y-Vegas Golden Knights, 113 points (63 GP so far)
  2. x-Los Angeles Kings, 105 points (64 GP so far)
  3. x-Anaheim Ducks, 100 points (64 GP so far)
  4. wc1-San Jose Sharks, 94 points (64 GP so far)
  5. Calgary Flames, 78 points (65 GP so far)
  6. Edmonton Oilers, 78 points (63 GP so far)
  7. Vancouver Canucks, 77 points (64 GP so far)
  8. Arizona Coyotes, 63 points (62 GP so far)

The Vegas Golden Knights, in their inaugural season, come up three points shy of winning the 2017-18 President’s Trophy as the team with the best regular season record. The Vegas Golden Knights.

Despite the push from all of the California clubs, this is Vegas’s division title to lose. Not just in the regular season, but in the playoffs too.

No amount of onslaught from the Los Angeles Kings or Anaheim Ducks should be able to stand a seven-game series with Ryan Reaves and the rest of the Golden Knights. Having said that though, it’s a shame the San Jose Sharks will likely pair-up with the Jets, because we’ll never get to know if Vegas could single handedly defeat all three California teams en route to the 2018 Stanley Cup Final.

That’s assuming a lot, but let’s roll with it.

All season long the Calgary Flames have been a lovable underdog. Unfortunately, their time is cut short. All good things must come to an end and again, if you’re going to do nothing at the deadline as a fringe competitor, you can’t expect to improve.

At least you shouldn’t, otherwise well, you know the definition of insanity (doing the same thing and expecting a different result).

Better luck next year, Edmonton Oilers, Vancouver Canucks and Arizona Coyotes.

Numbers Game: Vegas at Halftime (Through 41 GP in 2017-18)

The Western Conference leading Vegas Golden Knights entered their bye week at exactly 41 games played.

Due to an unintentional– completely accidental– oversight on my behalf, I didn’t remember to look at their stats after 40 games played (like I normally would every 20 games throughout the season). But for the perfectionists in the world out there– it’s better to split things right down the middle.

Vegas is back in action for the second half of their inaugural season on Saturday after going 29-10-2 (60 points) in their first 41 games in franchise history.

Earlier in the week, I pointed out that the New Jersey Devils have been quite a pleasant surprise this season. Of course, I made sure to mention the Golden Knights as one of the other pleasant surprises.

It’s not that nobody expected this team to fail as much as all the other expansion teams in the 100-year history of the league.

Given the talent pool to choose from and the overall development of professional hockey players/the league itself since the 1990s (it’s a younger, faster, game where great players last well into their 30s and good players are buried in the AHL or playing overseas by the time they’re 30-35 years old), it really shouldn’t surprise anyone that the Golden Knights are at the very least, a competitive– young– team.

Even still, it’s been quite the euphoric ride.

A team that poached the Florida Panthers– and many others– at the 2017 Expansion Draft, laid the foundation in 50-plus point scorer, Jon Marchessault, let alone with three-time Stanley Cup champion goaltender, Marc-Andre Fleury. Surely they would have some highlights in their first season.

Nobody could’ve imagined that same team would be seriously considering keeping Fleury or a guy like James Neal at the trade deadline in the midst of what could shape up to be a long playoff run in their first season, but alas, here we are.

It’s more than just “Real Deal” James Neal in Sin City. The Golden Knights are the real deal.

And their forecasted stats for the remaining half of the regular season show it. Though now is about the time where I make sure to mention one little standard disclaimer– my degree is in communication– not math– so any miscalculations or accolades that seem nearly impossible to ascertain are Microsoft Excel’s fault.

vegas_golden_knights_logo

Vegas Golden Knights Projections Through 41 Games (41 Games Remaining)

This slideshow requires JavaScript.

Simply put, Erik Haula (26-24–50 expected totals), William Karlsson (32-23–55 expected totals) and Marchessault (30-38–68 expected totals) are blazing through the rest of the league and showing no signs of flaming out any time soon.

It certainly helps that Neal and David Perron are both expected to reach the 60-point plateau, with Reilly Smith not so far behind amassing 19-38–57 expected totals.

On defense, Deryk Engelland, Colin Miller, Nate Schmidt and Shea Theodore have been leading the charge from the blue line all season long. For Engelland, the adopted son of Las Vegas, a revitalized season defending the league’s newest team might just keep him playing in his backyard for longer than just this season.

Miller and Schmidt were expected to take on more pronounced top-4 roles with the expectation that at least one of them would develop into a surefire top-2 shutdown defenseman. Miller should max out around 40 points, while Schmidt should put up a cool 30-point season in his first year outside of the United States capital.

After being sent to the AHL early on in the season, Shea Theodore was only motivated to work harder.

It wasn’t that he was not desired by an NHL team as clearly Vegas saw value in his game at the Expansion Draft, claiming Theodore from the Anaheim Ducks. Now that the Golden Knights front office and coaches have righted their wrong, Theodore could very well put up 24 points on the season in what is– by all means– a breakout season for the defenseman entering his prime.

In the net, the Golden Knights have been spectacular. Not only has general manager, George McPhee, come away looking even more like the genius that he already is, but Vegas is stacked at depth in the crease.

Malcolm Subban‘s playing like a backup that’s capable of taking on a starting role. That’ll be something to keep an eye on, given Fleury’s aging out of his prime– though he has yet to show it. It’s not often that a team has the right pieces to play two goalies almost equally in minutes and be successful.

In 2011, the Boston Bruins rode the backs of Tim Thomas and Tuukka Rask to the Stanley Cup Final. Interestingly enough, the Vancouver Canucks did the same with Roberto Luongo and Cory Schneider.

Thomas played his last game as a Bruin in 2012. Luongo was traded by the Canucks in 2014– a year after Vancouver dumped Schneider in New Jersey.

Two tremendous goalies are better than one from a team record standpoint, but at some point general managers are either forced with a difficult decision due to the salary cap or fall into the fallacy that is the “there can only be one” mantra.

And Gerard Gallant might end up with some tough decisions down the stretch regarding who to start each night, reminiscent of Mike Sullivan‘s Fleury-Matt Murray swapping during en route to Pittsburgh’s 2016 and 2017 Stanley Cup championships.

Nonetheless, Oscar Dansk filled in flawlessly when Fleury and Subban were out of the lineup with injuries. Meanwhile, Maxime Lagace performed on another level shortly after Dansk’s introduction to the game when Dansk went down himself due to injury.

With enough depth in goal to try to get something good in return, the ball is in Vegas’s court as the trade deadline approaches. Though the Golden Knights don’t have to rush things. A little competition for every goaltending job isn’t always a bad thing.

Being in first place in the Western Conference isn’t good enough for the Golden Knights. They’ve got their sights set even higher, like on a 2018 Stanley Cup Final run, for instance.

Sin City is looking to shine like gold. Vegas wants the Cup.

Numbers Game: Boston Through 40 (2017-18)

As the calendar flips from 2017 to 2018 the NHL’s regular season keeps rolling along. Having played 40 games so far this season, the Boston Bruins are now in the midst of their bye week 2nd in the Atlantic Division (53 points)– ten points behind the Eastern Conference leading Tampa Bay Lightning.

Plenty of teams have been pleasant surprises, namely, the Vegas Golden Knights and the New Jersey Devils through the first half of the season. To say the Golden Knights are merely on a hot start is a major understatement– there’s a legitimate chance Vegas will not only make the playoffs, but compete with the Lightning and Winnipeg Jets in what’s shaping up to be a competitive three-way battle for the 2017-18 President’s Trophy.

Regardless, Boston has not been a pleasant surprise. No.

If you’ve been tracking Don Sweeney‘s every move since becoming general manager in 2015, then you aren’t surprised at all to see that this year’s Bruins squad is playing on another level and turning heads around the hockey world.

It’s a very methodic approach– one that takes its time while patience wears thin among fans that demand excellence every shift in the Hub– but the Boston Bruins are ready for a breakout performance in the 2018 Stanley Cup Playoffs (barring a second half of the season collapse).

While many are busy trying to come up with a nickname for Boston’s fourth line of Tim Schaller, Sean Kuraly and Noel Acciari— I recommend either “The 50s Line” (since Schaller, Kuraly and Acciari wear No.’s 59, 52 and 55 respectively) or “The B52 Line” (an ode to the music group, sure, but also a nod to Kuraly’s stellar anchor as the center)– it’s a shame no one’s come up with anything for the legend that is the Brad Marchand, Patrice Bergeron and David Pastrnak line.

Usually it’s just “the Bergeron line”, but if you’ve seen the production from this line, you might just think back to the days of “The Uke Line”, “The Kraut Line” or “The Dynamite Line”– all of which were historic lines in Bruins franchise history.

Anyway, on with the show…

Through 40 games played this season, here’s a look at how every player on Boston’s roster should pan out for the remaining 42 games. Please remember my degree is in communication– not math– so any miscalculations are Microsoft Excel’s fault.

Unknown-7

Boston Bruins Projections Through 40 Games (42 Games Remaining)

This slideshow requires JavaScript.

At this point in the season everything begins to look more realistic. Unless you’re still looking at Tommy Cross‘s projected stats. Again, that’s a product of forecasting a season for a player based on every career NHL game that player has played. Cross has yet to appear in an NHL game since the 2015-16 season; because of this, his numbers look more promising based on the formula alone than they actually probably would be, unless he knows something about his game we don’t.

Until a player like Cross (or other players with few career NHL games played) suits up in the 2017-18 season, that players numbers are reflective of a more “idealistic” season. In other words, it’s a pipe dream (until it actually happens).


The Bruins finally have a healthy lineup. Well, kind of.

Defenseman, Adam McQuaid, is still out after missing time due to a fractured right fibula. Upon his imminent return, who exactly should Bruce Cassidy pull out of the lineup, if anyone?

Matt Grzelcyk‘s emerged from the shadows of the last couple of seasons– in which he made his professional debut and NHL debut. He’s solidified himself as a top-6 defenseman, capable of earning his ice time and/or McQuaid’s job at less than half the price (at least until this offseason, when Grzelyck’s entry-level contract is set to expire).

Grzelyck, 24, is seven-years younger than McQuaid and could provide the same amount of offensive production or more down the road. By default, Grzelcyk’s offensive game is better than McQuaid’s this season.

Of course, there’s some things working in McQuaid’s favor in his ability to block shots, use his body and throw punches when “the code of hockey” needs to be enforced.

Though, again, there is a younger blue liner– albeit by a year and at $250,000 less– that could carry the weight of the tough guy on Boston’s defense. That guy is Kevan Miller, 30, who’s having what’s poised to equal or surpass his career year of 2015-16 in points (18), while teaching Grzelyck the ways of a bottom-pair defenseman.

Brandon Carlo has yet to score this season and is– by all considerations– in a sophomore slump. But he is only 21-years-old and destined to solidify as a top-4 defenseman in his career. He’s no Charlie McAvoy, but it wouldn’t make sense to punish a young player for showing his youth in his errors that he’s made at times through the year.

Before you know it, McQuaid could be the next Paul Postma on the Bruins as another healthy scratch on a night-to-night basis– though providing much needed depth when one of the regular guys goes down with an injury.

The Bruins have a plus-29 goal differential after 40 games this season, which is seven more than they had at the end of last season.

It seems promising that Boston will continue to only get better offensively down the stretch with David Pastrnak seeking to best his career high in assists while amassing almost 70 points on the season. That’s just 1/3 of the Bergeron line.

Brad Marchand should easily reach the 70-point plateau for not only the second time in his career– but the second year in a row– as Patrice Bergeron continues to swing the momentum around in his scoring projections (expected to surpass at least 60 points this season).

Rookies Jake DeBrusk and Danton Heinen will each have respectable numbers that should flirt with the 50-point plateau. DeBrusk may only end up with 20-26-46 totals, but Heinen should continue to charge down the stretch reaching 22-43–65 totals in his own spectacular rookie season.

It’s not Earth-shattering by any means, but it is highly underrated. Especially with a guy like David Backes on the same line.

Backes, in his own right, is bringing some extra bang for his buck this season. Having missed almost half of the season with diverticulitis and recovering from the surgical removal of part of his colon, Backes is lighter and better than ever.

And one more thing for the haters…

Tuukka Rask is back. This could be a Vezina Trophy winning season, if not more, for the Finnish goaltender.

Numbers Game: Boston Through 20 (2017-18)

The 2017-2018 regular season is rolling along as American Thanksgiving is once again upon us and everyone’s freaking out about some of the teams that are in playoff position (like Vegas) or not (like NYR) and all that stuff about “teams that are in the playoff picture by Thanksgiving traditionally make the playoffs based on stats”.

I’m as much of a stats fan as the next guy, but in today’s NHL, parity is unpredictable. There are some false positives in the playoff picture right now as there are equally some teams that we all thought would be dominating the Pacific Division currently– I’m looking at you, Edmonton Oilers.

Alas, the Boston Bruins find themselves in fourth place in the Atlantic Division as they are about to chow down on some turkey, quinoa and whatever else I’m sure Zdeno Chara is probably cooking up for them because if you haven’t already heard, his diet is better than Tom Brady’s*.

*I don’t actually stand by this claim, Mr. Brady. You’re still the GOAT.

Boston is one point away from tying the Detroit Red Wings in points, but would leap over them for sole position of third place in the division if the B’s tied Detroit, given the Bruins have a game-in-hand on the Red Wings currently. Likewise, if Boston added two points outright, they’d surpass Detroit (because that’s how the whole “2 points for a win, 1 point for an overtime/shootout loss and no points for a regulation loss” thing works).

Please remember that my degree is in communication– not math– so any miscalculations are Microsoft Excel’s fault.

Without further ado and to give you something to talk about at the dinner table while you stuff your face with sweet potatoes, here’s a look at how every player on the Bruins should pan out as the team has now played 20 games this season.

Unknown-7

Boston Bruins Projections Through 20 Games (62 Games Remaining)

This slideshow requires JavaScript.

Keep in mind, young guys like Anders Bjork, Matt Grzelcyk and others will even out in some of their individual stats with more games under their feet. Bjork probably won’t have 15 points on the power play, but that’s just what the formula in Microsoft Excel shows until he gets another 10 or 20 games in his system.

Guys like Grzelcyk and Rob O’Gara, while they’ve played games over a couple of seasons, are like Bjork according to the formula in that their total number of career games means just about the same as one season (or more accurately, 16 games so far) of Bjork. And obviously Tommy Cross is Tommy Cross.

Like Jordan Szwarz, Cross doesn’t have a huge sample of career games played and there haven’t been plenty of appearances since his last game at the NHL level (though Szwarz actually filled in for nine games while David Krejci, Ryan Spooner and David Backes were out with injuries).

Thankfully Spooner is back and can start racking up assists, while Krejci can settle in with Jake DeBrusk pulling his weight as a rookie.

Hopefully Peter Cehlarik continues to be making claim for a longer stay with the big league club instead of going back to the Providence Bruins like he did last season after making his NHL debut, because his play with and without the puck has certainly been impressive– aside from the clear chemistry he has with David Krejci.

Patrice Bergeron has improved since his lower body injury forced him out of the lineup, but he’s still looking at an “off” year for the next 62 games ahead. That’s right, a bad year for Bergeron is still worth 60 points in scoring.

Whenever Brad Marchand returns from the IR, he should be just fine.

And it should be rather transparent, but David Pastrnak and Charlie McAvoy are incredible stars on this team. So there’s that.

Finally, there’s no goaltending controversy with the black and gold. Tuukka Rask should rebound, but you’d be crazy not to ride the back of Anton Khudobin while he’s been on fire lately.

Rask is best kept between 45 and 58 games in a season, so if Khudobin can keep up his current play for another 10 games or so before returning to his usual backup status, that should buy Rask plenty of time to recover from overworking the last three seasons (or more, probably more). Play Khudobin until he burns out, but hope he can take off almost 30 games from Rask’s workload compared to the last couple of seasons.


If you’re interested, here’s a look at how the Bruins should have been doing entering the 2017-2018 regular season.

Numbers Game: 2017-18 Standings Projections

Yes, it’s October.

Yes, it’s too early to make a final standings projection, but I’m going to do it anyway using a pseudo-algorithm called Heart and Grit Gut Feeling 2.0 (combined with the standard Microsoft Excel forecasting formula).

Gut Feeling 2.0 is better than just using the eye test because it combines actual numbers plugged into Microsoft Excel with the complete partial bias of whatever I feel like is the right record, number of points and/or anything shown below for all 31 teams in the NHL.

But seriously, to keep this loosely based in mathematics, I’ve included a range of points that three separate models are indicating (scroll to the bottom), as well as what Gut Feeling 2.0 is telling us.

2017-2018 Projected Final Standings

Eastern Conference

Atlantic Division

  1. y-Boston Bruins, 101 points
  2. x-Montreal Canadiens, 99 points
  3. x-Tampa Bay Lightning, 98 points
  4. x-Toronto Maple Leafs, 95 points
  5. Ottawa Senators, 93 points
  6. Buffalo Sabres, 90 points
  7. Florida Panthers, 82 points
  8. Detroit Red Wings, 80 points

Predicting the final outcome across the Eastern Conference this year is a lot like playing the lottery– whether you pick your numbers or just do quick picks, your odds of winning are still far, far less than getting struck by lightning twice.

In the Atlantic Division, the Boston Bruins barely beat out the Montreal Canadiens and Tampa Bay Lightning for the regular season division title with 101 points over Montreal’s 99 points and Tampa’s 98 points based on the Gut Feeling 2.0 model. Of course, seeding in the Stanley Cup Playoffs more often than not means nothing. Just like winning the President’s Trophy doesn’t mean much unless you win the Cup.

Given the parity of the Atlantic Division teams, it wouldn’t be surprising to see any of the top-four teams in this model switch places or grab the division crown. Based on expected final standings point-ranges alone, Tampa looks to rebound with ease, while Montreal maintains status quo.

It’s a bit of a surprise, but the Ottawa Senators sit just on the outside looking in, though logic says otherwise. For one team to improve in the division (say, Tampa for example, or the Buffalo Sabres with a healthy, full-season of Jack Eichel), another team must lose. Five points in the final standings is the only difference between 2017-2018 and 2016-2017 for the Sens and ultimately it costs them a postseason appearance.

But if any major injuries occur to teams ahead of the Senators or Sabres, then expect either Ottawa or Buffalo to be ready to take their place.

When it comes to 2018 Stanley Cup Playoff success, you might want to consider cashing in on the Lightning and Toronto Maple Leafs to at least make it to the Second Round.

Metropolitan Division

  1. z-Pittsburgh Penguins, 107 points
  2. x-Washington Capitals, 106 points
  3. x-New York Rangers, 103 points
  4. x-Columbus Blue Jackets, 102 points
  5. New York Islanders, 92 points
  6. Carolina Hurricanes, 92 points
  7. Philadelphia Flyers, 91 points
  8. New Jersey Devils, 84 points

The 2017-2018 final standings in the Metropolitan Division look similar to the 2016-2017 final standings in the Metropolitan Division. This is no accident. The top teams, Pittsburgh, Washington and the New York Rangers, remain dominant in their regular season play. Even the Columbus Blue Jackets, despite a six-point setback from their franchise best 50-win, 108-point season last year, remain a competitive team that should cross the 100-point plateau for two-seasons in a row under John Tortorella’s guise.

Whereas the Washington Capitals do not clinch the President’s Trophy in the 2017-2018 season and instead falter by 12 points compared to last season, the Carolina Hurricanes show improvement in their money-puck roster mentality, but ultimately the giants of the Metropolitan Divsion (the two-time defending Stanley Cup champion Pittsburgh Penguins, to be specific) prove too much for them to handle this season, though a 2019 Stanley Cup Playoffs run seems imminent.

Somehow the New York Islanders and Philadelphia Flyers remain stagnant this season, but the New Jersey Devils make the largest leap in points (from 70 points in ’16-’17 to 84 points in ’17-’18) as the rest of the division evens out.

Look for Pittsburgh to advance to the Second Round and yet another entertaining Rangers-Capitals matchup in the 2018 Stanley Cup Playoffs.

Western Conference

Central Division

  1. y-Chicago Blackhawks, 102 points
  2. x-St. Louis Blues, 101 points
  3. x-Nashville Predators, 97 points
  4. x-Dallas Stars, 96 points
  5. x-Minnesota Wild, 95 points
  6. Winnipeg Jets, 87 points
  7. Colorado Avalanche, 82 points

Look, the Dallas Stars have tremendous talent on their expected first line of Jamie Benn, Tyler Seguin and Alexander Radulov, but even with Ben Bishop as their starting goaltender the Stars aren’t the best team in the Central Division.

Instead, the annual “how do they keep doing this all the time? oh, right, they have Patrick Kane, Jonathan Toews, Duncan Keith and Corey Crawford still” Chicago Blackhawks will just come out on top of the St. Louis Blues who look to improve from last season with a reinforced offense (hello, Brayden Schenn) and more experience on the blue line.

The Nashville Predators, in all their glory with four incredibly deep forward lines, the best defense (on paper) and an elite starting goalie in Pekka Rinne, surprisingly fall short of winning the division coming off of their 2017 Stanley Cup Final run. Nashville will be in better playoff position heading into the 2018 Stanley Cup Playoffs, given they won’t be the last team to clinch in the Western Conference, and they should be destined for another Western Conference Finals run, at least.

The Minnesota Wild are the winners of the consolation “hey the other division didn’t have four-quality playoff teams” prize and will clinch the second Western Conference wild card spot with 95 points in 2017-18– one season removed from a 49-25-8 record and 106 point, 2nd place finish in the Central Division.

Finally, the Colorado Avalanche couldn’t possibly have a season worse than they did last season, though they’re still poised to finish behind the Winnipeg Jets for last place in the division.

Pacific Division

  1. p-Edmonton Oilers, 112 points
  2. x-Anaheim Ducks, 109 points
  3. x-San Jose Sharks, 99 points
  4. Los Angeles Kings, 92 points
  5. Calgary Flames, 85 points
  6. Vancouver Canucks, 83 points
  7. Arizona Coyotes, 78 points
  8. Vegas Golden Knights, 72 points

Gut Feeling 2.0 never lies and the numbers don’t lie either. The Edmonton Oilers will be the top team in the Pacific Division when all is said and done this season. Better yet, the Oilers will be this season’s President’s Trophy winners– something that hasn’t happened since the days of some guy wearing a jersey with the number “99” on the back of it skated around the ice.

Other than Edmonton overtaking the Anaheim Ducks for first overall, there are virtually no changes in the Pacific Division standings. San Jose will knock at the door of a 100-point season for the third season in a row, only to fall a point short (for the second season in a row).

While Los Angeles Kings fans may be disappointed this season, if anything, missing the playoffs for one more season should give them enough time to develop and recover from their offseason roster moves while GM Rob Blake figures out the reins and plans the path back to Stanley Cup glory.

Things are coming together for the Arizona Coyotes. They won’t be a bad team; they’re just a victim of circumstance. Unfortunately, that circumstance dictates that it’s going to take one more season for the chemistry to work out as general manager, John Chayka, addresses the growing depth on offense (both in prospect development and with the addition of Derek Stepan this offseason), while building a stable core of defensemen and capable young goalies in Antti Raanta and Louis Domingue.

Meanwhile the Vancouver Canucks and Calgary Flames go through their own growing pains for another season.

Luckily for the Vegas Golden Knights, there’s no pressure to play better than last season, mostly because this is their inaugural season, so it can’t be worse than before!

Look for Edmonton to make noise in the 2018 Stanley Cup Playoffs, going as deep as the Western Conference Finals– at least. Likewise, the Sharks seem ready for a better fight in the postseason than last season.

Plausible ranges in points based on three separate models (math done in Microsoft Excel alone– no Gut Feeling 2.0 added) for the 2017-2018 season:

Atlantic Division

Boston Bruins (94-101), Buffalo Sabres (67-84), Detroit Red Wings (86-101), Florida Panthers (84-92), Montreal Canadiens (93-99), Ottawa Senators (91-92), Tampa Bay Lightning (89-98), Toronto Maple Leafs (80-90)

Metropolitan Division

Carolina Hurricanes (81-87), Columbus Blue Jackets (84-92), New Jersey Devils (77-92), New York Islanders (84-97), New York Rangers (98-103), Philadelphia Flyers (90-92), Pittsburgh Penguins (105-108), Washington Capitals (102-119)

Central Division

Chicago Blackhawks (100-107), Colorado Avalanche (65-84), Dallas Stars (92-94), Minnesota Wild (93-97), Nashville Predators (94-97), St. Louis Blues (97-106), Winnipeg Jets (83-87)

Pacific Division

Anaheim Ducks (101-109), Arizona Coyotes (74-83), Calgary Flames (85-90), Edmonton Oilers (74-87), Los Angeles Kings (90-96), San Jose Sharks (99-104), Vancouver Canucks (72-95), Vegas Golden Knights (69-75)

Numbers Game: The Inaugural Vegas Golden Knights Season

The NHL’s newest franchise, the Vegas Golden Knights, are set to begin play in the 2017-2018 season and T-Mobile Arena is sure to be packed with 17,500 fans in the stands cheering on the league’s 31st team.

vegas_golden_knights_logo

But how many times will Golden Knights fans be on their feet in euphoria after a goal, big save or otherwise amazing play?

After careful consideration, Vegas selected their team from the other 30 NHL teams at the 2017 Expansion Draft, the 2017 NHL Entry Draft and via free agency, both before July 1st and since July 1st.

And after further careful consideration, I once again navigated Microsoft Excel to project some stats for the 2017-2018 Vegas Golden Knights roster. Players that have yet to play a game in the NHL are not included, since it wouldn’t feel right to predict something at a level of play that they’ve never seen before, so hold yourselves back a moment, Vadim Shipachyov fans. Give it until at least 20 games into the season, thanks.

Or at least until I can figure out how to use the forecast function for a player who’s yet to see the NHL a formula for KHL players bound for the NHL– or anyone that’s making their NHL debut.

Sample size must be kept in mind when approaching these projections. A player who scored one goal in six career NHL games over the last two seasons, having spent last season primarily in the AHL or as a healthy scratch is for some inexplicable reason, going to look promising on paper before an 82-game season begins because that’s just the way Microsoft Excel works.

This is by no means a shot at the professional ability of a player, as someone like *ahem, if you look at the chart* Brendan Leipsic. It is always plausible that Leipsic could pan out and make enough of an impression to stick around with the Golden Knights NHL roster and amass at least ten goals.

As always, keep in mind that I am no math major and you’re (probably) not a general manager, head coach, assistant coach or whatever might give you some credibility for statistical reasoning in hockey.

But if your name is George McPhee or Gerard Gallant and you’re reading this… ‘Sup? *slides résumé across the table*

And if your name is Jon Marchessault, then you’re in for a very fun season with an excellent followup to a 51-point season. Marchessualt is projected to amass 28-22-50 totals in his first season as the pinnacle of Vegas Golden Knights prime-age-driven offensive production.

Only James Neal (30-27-57 projected totals) is bound for a better season at the age of 29, which, for all intents and purposes of the today’s NHL is on the older side of a youth-driven offense, but still in the arch of a player’s prime. With only a projected six-point difference between Neal and Marchessault in expected scoring for Vegas, we’re all in for a treat in Sin City’s intra-roster battle for lead scorer.

The ever efficient, Reilly Smith, is in for a quietly successful season with 18 goals and 26 assists (44 points) in the latest projections (a seven-point improvement from 2016-2017 with the Florida Panthers). Smith’s familiarity and chemistry with teammate, Marchessault, fits brilliantly in the design of McPhee’s Golden Knights, especially with Gallant at the realm behind the bench.

While Smith provides an underrated star quality to the roster, David Perron looks to keep pace with last season’s 46-point year in his 2nd stint with the St. Louis Blues, by bringing in a 19-28-47 expected totals for Vegas in 2017-2018. Injuries aside, Perron puts up quality consistency for two or three seasons in a row and is in the midst of just that as the Golden Knights get out of the gate in their first season.

From the 2008-2009 season through the 2014-2015 season, Perron recorded 40-plus points a season with only two exceptions– an injury shortened 2010-2011 season, in which Perron only played 10-games as a 22-year-old member of the Blues and the lockout shortened 2012-2013 season, where Perron amassed 25 points in 48 games played for St. Louis.

In 2014-2015, mind you, Perron combined 5-9-14 totals in 38 games for the Edmonton Oilers and 12-10-22 totals in 43 games for the Pittsburgh Penguins for a 41-point effort in 81 games played that season. And in 2015-2016, the now 29-year-old split time among the Penguins and the Anaheim Ducks, so he’s been around the league enough to know how to bring some of the intangibles (a.k.a. veteran leadership/a locker room presence) to the expansion team in Vegas.

Check out what to expect from everyone on the Vegas Golden Knight’s inaugural season’s roster below!

This slideshow requires JavaScript.

 

 

2016-2017 Projections- ARI and BOS

By: Nick Lanciani

Below are my projections for both the Boston Bruins and Arizona Coyotes as they were before either team played a game (I know the season started already, but I didn’t have enough time in a day to compile all of these exactly as I wanted to because I’m a perfectionist). So without further ado, here are some projected stats.

Keep in mind, every stat is based off of a player’s entire career and may not reflect well with the other stats projected for this current season (a.k.a. goals + assists might not equal the number of points shown in the points category), because again, each stat is forecasted individually.

Italics indicates a player currently with their respective AHL affiliate. Underlined player stats indicate a player on the IR (which, admittedly, I’ll do my best to keep up with, but might not have perfect every time, so forgive me if I mistakenly label an injury or fail to label one entirely).

Also, I don’t mess with predicting anything for rookies until they’ve played a few NHL games, so if you’re looking for how well one of them will do for your team here, sorry. Unlike last season, I won’t be able to update everything after every 10 games, but I’ll try my best to keep things updated after every 20 games (or so). At the very least, I’ll be sure to update things halfway through the season (41 games) on this page and whenever I get around to it for individual player’s based on their performance on Twitter (as exhibited by my Brad Marchand and David Backes related tweets below from Thursday night).

Likewise, I might add more Corsi projections than just Corsi for%.

Arizona Coyotes Projections- Game 0 of 82

Coyotes forwards

Screen Shot 2016-10-14 at 2.37.40 AM.png

Coyotes goalies

Screen Shot 2016-10-14 at 2.37.48 AM.png

Corsi for% projections for Arizona roster skaters

Screen Shot 2016-10-14 at 2.37.57 AM.png

*indicates that the current projection is regarded as unreliable based on previous career performance (in other words, it’s an outlier)

Boston Bruins Projections- Game 0 of 82

Bruins forwards

Screen Shot 2016-10-14 at 2.47.04 AM.png

Bruins goalies

Screen Shot 2016-10-14 at 2.47.13 AM.png

Corsi for% projections for Boston roster skaters

Screen Shot 2016-10-14 at 2.47.22 AM.png