Red Mosquito

and now ive caught up the oilers. Its crazy how fast these days add up if you dont do them right away.

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.

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.

@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

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

p-p-p-p-playoff push!

yay, updated my stats on the day they happened. That's way easier

Mecca wrote:p-p-p-p-playoff push!

I'm in my late season push to get out of the basement.

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?

@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.

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.

whatever you guys decide.

yeah, I'm ok if you want to go to 48.
I can hardly stay on top of my stats as it is.

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

i think we should shorten it, as well. this may come back to bite me, but i think a close race is more fun

Mecca wrote: bite me

E.H. Ruddock wrote:

Mecca wrote: bite me

Aww. I miss that fuzzy little guy.

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

damn, im barely holding off Lament at this point