S
Scott
This seems like it would be very easy, but apparently it's either not, or I'm
not thinking clearly.
Cells A2:A19 have the Hole # followed by the hole handicap (ranked 1 through
18, 1 being most difficult): So, in this example, let's say that the
following information is true for cells A2:A19:
1- HCP 11
2- HCP 17
3- HCP 3
4- HCP 1
5- HCP 13
6- HCP 7
7- HCP 5
8- HCP 15
9- HCP 9
10- HCP 4
11- HCP 18
12- HCP 2
13- HCP 10
14- HCP 16
15- HCP 8
16- HCP 14
17- HCP 6
18- HCP 12
Now, let's assume that our sample golfer has a 27 handicap, meaning he will
receive 1 shot on holes 1-18, and receive 1 shot on the HCP holes ranked 1-9.
So, in our example, he would receive 1 shot on #1, 1 shot on #2, 2 shots on
#3, 2 shots on #4, and so on...
What formula would I use to calculate the number of shots player would
receive on each hole? Any ideas?
not thinking clearly.
Cells A2:A19 have the Hole # followed by the hole handicap (ranked 1 through
18, 1 being most difficult): So, in this example, let's say that the
following information is true for cells A2:A19:
1- HCP 11
2- HCP 17
3- HCP 3
4- HCP 1
5- HCP 13
6- HCP 7
7- HCP 5
8- HCP 15
9- HCP 9
10- HCP 4
11- HCP 18
12- HCP 2
13- HCP 10
14- HCP 16
15- HCP 8
16- HCP 14
17- HCP 6
18- HCP 12
Now, let's assume that our sample golfer has a 27 handicap, meaning he will
receive 1 shot on holes 1-18, and receive 1 shot on the HCP holes ranked 1-9.
So, in our example, he would receive 1 shot on #1, 1 shot on #2, 2 shots on
#3, 2 shots on #4, and so on...
What formula would I use to calculate the number of shots player would
receive on each hole? Any ideas?