Thank you for reading my post and hopefully you will be able to help me.
To give you some context here, I want to compare two separate golf games, played on two separate golf courses by two separate people e.g. I play in Scotland and my Granddad plays in America.
I am looking for a way to calculate the following outcomes during a game of golf:
- a comparison for each hole on its own (e.g. he won hole 1) when they will potentially not be the same par or difficulty
- a comparison of the whole game (all 18 holes combined, I won) when they will potentially not be the same par or difficulty
I say "potentially" but in reality they will definitely be different!
Maybe I'm really looking for an algorithm?
The usual route is to compare your "net score" (how many shots you hit less your handicap) with the varying "net score" of your friend. While this is acceptable if you played together at the same time on the same course, this is not accurate enough when the two golf courses are different and so is the weather!
I would like the results to to be directly comparable, so perhaps giving the players a rating out of 100% for each hole and the course in whole? I also want to have this calculation work for any course (after updating the par, etc of each) and to be able to be used for comparison of a large group of people (not just two as maybe Dad will also play one day in Italy, etc).
I want this calculation/s to work for any two golf courses anywhere in the world and the information I have to use is as follows:
- the distance for each hole (yards)
- the entire course distance (yards)
- the total course par
- each hole par (usually 3, 4 or 5)
- each hole stroke index (the whole ordered in their difficulty, with the hardest hole rated 1 and the easiest hole rated 18)
- the weather of the day in question e.g. light rain, heavy rain
- the weather for each hole e.g. light rain, dry, sunny
- course type (links, parkland, desert)
If someone can give me an easy-to-understand equation with changeable elements shown like ' "hole one par" / "total course par" ' (I am an extremely competent Excel user, but not an amazing mathematician) I would be incredibly grateful.
I think this is a fun problem to think about. . . right? Hehe.
I can reward with UK taxation or accounting answers if needed as I run my own business!