Hello
I want to create a spreadsheet where i have a player listed in Column A, then Column B-S would have the "calculated" net score. So if the handicap is an 8, then the person gets a score of one stroke off the hardest 8 holes (1-8). See row 2 of attached.
If the handicap is a 24, then the golfer gets a score one off each score and then "two strokes " off handicap holes 1-6 as it would then "loop" back. Holes 1-6 person gets "two" strokes off, 7-18 one stroke
I have sheet 2 that lists the name and handicap. So if they see the name in column A, the vlookup the handicap and then calculate. So assume John Doe handicap is 8, then on hole 2, his net score would be "4". On
I want to create a spreadsheet where i have a player listed in Column A, then Column B-S would have the "calculated" net score. So if the handicap is an 8, then the person gets a score of one stroke off the hardest 8 holes (1-8). See row 2 of attached.
If the handicap is a 24, then the golfer gets a score one off each score and then "two strokes " off handicap holes 1-6 as it would then "loop" back. Holes 1-6 person gets "two" strokes off, 7-18 one stroke
I have sheet 2 that lists the name and handicap. So if they see the name in column A, the vlookup the handicap and then calculate. So assume John Doe handicap is 8, then on hole 2, his net score would be "4". On
Name | Hole 1 | Hole 2 | Hole 3 | Hole 4 | Hole 5 | Hole 6 | Hole 7 | Hole 8 | Hole 9 | Hole 10 | Hole 11 | Hole 12 | Hole 13 | Hole 14 | Hole 15 | Hole 16 | Hole 17 | Hole 18 |
Handicap | 13 | 1 | 5 | 7 | 9 | 2 | 10 | 11 | 12 | 17 | 18 | 3 | 4 | 6 | 8 | 14 | 15 | 16 |
John Doe score | 4 | 5 | 4 | 4 | 3 | 6 | 4 | 5 | 5 | 8 | 4 | 4 | 3 | 2 | 5 | 5 | 5 | 6 |
John Doe Net | ||||||||||||||||||
James Smith score | 4 | 5 | 4 | 4 | 3 | 6 | 4 | 5 | 5 | 8 | 4 | 4 | 3 | 2 | 5 | 5 | 5 | 6 |
James Smith Net | ||||||||||||||||||
Tony Jones score | 4 | 5 | 4 | 4 | 3 | 6 | 4 | 5 | 5 | 8 | 4 | 4 | 3 | 2 | 5 | 5 | 5 | 6 |
Tony Jones Net |