Red Mosquito

southp wrote: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"

southp wrote: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.

philpritchard wrote:

southp wrote: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 wrote:

southp wrote: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.

Spoiler: show

Toronto Maple Leafs - 0
Chicago Blackhawks - 4

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

Spoiler: show

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

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

Spoiler: show

Detroit Red Wings - 5
Boston Bruins - 2

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

Spoiler: show

Detroit Red Wings - 1
Boston Bruins - 3

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

Spoiler: show

Pittsburgh Penguins - 6
Dallas Stars- 5 (OT)

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

Spoiler: show

Pittsburgh Penguins - 5
Dallas Stars - 7

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

Spoiler: show

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

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

Spoiler: show

St. Louis Blues - 1
Buffalo Sabres - 6

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

Spoiler: show

Montreal Canadiens - 6
Edmonton Oilers – 5 (OT)

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

Spoiler: show

Montreal Canadiens - 5
Edmonton Oilers -4

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

Spoiler: show

Quebecorado Nordalanche - 2
New York Islanders - 6

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

Spoiler: show

Quebecorado Nordalanche - 5
New York Islanders - 3

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

philpritchard wrote:A few crazy results today!

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

Lament wrote:66 > 99.

@SkitchP wrote:

Lament wrote:66 > 99.

19 played defense.

Lament wrote:

@SkitchP wrote:

Lament wrote:66 > 99.

19 played defense.

66 played defense against cancer.

Mecca wrote:

Lament wrote:

@SkitchP wrote:

Lament wrote:66 > 99.

19 played defense.

66 played defense against cancer.