Red Mosquito

southp wrote:

philpritchard wrote:

Mecca wrote:I thought I had Hasek in as my starter?

It had Miller there when I loaded it. Maybe it doesn't save it the same way it does for baseball.

From now on, I guess I'll just have everyone tell me if they want a goalie change.

hey Phil, I wouldn't mind seeing Dryden as my starter instead of Plante. Let me know if you can make the swap.

I can!

I think I mentioned this before, but I won't likely be able to run games on weekends. Unfortunately, that means I can't do any until Tuesday. I'm ok with someone taking over and running the next few days, too, if we have a volunteer.

I can't find an effective way to make a formula for GAA in the spreadsheet due to the time format being Hours Minutes Seconds and converting that into a full game =60 minutes. I guess I can fudge it and just do GoalsAllowed/W+L, but I wanted to get accurate to account for playing in OT/pulling goalie bringing the number of games into a fractional number

I may just to have to manually do it, but I think making a category of Games Equivalent Played and using that to divide the goals is effective. I'm going to have to play around with the numbers some more to see if i found the number you need to divide the time data by to find the GEP stat

TOI/2.50061249489587 is what I used to get an accurate number for GEP, so its probably safe to just use 2.5

Mecca wrote:I may just to have to manually do it, but I think making a category of Games Equivalent Played and using that to divide the goals is effective. I'm going to have to play around with the numbers some more to see if i found the number you need to divide the time data by to find the GEP stat

I think the way I did it is I created a formula that includes minutes played and I can just manually update the total whenever I want.

also, what do the stats QS and RBS mean? is that a carryover from baseball?

philpritchard wrote:

Mecca wrote:I may just to have to manually do it, but I think making a category of Games Equivalent Played and using that to divide the goals is effective. I'm going to have to play around with the numbers some more to see if i found the number you need to divide the time data by to find the GEP stat

I think the way I did it is I created a formula that includes minutes played and I can just manually update the total whenever I want.

TOI/2.5 seems to be the formula for games equivalent played

Vanek has been solid for me despite limited PP time

Mecca wrote:also, what do the stats QS and RBS mean? is that a carryover from baseball?

QS and Really bad start. I was just looking for things to add for the goaltenders that would automatically populate with the entered data. They're real things.

I guess since I made a space for OTL now, we can count them.

Phil doesn't count Friday as the weekend, does he?

He must have taken Good Friday.

RM doesn't observe religious holidays

I think RM does in Canada.

I'll probably run the sims tomorrow if I can

Yeah, sorry guys... 4 day weekend here, and I only really have my phone.

Day 4 Results!

Quebecorado Nordalanche @ Toronto Maple Leafs
Game 1: http://www.whatifsports.com/nhl/boxscor ... teamfee=-1

Spoiler: show

Nordalanche - 8
Leafs - 6

Stars:
1. Michel Goulet (Nordalanche)
2. Darryl Sittler (All-Time Leafs)
3. Charlie Conacher (All-Time Leafs)

Game 2: http://www.whatifsports.com/nhl/boxscor ... teamfee=-1

Spoiler: show

Nordalanche - 5
Leafs - 4

Stars:
STARS OF THE GAME
1. Mats Sundin (Nordalanche)
2. Charlie Conacher (All-Time Leafs)
3. Darryl Sittler (All-Time Leafs)

Montreal Canadiens @ Detroit Red Wings
Game 1: http://www.whatifsports.com/nhl/boxscor ... teamfee=-1

Spoiler: show

Red Wings - 7 (OT)
Habs - 6

Stars:
1. Gordie Howe (SkitchPWings)
2. Henrik Zetterberg (SkitchPWings)
3. Paul Coffey (SkitchPWings)

Game 2: http://www.whatifsports.com/nhl/boxscor ... teamfee=-1

Spoiler: show

Red Wings - 5
Habs - 4

Stars:
1. Gordie Howe (SkitchPWings)
2. Vincent Damphousse (Habs24)
3. Henrik Zetterberg (SkitchPWings)

Buffalo Sabres @ Pittsburgh Penguins
Game 1: http://www.whatifsports.com/nhl/boxscor ... teamfee=-1

Spoiler: show

Buffalo - 4
Pittsburgh - 6

Stars:
1. Mario Lemieux (Get Ur Le Maginifique On)
2. Kevin Stevens (Get Ur Le Maginifique On)
3. Sidney Crosby (Get Ur Le Maginifique On)

Game 2: http://www.whatifsports.com/nhl/boxscor ... teamfee=-1

Spoiler: show

Buffalo - 6
Pittsburgh - 7

Stars:
1. Kevin Stevens (Get Ur Le Maginifique On)
2. Alexander Mogilny (Sabre Tooths)
3. Jason Pominville (Sabre Tooths)

Chicago Blackhawks @ Dallas Stars (The Belfour Bowl!)
Game 1: http://www.whatifsports.com/nhl/boxscor ... teamfee=-1

Spoiler: show

Chicago - 3
Dallas - 5

Stars:
1. Mike Modano (Starss)
2. Joe Nieuwendyk (Starss)
3. Jere Lehtinen (Starss)

Game 2: http://www.whatifsports.com/nhl/boxscor ... teamfee=-1

Spoiler: show

Chicago - 5
Dallas - 8

Stars:
1. Pat Verbeek (Starss)
2. Paul Cavallini (Starss)
3. Darryl Sydor (Starss)

New York Islanders @ Boston Bruins
Game 1: http://www.whatifsports.com/nhl/boxscor ... teamfee=-1

Spoiler: show

NYI - 6
Boston - 5

Stars:
1. Brent Sutter (Who's the Bossy)
2. Cam Neely (WInning By Numbers)
3. Phil Esposito (WInning By Numbers

Game 2: http://www.whatifsports.com/nhl/boxscor ... teamfee=-1

Spoiler: show

NYI - 7 (OT)
Boston - 6

Stars:
1. Mike Bossy (Who's the Bossy)
2. Ken Hodge (WInning By Numbers)
3. Joe Thornton (WInning By Numbers)

St. Louis Blues @ Edmonton Oilers
Game 1: http://www.whatifsports.com/nhl/boxscor ... teamfee=-1

Spoiler: show

STL - 2
EDM - 8

Stars:
STARS OF THE GAME
1. Mike Comrie (SkitchPOilers)
2. Jari Kurri (SkitchPOilers)
3. Paul Coffey (SkitchPOilers

Game 2: http://www.whatifsports.com/nhl/boxscor ... teamfee=-1

Spoiler: show

STL - 5
EDM - 7

Stars:
1. Glenn Anderson (SkitchPOilers)
2. Mark Messier (SkitchPOilers)
3. Wayne Gretzky (SkitchPOilers)

4-0 today!

Apparently, these Bruins are much like the real Bruins.

@SkitchP wrote:4-0 today!

I'm worried about playing the Wings in the next matchup. This is my dream result http://www.whatifsports.com/nhl/boxscor ... teamfee=-1

I think I am going to stick with Hasek from here on out.