2015 NHL Franchise Tournament - FINALS, GAME 5 RESULTS!

[philpritchard]

Is there some way we can get the Day 4 results back? I tried to check the links but the games aren't found

"The boxscore you've requested can not be located in our game library"

Damn, I'm not sure if you can get those back. You have to hit "Save Game" on the boxscore or they'll disappear after 48 hours or something like that. I just went back and saved the Day 5 results so we won't lose them, but I think Day 4 is gone.

[Lament]

FYI... If anyone is using that spreadsheet to sum their player totals you would be better off with a "sumif" so you can just paste your entire boxscore in one shot and not care about who is "player 1" and who is "player 2".

In Column T just paste in all of your players names (doesn't matter what order)
In Columns U to AE, and also in Columns AG to AI paste in a formula like this which will sum all of the stats by looking up the players name in Column T:

=SUMIF($A$2:B$1619,$T2,B$2:B$1616)

That is my formula in Column U. As you copy it across the other columns it will automatically change to include the correct range from the boxscores. So your formula in Column V would look like this:

=SUMIF($A$2:C$1619,$T2,C$2:C$1616)

...and so on.

Now you can just paste the whole boxscore for a game in one shot regardless of the order.

I wish I understood this so I could do it.

[Lament]

Twenty-eight points through twelve games for Mario. And he's only logging about sixteen minutes a game.

[Mecca]

Is there some way we can get the Day 4 results back? I tried to check the links but the games aren't found

"The boxscore you've requested can not be located in our game library"

Damn, I'm not sure if you can get those back. You have to hit "Save Game" on the boxscore or they'll disappear after 48 hours or something like that. I just went back and saved the Day 5 results so we won't lose them, but I think Day 4 is gone.

had no idea about that. that's shitty

[Mecca]

FYI... If anyone is using that spreadsheet to sum their player totals you would be better off with a "sumif" so you can just paste your entire boxscore in one shot and not care about who is "player 1" and who is "player 2".

In Column T just paste in all of your players names (doesn't matter what order)
In Columns U to AE, and also in Columns AG to AI paste in a formula like this which will sum all of the stats by looking up the players name in Column T:

=SUMIF($A$2:B$1619,$T2,B$2:B$1616)

That is my formula in Column U. As you copy it across the other columns it will automatically change to include the correct range from the boxscores. So your formula in Column V would look like this:

=SUMIF($A$2:C$1619,$T2,C$2:C$1616)

...and so on.

Now you can just paste the whole boxscore for a game in one shot regardless of the order.

I wish I understood this so I could do it.

I just did Find->Replace All with the names in the same spot for every game

[philpritchard]

Day 7 Results!

Toronto Maple Leafs @ Chicago Blackhawks
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1

Spoiler: show

Toronto Maple Leafs - 0
Chicago Blackhawks - 4

Three Stars
1. Chi – Ed Belfour
2. Chi – Pierre Pilote
3. Chi – Bobby Hull

Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1

Spoiler: show

Toronto Maple Leafs - 6
Chicago Blackhawks – 5 (OT)

Three Stars
1. Tor – Charlie Conacher
2. Tor – Busher Jackson
3. Chi – Bill Mosienko

Detroit Red Wings @ Boston Bruins
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1

Spoiler: show

Detroit Red Wings - 5
Boston Bruins - 2

Three Stars
1. Det – Gordie Howe
2. Det – Vyacheslav Kozlov
3. Det – Henrik Zetterberg

Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1

Spoiler: show

Detroit Red Wings - 1
Boston Bruins - 3

Three Stars
1. Bos – Tiny Thompson
2. Det – Terry Sawchuk
3. Bos – Eddie Shore

Pittsburgh Penguins @ Dallas Stars
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1

Spoiler: show

Pittsburgh Penguins - 6
Dallas Stars- 5 (OT)

Three Stars
1. Pit – Craig Simpson
2. Pit – Lowell MacDonald
3. Dal – Brian Bellows

Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1

Spoiler: show

Pittsburgh Penguins - 5
Dallas Stars - 7

Three Stars
1. Dal – Neal Broten
2. Pit – Jaromir Jagr
3. Pit – Ron Francis

St. Louis Blues @ Buffalo Sabres
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1

Spoiler: show

St. Louis Blues - 7
Buffalo Sabres – 6 (OT)

Three Stars
1. Stl – Steve Duchesne
2. Buf – Phil Housley
3. Buf – Alexander Mogilny

Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1

Spoiler: show

St. Louis Blues - 1
Buffalo Sabres - 6

Three Stars
1. Buf – Pat Lafontaine
2. Buf – Thomas Vanek
3. Buf – Richard Smehlik

Montreal Canadiens @ Edmonton Oilers
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1

Spoiler: show

Montreal Canadiens - 6
Edmonton Oilers – 5 (OT)

Three Stars
1. Mtl – Guy Lafleur
2. Mtl – Larry Robinson
3. Edm – Glenn Anderson

Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1

Spoiler: show

Montreal Canadiens - 5
Edmonton Oilers -4

Three Stars
1. Mtl – Guy Lapointe
2. Edm – Glenn Anderson
3. Edm – Chris Pronger

Quebecorado Nordalanche @ New York Islanders
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1

Spoiler: show

Quebecorado Nordalanche - 2
New York Islanders - 6

Three Stars
1. NYI – Mike Bossy
2. NYI – Bryan Trottier
3. NYI – Jean Potvin

Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1

Spoiler: show

Quebecorado Nordalanche - 5
New York Islanders - 3

Three Stars
1. Que – Paul Stastny
2. Que- Ray Bourque
3. NYI – Bryan Trottier

[philpritchard]

A few crazy results today!

[Mecca]

A few crazy results today!

[Mecca]

just figured out that the sim essentially has Alexei Zhitnik on the top pairing and the 3rd D pairing because it wants Tyler Myers on the top pairing, which is just no. I've simmed a few games with Myers on my top pairing and the D suffers greatly

[southp]

Habs shutdown Gretzky nicely. In two games.... 0 Goals, 0 Assists, and a -4.

[southp]

I'm missing the week 4 results unfortunately, but my leading scorer so far is Larry Robinson (2G,15A)

[@SkitchP]

Habs shutdown Gretzky nicely. In two games.... 0 Goals, 0 Assists, and a -4.

\Gretzky has been insanely disappointing.

[Lament]

66 > 99.

[@SkitchP]

66 > 99.

19 played defense.

[@SkitchP]

I was feeling like the set up for the quality starts was going to be mostly unattainable, and then Sawchuk just fired off 4 in a row.

[Lament]

66 > 99.

19 played defense.

66 played defense against cancer.

[Mecca]

66 > 99.

19 played defense.

66 played defense against cancer.

[philpritchard]

4

[southp]

66 > 99.

19 played defense.

66 played defense against cancer.

Was this meant to be a shot at Mario or something? You don't fuck with Mario! (unless you're a Philly scumbag)

[Mecca]

I don't think it's been well documented, but I know I've said it that Mario is my favorite player ever.