Results 1 to 7 of 7

Thread: NHL Fantasy Hockey 2016-2017: Pre-Draft Ranking Excel Guide

  1. #1
    Rep Power
    9

    Dobber Sports Novice

    Default NHL Fantasy Hockey 2016-2017: Pre-Draft Ranking Excel Guide

    Excel spreadsheet that will help you make decisions customized to your league's scoring system. Draft day will be all that more successful for you: http://4fandfurther.com/2016/09/07/n...ng-excel-guide

  2. #2
    Location
    Montreal, Canada
    Rep Power
    11

    Dobber Sports Blue-Chipper

    Default Re: NHL Fantasy Hockey 2016-2017: Pre-Draft Ranking Excel Guide

    Hey, first of all thanks for this tool.

    The idea is great but just a technical problem I seem to encounter.

    When I change to my pool stats it doesn't do anything to the ranking, it does not change at all. It says to change the point system in column B but the point colum is in fact the C (I dont know if that's the problem...)

    So.. what am I doing wrong?

    thanks
    16 teams Dynasty H2H, 25 Pro 17 Farm 4C 4LW 4RW 6D 1G 6B
    Cats: G, A, P, PPP, SOG, FW, HIT, BLK, W, GAA, SV%

    C: Mackinnon, Matthews, Seguin(RW), Stamkos(LW/RW), Couturier
    LW: E. Kane, Pacioretty, Rakell(RW), Miller(RW), Palat, Johnsson
    RW: Voracek, Dadonov(LW), Pavelski(C), Eberle, Olofsson
    D: Burns, Jones, Ristolainen, Gustafsson, Weber, Fowler, D.Toews
    G: Hellebucyk, Varlamov, Mrazek

    Farm: R.Suzuki, Garland, Kostin, A.Thomas, Appleton,
    Kahun, Marody, Dorofeyev, Paul, Lizotte, Fox, ¨Perunovich, Beaudin, Rosen, Walker, Brook

  3. #3
    Rep Power
    9

    Dobber Sports Novice

    Default Re: NHL Fantasy Hockey 2016-2017: Pre-Draft Ranking Excel Guide

    My apologies, make changes to column C and you're all good!

  4. #4
    Location
    Montreal, Canada
    Rep Power
    11

    Dobber Sports Blue-Chipper

    Default Re: NHL Fantasy Hockey 2016-2017: Pre-Draft Ranking Excel Guide

    Yeah, I did that but it didn't change anything. Where is it supposed to show the changes, in witch sheet? Thanks

  5. #5
    Rep Power
    9

    Dobber Sports Novice

    Default Re: NHL Fantasy Hockey 2016-2017: Pre-Draft Ranking Excel Guide

    It should change all fantasy points columns in the master summary and master 2014 2015 sheets. It may not be a noticeable change, try putting in 1000 for goals and it'll be obvious to see if it is flowing through

  6. #6
    Location
    Montreal, Canada
    Rep Power
    11

    Dobber Sports Blue-Chipper

    Default Re: NHL Fantasy Hockey 2016-2017: Pre-Draft Ranking Excel Guide

    its working but only in the master 2014 and 2015, not in the summary. thanks again for the help
    16 teams Dynasty H2H, 25 Pro 17 Farm 4C 4LW 4RW 6D 1G 6B
    Cats: G, A, P, PPP, SOG, FW, HIT, BLK, W, GAA, SV%

    C: Mackinnon, Matthews, Seguin(RW), Stamkos(LW/RW), Couturier
    LW: E. Kane, Pacioretty, Rakell(RW), Miller(RW), Palat, Johnsson
    RW: Voracek, Dadonov(LW), Pavelski(C), Eberle, Olofsson
    D: Burns, Jones, Ristolainen, Gustafsson, Weber, Fowler, D.Toews
    G: Hellebucyk, Varlamov, Mrazek

    Farm: R.Suzuki, Garland, Kostin, A.Thomas, Appleton,
    Kahun, Marody, Dorofeyev, Paul, Lizotte, Fox, ¨Perunovich, Beaudin, Rosen, Walker, Brook

  7. #7
    Rep Power
    9

    Dobber Sports Novice

    Default Re: NHL Fantasy Hockey 2016-2017: Pre-Draft Ranking Excel Guide

    the summary should be feeding from the master 2014 and 2015 sheets... try re downloading, maybe something got mixed up?

Posting Permissions

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