FYC Golf Handicap Calculations

Golf Adj= New PHRF-Old PHRF

--DESCRIPTION--

Take the boat corrected time in seconds and subtract the base boat corrected time in seconds.

Divide by the course distance in nautical miles.

If this value is greater than -50 and less than 50 multiply by 0.1 and add result to old PHRF.

If this value is less than -50 multiply 50 by 0.1 and add result to old PHRF.

If this value is greater than 50 multiply -50 by 0.1 and add result to old PHRF.

The golf adjustment can be no greater or lesser than 50% of the boats base PHRF.

--FORMULAS--

New PHRF(Y6)=IF(A6<>1,"", ROUND(F6+ (0.1* IF(ABS(AB6)<50,AB6,IF(AB6>50,50,-50)) ) ,0) )

A6= participating boat if = 1

F6= boat race rating (old PHRF)

AB6(Win/lose sec/nm)= IF(A6<>1,"",(AA6-AB$2)/D$4)

win/lose sec/nm= (boat corrected sec-base boat corrected sec)/race distance

AA6= boat corrected sec

AB$2= base boat corrected sec

D$4= race distance