Forum Discussion

dawesy's avatar
dawesy
Brass Contributor
Jan 28, 2023

handicaps

as explained in the sheet can the things i am trying to do be possible it is to try and deduct or increase handicaps when scores are downloaded Thanks to all for trying this 
Formulas and Functions
dawesy's avatar
dawesy
Brass Contributor
Feb 02, 2023
Hi Riny is a formula for stroke say par of 70 simular to the one for stableford tried doing the same works but puts plus instead of minus have altered the greater sign for less but wont put a minus sign to show that the handicap has been reduced any ideas thanks=IF(Y9<36,(Y9-36)*-0.6,(36-Y9)*0.3)
Ian
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 03, 2023

dawesy Sorry, but I don't really understand the question. Do you want to calculate a handicap adjustment based on strokes rather than points?

 

Par = 70

Current Hcp = 9

Gross score = 73

Net score = 73 - 9 = 64 (i.e. 6 strokes better than Hcp) 

What should be the reduction/increase per stroke better/worse than Hcp?

  • dawesy's avatar
    dawesy
    Brass Contributor
    Feb 03, 2023
    Hi Riny
    Yes thats correct same formula as the stableford one with (0.3 and 0.2 ) but with strokes taken off
    example =73-9=64 then the formula to take off with that score 0.3 for every point less than 70 or
    0.2 for every point over 70 when i tried the stableford formula you did for me it didn't put a minus sign in front of the handicap reduced it did the oposite put the minus sign in front of the handicap to be increased
    hope i have explianed better thanks again for assistance
    Ian
    • dawesy's avatar
      dawesy
      Brass Contributor
      Feb 03, 2023
      Hi Riny
      Just tried doing a few changes to the Formula you sent me and i think i have solved my problem
      please check the attached formula's Please
      This for “A” Grade just altered the *-0.3 to *0.3 and *0.2 to *-0.2 Appears to work ok
      =IF(AA10<70,(AA10-70)*0.3,(70-AA10)*-0.2)

      This for “B” Grade just altered the *-0.6 to *0.6 and *0.3 to *-0.3 Appears to work ok
      =IF(AA50<70,(AA50-70)*0.6,(70-AA50)*-0.3)
      If this is OK let me know Thanks for all your help
      Ian
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Feb 04, 2023

        dawesy It makes sense to switch the signs as more points is good just as less strokes are good. so they work in opposite ways.

         

        The points formula reads:

        IF points greater than 36 then reduce hcp else increase hcp.

         

        So, you could write the strokes formula as:

        IF net strokes greater than 70 then increase hcp else decrease hcp

         

        or if you prefer,

        IF net strokes less then 70 than reduce hcp else increase hcp

         

        Whatever you find easier to work with.

         

Resources