Forum Discussion

dawesy's avatar
dawesy
Brass Contributor
Mar 03, 2022

golf scorecard

i am trying to get a formula to score a golf scorecard where you put in the score for each hole and the program sorts out the score say if a par 4 is played as par and index is 4 and the handicap is ...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Mar 09, 2022

    dawesy You need to incorporate the "strokes received" formula into the overall points calculation. To calculate all in one formula is possible but the formula becomes quite complex. Better to add a row for each player where the points per hole are calculated and then added up in the end. You can alway hide these extra rows if you want.

     

    I took the liberty of changing some formats in your sheet 🙂

     

    Enjoy your golf!

phil49's avatar
phil49
Copper Contributor
Hi am trying to put % on my golf scorecard ie: take off 60% of the handicap
dawesy's avatar
dawesy
Brass Contributor
Nov 03, 2022

phil49 

hi there again have put a percentage formula in the scorecard i am sending you all set up all 

you need to do is put you handicaps in it gives you the new handicap in column D and leaves original

in column B rest of should be easy hope it works for you

 

Ian

  • volvoxc70's avatar
    volvoxc70
    Copper Contributor
    Nov 03, 2022
    Thanks very much ill see how its go's,
    thanks
    phil
    • dawesy's avatar
      dawesy
      Brass Contributor
      Nov 03, 2022

      volvoxc70 

      Hi there just looking at the scorecard i sent before found a fault in it so have redone it again this time 

      entered the formula in the handicap column and changed the other columns now it works for both

      stroke and stableford games. Just a matter of interest what game do you play with reducing handicaps 

      by 60% would like to know 

      Regards Ian

      • volvoxc70's avatar
        volvoxc70
        Copper Contributor
        Nov 04, 2022
        It's a Winter Eclectic match 50 players

Resources