pantsmonkey
Board Regular
- Joined
- Jul 2, 2002
- Messages
- 109
Hello folks my boss is at me to try and make manual flight calculations a thing of the past again. He has asked if I can locate a method of automating ground speed plus wind variations so he doesn't have to use a flight calculation slide rule.
I have located the required equations and am wondering if these calculations can be done using excel.
The mathematical formulas that equate to the results of the E6B wind calculator are as follows: (desired course is A, true airspeed is B, wind direction is C, wind velocity is D. A and C are angles. B and D are in any unit of speed you choose as long as it's used consistently). π is 3.14159...
Wind Correction Angle:
True ground speed:
Wind Correction Angle, in degrees, as it might be programmed into a computer (which includes conversion of degrees to radians and back):
True ground speed is calculated as:
Basically he will plonk in the direction hes going and the speed he is planning on traveling @ the wind and its speed into 4 different cells and it will calculate his true ground speed between the various way points on his journey.
I have located the required equations and am wondering if these calculations can be done using excel.
The mathematical formulas that equate to the results of the E6B wind calculator are as follows: (desired course is A, true airspeed is B, wind direction is C, wind velocity is D. A and C are angles. B and D are in any unit of speed you choose as long as it's used consistently). π is 3.14159...
Wind Correction Angle:
True ground speed:
Wind Correction Angle, in degrees, as it might be programmed into a computer (which includes conversion of degrees to radians and back):
True ground speed is calculated as:
Basically he will plonk in the direction hes going and the speed he is planning on traveling @ the wind and its speed into 4 different cells and it will calculate his true ground speed between the various way points on his journey.