I see errors in the Excel file included in WoS for calculating the correction of altitude due to refraction.
1) The correction for refraction is to be applied on the apparent altitude (measured altitude minus the dip). It is not the case in the file
2) Parenthesis in the formula for defining the refraction correction is not correctly placed
1/TAN((B31+7,31/(B31+4,4)*PI()/180)) should be
1/TAN((B31+7,31/(B31+4,4))*PI()/180)
3) Apparent altitude in the formula is to be defined in Degree (°) (B31 here above in Degree). It is not the case in the file
It means that the correction due to refraction is totally wrong. Hopefully the influence of refraction on the final result (transfer on the azimuth line) is quite small
|