SOLVED

golf scorecard

%3CLINGO-SUB%20id%3D%22lingo-sub-3243650%22%20slang%3D%22en-US%22%3Egolf%20scorecard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3243650%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20am%20trying%20to%20get%20a%20formula%20to%20score%20a%20golf%20scorecard%20where%20you%20put%20in%20the%20score%20for%20each%20hole%20and%20the%20program%20sorts%20out%20the%20score%20say%20if%20a%20par%204%20is%20played%20as%20par%20and%20index%20is%204%20and%20the%20handicap%20is%208%20player%20does%20not%20get%20a%20shot%20on%20hole%20so%20he%20only%20scores%20a%204%2C%20and%202%20points%20if%20he%20gets%20a%20shot%20on%20the%20hole%20he%20would%20score%204%2C%20and%203%20points%20this%20would%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3243650%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3244291%22%20slang%3D%22en-US%22%3ERe%3A%20golf%20scorecard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3244291%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1322453%22%20target%3D%22_blank%22%3E%40dawesy%3C%2FA%3E%26nbsp%3BIn%20words%20such%20a%20formula%20would%20be%3A%3C%2FP%3E%3CP%3E(Par%20%2B%202%20%2B%20Strokes%20Received%20-%20Score)%20but%20not%20less%20than%20zero.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20a%20simple%20version%20of%20a%20such%20a%20scorecard%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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 

11 Replies

@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
Ian

@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?

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

@dawesy Ooops! Forgot about that. Changed the formula to allow for up to three strokes over par.

 

@Riny_van_Eekelen  

Hi attached is a copy of the scorecard i wish to use as you see there are a number of players and i am not sure how to insert your formula the one you sent me works ok except for someone who doesn't get a shot on a particular hole i would be very appreciative if you could work out to the formula to work on my scorecard 

Sincerly hoping  Ian

best response confirmed by Hans Vogelaar (MVP)
Solution

@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!

Hi just received your reply had a quick look and looks good will continue with the rest when I get time and let you know how I go
Thanks for your input hope i don't mess things
Cheers Ian
Hi Riny have used the system you sent and very pleased with it i am very grateful for all you have done for me can't thank you enough hopefully i don't do anything silly and ruin all you have done
Again thank you
Ian

@dawesy Glad to hear it worked!

Thanks could not have done it without you Thanks again
Ian