Complex wind calculations (true air speed) in excel

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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Dan Waterloo

Well-known Member
Joined
Jan 4, 2007
Messages
876
Hi pantsmonkey,

These functions are all available in Excel.
SIN is sin
COS is cos
ASIN is arcsin (the inverse sin funciton whiich is the same as sin to the negative, I believe, though my trig is a bit rusty here)
PI() is a funciton that returns the value of pi
SQRT returns the positive square root.

You can get B squared by writing B^2.

All the best.
 

Dan Waterloo

Well-known Member
Joined
Jan 4, 2007
Messages
876
There is also a RADIANS function you can use to convert degrees to radians and a DEGREES function to convert radians to degrees.
 

edvwvw

Active Member
Joined
Jan 30, 2007
Messages
278
This is a lot more complex than it first looks, you also need to know the altitude that your boss expects to fly as you will need to correct the speed:

Aircraft have 3 speeds - the speed that the aircraft thinks it is doing Indicated Air Speed

- the speed the air thinks the aircraft is doing True Air Speed (depends on Altitude and Temperature)

- The ground speed (depends on wind direction)

It strikes me that if your boss can afford an aircraft he can afford the relatively tiny amount for a proprietary piece of software.

edvwvw
 

mark hansen

Well-known Member
Joined
Mar 6, 2006
Messages
534
Office Version
  1. 2016
Platform
  1. Windows
There are many spreadsheets already done that have this stuff in there. I use one at home when "flying" Flight simulator.

Try Google(ing) "E6B spreadsheets"

Some even have knee board tabs to fill out and plop on the knee board where you can document VOR info and other frequencies informaiton along with wind speed info.
 

Forum statistics

Threads
1,181,647
Messages
5,931,210
Members
436,784
Latest member
amuljono

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