Calculation help from average total
How about
=player_score+((average_score-2)-player_score)*0.2
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Middlemix" wrote in message
...
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
|