The same spreadsheet formula using 180/PI() for MicroSoft and RADIANS for Open Office:-
=ROUNDUP(POWER(TAS,2)/((TAN(AoB/(180/PI())))*68625),3) MicroSoft EXCEL
=ROUNDUP(POWER(TAS;2)/((TAN(RADIANS(AoB)))*68625);3) Open Office CALC
TAS = KNOTS
AoB = DEGREES
RESULT = Turn Radius in Nautical Miles
Example TAS 240KTS AoB 25 degrees = 1.8NM (radius)
and if you REALLY want to use metric units, enter TAS in KMH and divide answer by 1.852, e.g.
=ROUNDUP(POWER(TASkmh,2)/((TAN(AoB/(180/PI())))*68625),3)/1.852
NOTE: BOAC's "back of the fag packet" method gives about the same result!
mm43
Last edited by mm43; 4th Oct 2009 at 20:17.
Reason: mod to metric formula