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!

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Mar 03, 2022

dawesy In words such a formula would be:

(Par + 2 + Strokes Received - Score) but not less than zero.

 

Attached a simple version of a such a scorecard 

  • dawesy's avatar
    dawesy
    Brass Contributor
    Mar 07, 2022
    Hi Riny tried to set up what you sent but no go think it needs a more complicated solution
    Thanks for your input
    Ian
    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Mar 07, 2022

      dawesy How complicated? You asked for a formula that takes Par, Stroke Index and Playing HCP into account. It can not be more complicated than that. Can you elaborate a bit more with regard how you want to use this formula and why it doesn't work for you?

      • dawesy's avatar
        dawesy
        Brass Contributor
        Mar 07, 2022
        How does it work when a player gets more than one shot a hole as some of our social players get up to 2 shots a hole on the index
        Thanks Ian

Resources