Forum Discussion
handicaps
as explained in the sheet can the things i am trying to do be possible it is to try and deduct or increase handicaps when scores are downloaded
Thanks to all for trying this
7 Replies
dawesy Not sure about the logic you describe in the file. I would expect the handicap to be reduced when points exceed 36 and increased when points are below 36. If that is correct, this formula will do just that:
=IF(Y9>36,(Y9-36)*-0.3,(36-Y9)*0.2)42 point will return -1.8 whereas 30 points will return 1.2
Hi Riny just wanted to let you that the progam you did for works exctly what i wanted this works for A grade players, We have a B grade players which handicaps are adjusted differantly (ie) thier haqndicaps are adjusted as follows over 36 points they loose 0.6 for each point over 36 and gain 0.3 for each point under 36 at present i have adjusted your formula =IF(Y9>36,(Y9-36)*-0.6,(36-Y9)*0.3) as that but had to put it in a seperate column just for B grade can that formula be put in as a one liner if not i will just do what i have done
Thanks for all your help it makes my job a lot easier and all can see how many or how few shots they lose as soon as the scores are entered
Thanks again Ian
- Hi Riny is a formula for stroke say par of 70 simular to the one for stableford tried doing the same works but puts plus instead of minus have altered the greater sign for less but wont put a minus sign to show that the handicap has been reduced any ideas thanks=IF(Y9<36,(Y9-36)*-0.6,(36-Y9)*0.3)
Ian
