Thanks a lot! This is going to be very useful tool to gain an edge in competitive league.
Better late than never but... THANKS!
Love this tool. Tomorrow is my first draft and this will come in handy.
Thanks a lot! This is going to be very useful tool to gain an edge in competitive league.
16 team H2H each cat, partial keeper for players under 25 years in June
4C, 4RW, 4LW, 4D, 2G, 6 Bench
G, A, +/-, PIM, PPP, GWG, SOG, FOW, Hits, Blocks
W, SV, SO, GAA, SV%
5 keepers under 25 (June 1st). I have Svechnikov 19, Zadina 20, Comtois 21, Provorov 23, Pastrnak 24, Kase 24
G: Shesterkin, Saros
D: Carlson, Fox (K)
C: Trocheck
LW: Ovie, Huberdeau, Kaprizov (K), Farabee (K), Gurianov (K)
RW: Svechnikov (K)
Best tool out there!
HTH Daily League, 8 teams, (goals, ppp, +/-, assists, SOG, W, GAA, SV%) keepers in Bold.
C (s3) EP40, Trocheck, Marchessault LW, Horvat
LW (s3) Johnny Hockey, Parise, Terivinen RW, Meier RW
RW(s3) Wheeler C, Taresenko, Atkinson, Gallagher
Until(s1)
D (s4) Carlson, Yandle, Jones, Trouba
G Dubnyk, Rittich, Markstrom, Binnington
IR Ehlers, Hall
Anyone ever use this tool to see who plays the fewest Saturday games. This seems to be the only night I have to bench guys.
HTH Daily League, 8 teams, (goals, ppp, +/-, assists, SOG, W, GAA, SV%) keepers in Bold.
C (s3) EP40, Trocheck, Marchessault LW, Horvat
LW (s3) Johnny Hockey, Parise, Terivinen RW, Meier RW
RW(s3) Wheeler C, Taresenko, Atkinson, Gallagher
Until(s1)
D (s4) Carlson, Yandle, Jones, Trouba
G Dubnyk, Rittich, Markstrom, Binnington
IR Ehlers, Hall
Good thought.
With 31 NHL teams, there isn't an EVERY-TEAM-PLAYS night.
Here's the Saturday Off-Night Schedule:
10/7 - (1) BOS
10/14 - (3) ANA, DET, VGK
10/21 - (7) ANA, DET, COL, MON, NJ, VAN, WPG
10/28 - (7) CAR, CGY, VGK, DAL, OTT, VAN, WPG
11/04 - (5) CGY, DET, EDM, NYI, NJ
11/11 - (7) ANA, CGY, VGK, DAL, LA, TB, WAS
11/18 - (5) ANA, DET, VGK, CBJ, NYR
11/25 - (9) BOS, CAR, EDM, DAL, CBJ, NYR, NAS, PHI, VAN
12/02 - (7) COL, LA, VGK, NYI, OTT, NYR, WPG
12/09 - (7) ANA, BUF, CHI, MIN, NAS, PHI, WAS
12/16 - (9) BUF, DET, VGK, CHI, FLA, NJ, SJ, TOR, VAN
12/23 - (1) CGY
...
12/30 - (19)
1/6 - (13)
1/13 - (13)
More Saturday off-nights into calendar 2018, it seems.
That's as far as I'm going for now.
Vegas has a great start for avoiding Saturday night conflict.
Detroit also will provide good off-nights to start season.
Anaheim and Calgary as well.
The tool lists the number of games each team plays for all days of the week for the selected time range (columns J-P).
For example, from tonight (10/9/17) through the rest of the season (4/7/18), VGK plays the fewest (11) Saturdays. Pengwin came to this conclusion as well in his post.
VGK (11) LEAST
ANH (12)
DET (14)
...
MIN/TOR (22)
MTL/BOS (23)
ARI (24) MOST
As if we need anymore reason to avoid Arizona players...
14-Team H2H Limited Keeper League
Rosters: 3C, 5W, 4D, 1U, 2G, 5B, 2IR+, 1NA
Keep: 4 F, 2 D, 1 G
Skater Stats: G (3), A (2), +/- (0.3), PIM (0.4), PPP (0.5), SHP (1), GWG (1), SOG (0.3), Hits (0.1), Blks (0.25), FW (0.05)
Goalie Stats: W (5), SV (0.3), GA (-2), SHO (2)
C: Crosby, Zegras
W: Pastrnak, Keller
D: Karlsson, Montour
G: Oettinger
IR+:
NA:
Thanks, good stuff
HTH Daily League, 8 teams, (goals, ppp, +/-, assists, SOG, W, GAA, SV%) keepers in Bold.
C (s3) EP40, Trocheck, Marchessault LW, Horvat
LW (s3) Johnny Hockey, Parise, Terivinen RW, Meier RW
RW(s3) Wheeler C, Taresenko, Atkinson, Gallagher
Until(s1)
D (s4) Carlson, Yandle, Jones, Trouba
G Dubnyk, Rittich, Markstrom, Binnington
IR Ehlers, Hall
Can't open this on my tablet.
HTH Daily League, 8 teams, (goals, ppp, +/-, assists, SOG, W, GAA, SV%) keepers in Bold.
C (s3) EP40, Trocheck, Marchessault LW, Horvat
LW (s3) Johnny Hockey, Parise, Terivinen RW, Meier RW
RW(s3) Wheeler C, Taresenko, Atkinson, Gallagher
Until(s1)
D (s4) Carlson, Yandle, Jones, Trouba
G Dubnyk, Rittich, Markstrom, Binnington
IR Ehlers, Hall
14-Team H2H Limited Keeper League
Rosters: 3C, 5W, 4D, 1U, 2G, 5B, 2IR+, 1NA
Keep: 4 F, 2 D, 1 G
Skater Stats: G (3), A (2), +/- (0.3), PIM (0.4), PPP (0.5), SHP (1), GWG (1), SOG (0.3), Hits (0.1), Blks (0.25), FW (0.05)
Goalie Stats: W (5), SV (0.3), GA (-2), SHO (2)
C: Crosby, Zegras
W: Pastrnak, Keller
D: Karlsson, Montour
G: Oettinger
IR+:
NA:
Here's the updated version with the FLA/BOS game from 1/4 rescheduled for 4/8 (extending the NHL season by a day).
2017-2018 SNT Rev 3.zip
14-Team H2H Limited Keeper League
Rosters: 3C, 5W, 4D, 1U, 2G, 5B, 2IR+, 1NA
Keep: 4 F, 2 D, 1 G
Skater Stats: G (3), A (2), +/- (0.3), PIM (0.4), PPP (0.5), SHP (1), GWG (1), SOG (0.3), Hits (0.1), Blks (0.25), FW (0.05)
Goalie Stats: W (5), SV (0.3), GA (-2), SHO (2)
C: Crosby, Zegras
W: Pastrnak, Keller
D: Karlsson, Montour
G: Oettinger
IR+:
NA:
Opened it on my computer, and for those of you that want to know here is what I found out for 2/1 thru thru the end of the season:
Most Saturday games. Montreal, Toronto, Arizona at 10 each. Least number of Saturday games. Aneheim 4, Winnepeg, Vancouver, Vegas at 5.
Great tool.
HTH Daily League, 8 teams, (goals, ppp, +/-, assists, SOG, W, GAA, SV%) keepers in Bold.
C (s3) EP40, Trocheck, Marchessault LW, Horvat
LW (s3) Johnny Hockey, Parise, Terivinen RW, Meier RW
RW(s3) Wheeler C, Taresenko, Atkinson, Gallagher
Until(s1)
D (s4) Carlson, Yandle, Jones, Trouba
G Dubnyk, Rittich, Markstrom, Binnington
IR Ehlers, Hall
Taking it a step further,
best off night schedule (2/1 to end of season):
Aneheim 48, Calgary 39, Detroit 38
worst
Arizona 21, TB 22, Nashville 22
Idea for next year
Add a column for Saturday games, and a calculation box which will calc M,W,F, SU games at any point in time. This will make the tool relevant for the entire year.
Each tab already has column O which contains the number of Saturday games for each team.
Not sure what you mean by making the tool relevant for the entire year. The Starting and Ending Dates are modifiable so they can be changed to any date range you want, thus making them relevant for the entire year or a short period, it's all up to you.
The tool has columns for the number of games played on each day of the week but I could add a column with the sum of the Mon/Wed/Fri/Sun games to emphasize the off-day teams.
14-Team H2H Limited Keeper League
Rosters: 3C, 5W, 4D, 1U, 2G, 5B, 2IR+, 1NA
Keep: 4 F, 2 D, 1 G
Skater Stats: G (3), A (2), +/- (0.3), PIM (0.4), PPP (0.5), SHP (1), GWG (1), SOG (0.3), Hits (0.1), Blks (0.25), FW (0.05)
Goalie Stats: W (5), SV (0.3), GA (-2), SHO (2)
C: Crosby, Zegras
W: Pastrnak, Keller
D: Karlsson, Montour
G: Oettinger
IR+:
NA:
When I pull it up it allows you to plug in "teams" in the shaded blue areas. So as your drafting you can see how many conflicts there are. All I am saying is instead of manually adding all lof the off night games, it would be nice to have the excel program compute it.
HTH Daily League, 8 teams, (goals, ppp, +/-, assists, SOG, W, GAA, SV%) keepers in Bold.
C (s3) EP40, Trocheck, Marchessault LW, Horvat
LW (s3) Johnny Hockey, Parise, Terivinen RW, Meier RW
RW(s3) Wheeler C, Taresenko, Atkinson, Gallagher
Until(s1)
D (s4) Carlson, Yandle, Jones, Trouba
G Dubnyk, Rittich, Markstrom, Binnington
IR Ehlers, Hall