2015 NHL Franchise Tournament - FINALS, GAME 5 RESULTS!

Discuss your hatred for the Yankees here.
Post Reply
User avatar
@SkitchP
RM Elitist
Posts: 9995
Joined: Tue January 01, 2013 8:43 pm

Re: 2015 NHL Franchise Tournament - DAY NINETEEN RESULTS!

Post by @SkitchP »

and now ive caught up the oilers. Its crazy how fast these days add up if you dont do them right away.
dimejinky99 wrote: Hang on I check on my Grindr
User avatar
@SkitchP
RM Elitist
Posts: 9995
Joined: Tue January 01, 2013 8:43 pm

Re: 2015 NHL Franchise Tournament - DAY NINETEEN RESULTS!

Post by @SkitchP »

and all joking aside, if someone with better (basically, any) excel skills than me can make a baseball one work like southp was describing, that would just be stellar.
dimejinky99 wrote: Hang on I check on my Grindr
User avatar
@SkitchP
RM Elitist
Posts: 9995
Joined: Tue January 01, 2013 8:43 pm

Re: 2015 NHL Franchise Tournament - DAY NINETEEN RESULTS!

Post by @SkitchP »

I got sick of entering the 1's for GP each game

so

=IF(G#>=1;1;0)

I put that in the GP category (open office, not excel) and it auto populates a "Game Played" as 1 provided your guy has a shift, 0 if he doesn't.
dimejinky99 wrote: Hang on I check on my Grindr
User avatar
Mecca
slower than 82% of US
Posts: 8516
Joined: Wed December 19, 2012 7:17 pm

Re: 2015 NHL Franchise Tournament - DAY NINETEEN RESULTS!

Post by Mecca »

@SkitchP wrote:I got sick of entering the 1's for GP each game

so

=IF(G#>=1;1;0)

I put that in the GP category (open office, not excel) and it auto populates a "Game Played" as 1 provided your guy has a shift, 0 if he doesn't.
I made it so TOI>0, 1, 0 as i was sick of it as well
User avatar
philpritchard
Rank This Poster
Posts: 4155
Joined: Thu January 03, 2013 3:45 pm

Re: 2015 NHL Franchise Tournament - DAY TWENTY RESULTS!

Post by philpritchard »

Day 20 Results!

Dallas Stars @ Toronto Maple Leafs
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Dallas Stars – 8 (OT3)
Toronto Maple Leafs - 9

Three Stars
1. Tor – Borje Salming
2. Dal – Bobby Smith
3. Dal – Ed Belfour
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Dallas Stars - 5
Toronto Maple Leafs - 11

Three Stars
1. Tor – Lorne Carr
2. Tor – Mats Sundin
3. Tor – Frank Mahovlich
Pittsburgh Penguins @ Detroit Red Wings
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Pittsburgh Penguins - 5
Detroit Red Wings - 6

Three Stars
1. Det – Carl Liscombe
2. Det – Steve Yzerman
3. Pit – Ron Francis
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Pittsburgh Penguins - 4
Detroit Red Wings - 5

Three Stars
1. Det – Larry Murphy
2. Pit – Jean Pronovost
3. Pit – Rob Brown
Boston Bruins @ St. Louis Blues
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Boston Bruins - 5
St. Louis Blues - 4

Three Stars
1. Bos – Brad Park
2. Stl – Pierre Turgeon
3. Bos – Dit Clapper
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Boston Bruins - 2
St. Louis Blues - 5

Three Stars
1. Stl – Al MacInnis
2. Stl – Roman Turek
3. Stl – Wayne Babych
Chicago Blackhawks @ Edmonton Oilers
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Chicago Blackhawks - 2
Edmonton Oilers - 6

Three Stars
1. Edm – Risto Siltanen
2. Edm – Jari Kurri
3. Edm – Chris Pronger
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Chicago Blackhawks - 2
Edmonton Oilers - 5

Three Stars
1. Edm – Jari Kurri
2. Edm – Paul Coffey
3. Edm – Wayne Gretzky
Buffalo Sabres@ Quebecorado Nordalanche
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Buffalo Sabres - 7
Quebecorado Nordalanche - 2

Three Stars
1. Buf – Alexander Mogilny
2. Buf – Dominik Hasek
3. Buf – Miroslav Satan
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Buffalo Sabres - 5
Quebecorado Nordalanche - 3

Three Stars
1. Buf – Jerry Korab
2. Buf – Pat Lafontaine
3. Buf – Dominik Hasek
New York Islanders @ Montreal Canadiens
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
New York Islanders - 4
Montreal Canadiens - 2

Three Stars
1. NYI – Denis Potvin
2. NYI – Jean Potvin
3. Mtl – Kirk Muller
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
New York Islanders - 5
Montreal Canadiens - 7

Three Stars
1. Mtl – Mats Naslund
2. NYI – Bob Nystrom
3. NYI – Mike Bossy
User avatar
Mecca
slower than 82% of US
Posts: 8516
Joined: Wed December 19, 2012 7:17 pm

Re: 2015 NHL Franchise Tournament - DAY TWENTY RESULTS!

Post by Mecca »

p-p-p-p-playoff push!
User avatar
@SkitchP
RM Elitist
Posts: 9995
Joined: Tue January 01, 2013 8:43 pm

Re: 2015 NHL Franchise Tournament - DAY TWENTY RESULTS!

Post by @SkitchP »

yay, updated my stats on the day they happened. That's way easier
dimejinky99 wrote: Hang on I check on my Grindr
User avatar
philpritchard
Rank This Poster
Posts: 4155
Joined: Thu January 03, 2013 3:45 pm

Re: 2015 NHL Franchise Tournament - DAY TWENTY RESULTS!

Post by philpritchard »

Mecca wrote:p-p-p-p-playoff push!
I'm in my late season push to get out of the basement. 8-)
User avatar
@SkitchP
RM Elitist
Posts: 9995
Joined: Tue January 01, 2013 8:43 pm

Re: 2015 NHL Franchise Tournament - DAY TWENTY RESULTS!

Post by @SkitchP »

Throwing this out there... if Mecca has separated himself from Lament by the end of the week, should we consider going with a 48 game season instead of 72?
dimejinky99 wrote: Hang on I check on my Grindr
User avatar
philpritchard
Rank This Poster
Posts: 4155
Joined: Thu January 03, 2013 3:45 pm

Re: 2015 NHL Franchise Tournament - DAY TWENTY RESULTS!

Post by philpritchard »

@SkitchP wrote:Throwing this out there... if Mecca has separated himself from Lament by the end of the week, should we consider going with a 48 game season instead of 72?
I'm ok with whatever everyone wants. There obviously isn't anywhere near the same support for this as there is for baseball, so shortening the season may not be a terrible idea.
User avatar
@SkitchP
RM Elitist
Posts: 9995
Joined: Tue January 01, 2013 8:43 pm

Re: 2015 NHL Franchise Tournament - DAY TWENTY RESULTS!

Post by @SkitchP »

philpritchard wrote:
@SkitchP wrote:Throwing this out there... if Mecca has separated himself from Lament by the end of the week, should we consider going with a 48 game season instead of 72?
I'm ok with whatever everyone wants. There obviously isn't anywhere near the same support for this as there is for baseball, so shortening the season may not be a terrible idea.

For me it's not really a lack of support, as much as it is the playoff race is looking pretty decided.
dimejinky99 wrote: Hang on I check on my Grindr
User avatar
E.H. Ruddock
Guys, I am not a moderator! I swear to God! Why does everyone think I'm a moderator?
Posts: 51787
Joined: Tue January 01, 2013 2:48 pm

Re: 2015 NHL Franchise Tournament - DAY TWENTY RESULTS!

Post by E.H. Ruddock »

whatever you guys decide.
Clouuuuds Rolll byyy...BANG BANG BANG BANG
User avatar
southp
AnalLog
Posts: 1454
Joined: Tue January 08, 2013 4:22 pm
Location: Montreal

Re: 2015 NHL Franchise Tournament - DAY TWENTY RESULTS!

Post by southp »

yeah, I'm ok if you want to go to 48.
I can hardly stay on top of my stats as it is.
User avatar
philpritchard
Rank This Poster
Posts: 4155
Joined: Thu January 03, 2013 3:45 pm

Re: 2015 NHL Franchise Tournament - DAY TWENTY-ONE RESULTS!

Post by philpritchard »

Day 21 Results!

Toronto Maple Leafs @ Pittsburgh Penguins
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Toronto Maple Leafs - 5
Pittsburgh Penguins - 10

Three Stars
1. Pit – Sidney Crosby
2. Pit – Mario Lemieux
3. Pit – Ron Francis
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Toronto Maple Leafs - 4
Pittsburgh Penguins - 3

Three Stars
1. Tor – Charlie Conacher
2. Pit – Jaromir Jagr
3. Tor – Doug Gilmour
Detroit Red Wings @ New York Islanders
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Detroit Red Wings - 2
New York Islanders - 6

Three Stars
1. NYI – Jean Potvin
2. NYI – Mike Bossy
3. NYI – Clark Gillies
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Detroit Red Wings - 8
New York Islanders - 4

Three Stars
1. Det – Steve Yzerman
2. Det – Carl Liscombe
3. Det – Ray Sheppard
St. Louis Blues @ Dallas Stars
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
St. Louis Blues - 5
Dallas Stars - 2

Three Stars
1. Stl – Joe Mullen
2. Stl – Jeff Brown
3. Stl – Roman Turek
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
St. Louis Blues - 2
Dallas Stars - 5

Three Stars
1. Dal – Brian Bellows
2. Dal – Mike Modano
3. Dal – Ed Belfour
Edmonton Oilers @ Boston Bruins
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Edmonton Oilers - 7
Boston Bruins - 5

Three Stars
1. Edm – Mark Napier
2. Edm – Matti Hagman
3. Edm – Joe Murphy
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Edmonton Oilers - 6
Boston Bruins - 8

Three Stars
1. Bos – Johnny Bucyk
2. Edm – Craig Simpson
3. Edm – Wayne Gretzky
Quebecorado Nordalanche @ Chicago Blackhawks
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Quebecorado Nordalanche - 4
Chicago Blackhawks - 1

Three Stars
1. Que – Joe Sakic
2. Que – Patrick Roy
3. Que – Ray Bourque
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Quebecorado Nordalanche - 4
Chicago Blackhawks – 3 (OT)

Three Stars
1. Que – Peter Forsberg
2. Chi – Stan Mikita
3. Que – Michel Goulet
Montreal Canadiens @ Buffalo Sabres
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Montreal Canadiens - 8
Buffalo Sabres - 1

Three Stars
1. Mtl – Kirk Muller
2. Mtl – Yvon Cournoyer
3. Mtl – Chris Chelios
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Montreal Canadiens - 6
Buffalo Sabres - 1

Three Stars
1. Mtl – Pete Mahovlich
2. Mtl – Larry Robinson
3. Mtl – Maurice Richard
User avatar
Mecca
slower than 82% of US
Posts: 8516
Joined: Wed December 19, 2012 7:17 pm

Re: 2015 NHL Franchise Tournament - DAY TWENTY-ONE RESULTS!

Post by Mecca »

i think we should shorten it, as well. this may come back to bite me, but i think a close race is more fun
User avatar
E.H. Ruddock
Guys, I am not a moderator! I swear to God! Why does everyone think I'm a moderator?
Posts: 51787
Joined: Tue January 01, 2013 2:48 pm

Re: 2015 NHL Franchise Tournament - DAY TWENTY-ONE RESULTS!

Post by E.H. Ruddock »

Mecca wrote: bite me
:naughty:
Clouuuuds Rolll byyy...BANG BANG BANG BANG
User avatar
Mecca
slower than 82% of US
Posts: 8516
Joined: Wed December 19, 2012 7:17 pm

Re: 2015 NHL Franchise Tournament - DAY TWENTY-ONE RESULTS!

Post by Mecca »

E.H. Ruddock wrote:
Mecca wrote: bite me
:naughty:
Image
User avatar
E.H. Ruddock
Guys, I am not a moderator! I swear to God! Why does everyone think I'm a moderator?
Posts: 51787
Joined: Tue January 01, 2013 2:48 pm

Re: 2015 NHL Franchise Tournament - DAY TWENTY-ONE RESULTS!

Post by E.H. Ruddock »

Aww. I miss that fuzzy little guy.
Clouuuuds Rolll byyy...BANG BANG BANG BANG
User avatar
philpritchard
Rank This Poster
Posts: 4155
Joined: Thu January 03, 2013 3:45 pm

Re: 2015 NHL Franchise Tournament - DAY TWENTY-ONE RESULTS!

Post by philpritchard »

Day 22 Results!

Detroit Red Wings @ Toronto Maple Leafs
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Detroit Red Wings - 6
Toronto Maple Leafs - 3

Three Stars
1. Det – Henrik Zetterberg
2. Det – Vyacheslav Kozlov
3. Det – Terry Sawchuk
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Detroit Red Wings - 7
Toronto Maple Leafs - 5

Three Stars
1. Det – Larry Murphy
2. Det – Brian Rafalski
3. Det – Gordie Hower
Pittsburgh Penguins @ St. Louis Blues
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Pittsburgh Penguins - 6
St. Louis Blues - 5

Three Stars
1. Pit – Jaromir Jagr
2. Stl – Brendan Shanahan
3. Pit – Ron Francis
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Pittsburgh Penguins - 6
St. Louis Blues - 4

Three Stars
1. Pit – Larry Murphy
2. Pit – Lowell MacDonald
3. Stl – Al MacInnis
Dallas Stars @ Edmonton Oilers
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Dallas Stars - 1
Edmonton Oilers - 6

Three Stars
1. Edm – Paul Coffey
2. Edm – Jari Kurri
3. Edm – Wayne Gretzky
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Dallas Stars - 5
Edmonton Oilers - 9

Three Stars
1. Edm – Craig Simpson
2. Edm – Wayne Gretzky
3. Edm – Jari Kurri
Boston Bruins @ Quebecorado Nordalanche
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Boston Bruins - 4
Quebecorado Nordalanche - 6

Three Stars
1. Que – Ray Bourque
2. Bos – Dit Clapper
3. Que – Anton Stastny
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Boston Bruins - 4
Quebecorado Nordalanche - 3

Three Stars
1. Bos – Wayne Cashman
2. Bos – Johnny Bucyk
3. Bos – Cam Neely
Chicago Blackhawks @ Montreal Canadiens
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Chicago Blackhawks - 3
Montreal Canadiens - 4

Three Stars
1. Mtl – Kirk Muller
2. Chi – Bill Mosienko
3. Chi – Dennis Hull
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
Chicago Blackhawks - 9
Montreal Canadiens - 6

Three Stars
1. Chi – Pierre Pilote
2. Chi – Bill Mosienko
3. Chi – Stan Mikita
New York Islanders @ Buffalo Sabres
Game 1 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
New York Islanders - 4
Buffalo Sabres – 3 (OT)

Three Stars
1. NYI – Tomas Jonsson
2. NYI – Chris Osgood
3. NYI – Stefan Persson
Game 2 - http://whatifsports.com/nhl/boxscore.as ... teamfee=-1
Spoiler: show
New York Islanders - 2
Buffalo Sabres - 5

Three Stars
1. Buf – Pat Lafontaine
2. Buf – Dave Andreychuk
3. NYI – Mike Bossy
User avatar
Mecca
slower than 82% of US
Posts: 8516
Joined: Wed December 19, 2012 7:17 pm

Re: 2015 NHL Franchise Tournament - DAY TWENTY-TWO RESULTS!

Post by Mecca »

damn, im barely holding off Lament at this point
Post Reply