Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 16 to 30 of 33

Thread: 2017-2018 Same Night Tool

  1. #16
    Location
    Switzerland
    Rep Power
    15

    Dobber Sports Apprentice

    Default Re: 2017-2018 Same Night Tool

    Better late than never but... THANKS!

    Love this tool. Tomorrow is my first draft and this will come in handy.

  2. #17
    Figu's Avatar
    Figu is offline
    Join Date
    Sep 2017
    Posts
    49
    Location
    Helsinki
    Rep Power
    0

    Dobber Sports Novice

    Default Re: 2017-2018 Same Night Tool

    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)

  3. #18
    GSD's Avatar
    GSD is offline
    Join Date
    Oct 2015
    Posts
    2,256
    Location
    Hockeytown
    Rep Power
    35

    Dobber Sports Pro

    Default Re: 2017-2018 Same Night Tool

    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

  4. #19
    GSD's Avatar
    GSD is offline
    Join Date
    Oct 2015
    Posts
    2,256
    Location
    Hockeytown
    Rep Power
    35

    Dobber Sports Pro

    Default Re: 2017-2018 Same Night Tool

    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

  5. #20
    Location
    Prairies
    Rep Power
    40

    Dobber Sports Demi-God

    Default Re: 2017-2018 Same Night Tool

    Quote Originally Posted by GSD View Post
    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.
    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.

  6. #21
    Location
    Grand Rapids, MI
    Rep Power
    43

    Dobber Sports Initiate

    Default Re: 2017-2018 Same Night Tool

    Quote Originally Posted by GSD View Post
    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.
    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:


  7. #22
    GSD's Avatar
    GSD is offline
    Join Date
    Oct 2015
    Posts
    2,256
    Location
    Hockeytown
    Rep Power
    35

    Dobber Sports Pro

    Default Re: 2017-2018 Same Night Tool

    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

  8. #23
    GSD's Avatar
    GSD is offline
    Join Date
    Oct 2015
    Posts
    2,256
    Location
    Hockeytown
    Rep Power
    35

    Dobber Sports Pro

    Default Re: 2017-2018 Same Night Tool

    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

  9. #24
    Location
    Grand Rapids, MI
    Rep Power
    43

    Dobber Sports Initiate

    Default Re: 2017-2018 Same Night Tool

    Quote Originally Posted by GSD View Post
    Can't open this on my tablet.
    Do you have an MS Excel app on your tablet?
    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:


  10. #25
    Location
    Grand Rapids, MI
    Rep Power
    43

    Dobber Sports Initiate

    Default Re: 2017-2018 Same Night Tool

    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:


  11. #26
    GSD's Avatar
    GSD is offline
    Join Date
    Oct 2015
    Posts
    2,256
    Location
    Hockeytown
    Rep Power
    35

    Dobber Sports Pro

    Default Re: 2017-2018 Same Night Tool

    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

  12. #27
    GSD's Avatar
    GSD is offline
    Join Date
    Oct 2015
    Posts
    2,256
    Location
    Hockeytown
    Rep Power
    35

    Dobber Sports Pro

    Default Re: 2017-2018 Same Night Tool

    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

  13. #28
    GSD's Avatar
    GSD is offline
    Join Date
    Oct 2015
    Posts
    2,256
    Location
    Hockeytown
    Rep Power
    35

    Dobber Sports Pro

    Default Re: 2017-2018 Same Night Tool

    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.

  14. #29
    Location
    Grand Rapids, MI
    Rep Power
    43

    Dobber Sports Initiate

    Default Re: 2017-2018 Same Night Tool

    Quote Originally Posted by GSD View Post
    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:


  15. #30
    GSD's Avatar
    GSD is offline
    Join Date
    Oct 2015
    Posts
    2,256
    Location
    Hockeytown
    Rep Power
    35

    Dobber Sports Pro

    Default Re: 2017-2018 Same Night Tool

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •