M
Middlemix
I have a golf handicap spreadsheet with our own system for changing player
handicap.
The score is input into a a field, the average of that score is then worked
out in the next cell (from 12 players)
What i need to do from there is alter the players handicap. If the players
score is below or above 2 shot on the average then the handicap will stay the
same(bufferzone)
For every 1 shot below or above that, the players handicap will alter -0.2
or +0.2
i.e player handicap is 10, he scores 21 , the average scores on the day are
29.58
The buffer is 2 so the average is now 27.58 minus the score gives 6.58 this
then multiplyed by 0.2 gives an increase of 1.316. his handicap is then
revised to 22.3
I know it sound difficult but I know you lot are clever
Thanks
handicap.
The score is input into a a field, the average of that score is then worked
out in the next cell (from 12 players)
What i need to do from there is alter the players handicap. If the players
score is below or above 2 shot on the average then the handicap will stay the
same(bufferzone)
For every 1 shot below or above that, the players handicap will alter -0.2
or +0.2
i.e player handicap is 10, he scores 21 , the average scores on the day are
29.58
The buffer is 2 so the average is now 27.58 minus the score gives 6.58 this
then multiplyed by 0.2 gives an increase of 1.316. his handicap is then
revised to 22.3
I know it sound difficult but I know you lot are clever
Thanks