Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation help from average total
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I exclude a cell from an average calculation when the cell. | Excel Discussion (Misc queries) | |||
show in a excel graphic a total percentage for 5 diff data fiels | Charts and Charting in Excel | |||
Pivot Table -- Add column to average Grand Total | Excel Worksheet Functions | |||
Pivot Table - Average of counts | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |