Forum Discussion
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 8 player does not get a shot on hole so he only scores a 4, and 2 points if he gets a shot on the hole he would score 4, and 3 points this would
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!
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
- Hi Riny tried to set up what you sent but no go think it needs a more complicated solution
Thanks for your input
Iandawesy 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?
- Hi am trying to put % on my golf scorecard ie: take off 60% of the handicap
- Thanks very much ill see how its go's,
thanks
phil
you can easily make a best cavity back golf irons charts and also other things charts individually it is so easy to do. Not a big deal
