Hi, I am looking for an excel spreadsheet which calculates a golfers handicap and stores their latest 20 scores, when the total reaches 21 the oldest score must be dropped from the list.
Attached is the formula for calculating golf handicaps and also attached is an image screenshot of the type of design layout I am looking for.
Please only use the Stroke Play differential calculation, do not worry about Stableford or Par.
The spreadsheet also has to calculate all scores as 72 Par, 18 Hole course, ie if someone only plays 9 holes on a 34 Par course the Adjusted Score must reflect a 72 Par, 18 Hole score. For example if I scored 50 on 9 Holes on a Par 34 course a calculation might be (50/34)x72 = 105.88 which would be the score for 18 holes on a Par 72 course.
The player should only have to enter Course Name, Date (calendar feature), Course Par, Scratch Rating (if applicable) and Gross Score, the rest should be automatic.
Please make as simplisic as possible as the target audience is 30-60 years old.