alright!!!
can't wait to give it a spin tonight!!!
-thanks!
SCROLL DOWN FOR REV 2 OF THE TOOL. REV 1 WILL NOT CALCULATE THE DAYS OF THE WEEK CORRECTLY (EVERYTHING ELSE WORKS).
Here is the 2013-2014 Same Night Tool for everyone's enjoyment!
The MS Excel spreadsheet has instructions right on the page if you haven't used it in the past.
If anyone has any questions, issues, or better yet, suggestions for improvements, please do not hesitate to reply to this post or PM me.
Enjoy!
Last edited by rjfisher83; July 23, 2013 at 4:52 PM. Reason: Revision 2
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:
alright!!!
can't wait to give it a spin tonight!!!
-thanks!
Tool looks awesome. Thanks
Couple of questions
1. Just want to make sure I'm reading the results right. I punch in 2 positions, 2 rostered players, NYR and FLA. The results take hose two teams and put conflicts for every team. Example Anaheim has only 18 conflicts.
2. How do people typically deal with dual eligible players? I want to use it to maximize my roster based on my keepers.
Thanks again.
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! great tool... as always!
whats the addition of colums J - P??
18 team H2H Keeper League
G/A/PPP/SHP/GWG/SOG/FOW/Hits&blks/W/GAA/SV/SV%
play 4c/8w/6d/1G (2min start)/6 bench/
C: Hughes, Zacha, Howden, compher, Tierney, Frederic
W: Gaudreau, Schwartz, M.Tkachuk, Fabbri, Bratt, Yamamoto, Wahlstrom, Okposo, Heinen, M.Folingo, Hinostroza, Mcginn
D: Hughes, Ceci, Pelech, oleksiak, Holden, Poolman
G: Markstrom, Oettinger,
P:Rossi,Bowers,Heponiemi,Kupari,Wise,Dorofeyev,Fir stov,Clarke,Fortin,holloway,Nygard,Aberg,Rasmussen ,Elynuik,M.Jones,Chlapik,Platzer,Bracco,Kuokkanen, Lind,Liljegren,J.Roy,Montembeault,Raaymakers,Woll, prosvetov,Larmi
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:
cool thancs. that makes setting up things so much easier. good addition.
I couldn't have planned my summer trading better myself lol. I traded for Rask and then for Hiller. best combo of goalies. we start 1 a night. and then I have gustavsson as a 3rd option. 20 possible starts with 15 of those being b2b. if he gets the starts good to throw in another start here and there.
18 team H2H Keeper League
G/A/PPP/SHP/GWG/SOG/FOW/Hits&blks/W/GAA/SV/SV%
play 4c/8w/6d/1G (2min start)/6 bench/
C: Hughes, Zacha, Howden, compher, Tierney, Frederic
W: Gaudreau, Schwartz, M.Tkachuk, Fabbri, Bratt, Yamamoto, Wahlstrom, Okposo, Heinen, M.Folingo, Hinostroza, Mcginn
D: Hughes, Ceci, Pelech, oleksiak, Holden, Poolman
G: Markstrom, Oettinger,
P:Rossi,Bowers,Heponiemi,Kupari,Wise,Dorofeyev,Fir stov,Clarke,Fortin,holloway,Nygard,Aberg,Rasmussen ,Elynuik,M.Jones,Chlapik,Platzer,Bracco,Kuokkanen, Lind,Liljegren,J.Roy,Montembeault,Raaymakers,Woll, prosvetov,Larmi
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:
yeah got lucky actually. did those trades weeks ago lol. was trying to wait for this tool but couldn't pass up those deals.
18 team H2H Keeper League
G/A/PPP/SHP/GWG/SOG/FOW/Hits&blks/W/GAA/SV/SV%
play 4c/8w/6d/1G (2min start)/6 bench/
C: Hughes, Zacha, Howden, compher, Tierney, Frederic
W: Gaudreau, Schwartz, M.Tkachuk, Fabbri, Bratt, Yamamoto, Wahlstrom, Okposo, Heinen, M.Folingo, Hinostroza, Mcginn
D: Hughes, Ceci, Pelech, oleksiak, Holden, Poolman
G: Markstrom, Oettinger,
P:Rossi,Bowers,Heponiemi,Kupari,Wise,Dorofeyev,Fir stov,Clarke,Fortin,holloway,Nygard,Aberg,Rasmussen ,Elynuik,M.Jones,Chlapik,Platzer,Bracco,Kuokkanen, Lind,Liljegren,J.Roy,Montembeault,Raaymakers,Woll, prosvetov,Larmi
Yeah, adding Rask was a no brainer. The Hiller addition was luck with the schedule. Anaheim plays a lot of Sunday games again (13, tied for 2nd).
Anaheim must have some request with the NHL to have a lot of Sunday games or something because I notice this trend every year.
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:
18 team H2H Keeper League
G/A/PPP/SHP/GWG/SOG/FOW/Hits&blks/W/GAA/SV/SV%
play 4c/8w/6d/1G (2min start)/6 bench/
C: Hughes, Zacha, Howden, compher, Tierney, Frederic
W: Gaudreau, Schwartz, M.Tkachuk, Fabbri, Bratt, Yamamoto, Wahlstrom, Okposo, Heinen, M.Folingo, Hinostroza, Mcginn
D: Hughes, Ceci, Pelech, oleksiak, Holden, Poolman
G: Markstrom, Oettinger,
P:Rossi,Bowers,Heponiemi,Kupari,Wise,Dorofeyev,Fir stov,Clarke,Fortin,holloway,Nygard,Aberg,Rasmussen ,Elynuik,M.Jones,Chlapik,Platzer,Bracco,Kuokkanen, Lind,Liljegren,J.Roy,Montembeault,Raaymakers,Woll, prosvetov,Larmi
thanks rjfisher83.....i would not be able to compete without this tool.
10 team, H2H Points, Limited Keeper (1C,2W,2D,1G,1 non G)
18 man roster plus 2 IR spots [20 total]
start 2C, 4W, 4D, 2G; daily lineup changes
Stats: G,A,PPG,ENG,SHG,GWG,OTG,ShootOut Goals/Attemtps,Hat Tricks,+/-,FOW,PIMs,Majors,Misconducts,Hits,Blocked Shots
Goalies Stats: W,Saves,Goals Against,SO
C: Tavares, Koivu, Backstrom, Johansen
W: Lucic, Ladd, Eriksson, Komarov, Forsberg, Jenner
D: Hedman, Ekblad, Niskanen, Yandle, Campbell
G: Holtby, Schneider, Hammond
IR: Anderson, Faulk
FYI: I moved this thread from "General Hockey Chat" to "One-Year Leagues".
I think it is most valuable for one-year leagues and it will get buried quickly in General Hockey Chat.
My list of best "off-night" teams for Daily Start Leagues:
.268 Anaheim
.259 Calgary
.258 Chicago
.254 Vancouver
.254 Pittsburgh
.250 Detroit
.250 NY Rangers
.244 Winnipeg
.240 Ottawa
.238 Los Angeles
.238 Colorado
.234 Washington
.233 Philadelphia
.231 New Jersey
.229 Toronto
.229 Minnesota
.228 Buffalo
.226 Edmonton
.226 Columbus
.225 Carolina
.224 Montreal
.223 Boston
.222 San Jose
.220 Dallas
.219 Florida
.218 NY Islanders
.217 St.Louis
.217 Phoenix
.215 Nashville
.213 Tampa Bay
The formula is created using partials of each game day.
The partials from each game day are added/summed to create a score.
A team playing several games on an off-night gets a larger chunk of a score.
For example, the largest partial score is Anaheim's Wednesday night score of 0.067, for playing 12 Wed-games of the NHL's total 180 Wed-games.