Almost there with this thanks to this forum:
What I need to do is:
Take 1 point off your handicap if you win the competion as well as the points for under par
in this example J McArdle won the comp, ie#1 in J10 so he should loose 1 from his handicap making his new handicap 12.5
but if his double bogie was less than par (D31) he should loose 1 for winning plus .2 for every shot under par.
So if his double bogie was 68 he would loose 71(D31)-0.6(he looses 0.2 for every shot under par)and -1 for winning
giving him a new handicap of 11.9
And if you know another way way doing the formulas post aswell because I'm trying to learn how good excel is
Bookmarks