Complex wind calculations (true air speed) in excel

Status
Not open for further replies.

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:
8e453d6b7f834fdf91f19f807fb77f51.png


True ground speed:
76f35d3591271e5150b5c0b6485a58e0.png


Wind Correction Angle, in degrees, as it might be programmed into a computer (which includes conversion of degrees to radians and back):
125cff47d4b5752a3aa09be526c72358.png


True ground speed is calculated as:
11229726db6f16be1fc23814b3783c1a.png


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.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,452
Office Version
  1. 365
  2. 2021
  3. 2016
Platform
  1. Windows
Hi

The formulas you provided give the answer you need. If you substitute the WCA from the first formula into the second then you can use the standard excel functions to calculate the GS. Sin and cos are standard Excel functions, as is sqrt - the only tricky part is the sin to the power of negative 1 - this is merely shorthand notation for arcsin, for which Excel uses the asin function.

I recommend you give it a go and post back if you need any help. I would also recommend your boss compare his manual calculation to yours to make sure everything is a ok!

Andrew
 
Status
Not open for further replies.

Forum statistics

Threads
1,181,730
Messages
5,931,707
Members
436,799
Latest member
BasOo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top