$$HWI = (\textWind Speed \times \sin(\textAngle)) \times \textHWI Constant$$
Final Distance = Base Distance + Wind Effect + Elevation Effect – Backspin Effect – Club/Rare Bonus
Enter these formulas:
(0.5 is a sensitivity factor – calibrate per club in your version)
= (B6 * 0.3) * SIN(RADIANS(B7)) * (1 + (100 - VLOOKUP(B3, Clubs!A:E, 4, FALSE))/100)
$$HWI = (\textWind Speed \times \sin(\textAngle)) \times \textHWI Constant$$
Final Distance = Base Distance + Wind Effect + Elevation Effect – Backspin Effect – Club/Rare Bonus
Enter these formulas:
(0.5 is a sensitivity factor – calibrate per club in your version)
= (B6 * 0.3) * SIN(RADIANS(B7)) * (1 + (100 - VLOOKUP(B3, Clubs!A:E, 4, FALSE))/100)
