Wind Calculator

[aviator]

Hi there, this is my forst time to the board. Hope you can help. I am a pilot and I am trying to write a wind calculator program for the Flight Planning Dept of my Company. This is the situation. Environment Canada issues winds (velocity and drection)for certain altitudes i.e. 12000 feet ASl 18000 feet ASL etc. This data is taken from hundreds of stations across Canada. They do not list all the altitudes though. My program will list the velocity and speed at the altitudes not given by Environment Canada. The math is very basic but the progam will save the dispatchers al lot of time. Here is my problem. Wind is given is degrees thus South equals 180, West 270 and North 360 etc. I was using this formula "=MOD(AVERAGE(B5,E5),360)" however wind always increases clockwise as the altitude increases. So if I have a wind at 12000 feet of 340 degrees and 010 degrees at 18000 the program will give an average of 175 which is mathematically correct but not realistic (it would be 355. How can I get the program to always add the average to the first variable...in this case the 340?

 

[Whisperer14]

Second half:

WindCalculator.xls
	A	B	C	D	E	F
24	ComputedWindat
25	FlightLevel	Direction	Velocity	FlightLevel	Direction	Velocity
26	120	290	50	260	290	117
27	130	290	55	270	290	121
28	140	290	60	280	290	126
29	150	290	64	290	290	131
30	160	290	69	300	290	136
31	170	290	74	310	290	140
32	180	290	79	320	290	145
33	190	290	83	330	290	150
34	200	290	88	340	290	155
35	210	290	93	350	290	159
36	220	290	98	360	290	164
37	230	290	102	370	290	169
38	240	290	107	380	290	174
39	250	290	112	390	290	178
FD 2 STNS

 

[aviator]

I was told I could "bump" this to have it looked at again.

I want to know how to modify A26 on, and B 26 on, if I have 3 sets of data in the top part of my sheet, meaning I can enter a wind if 12000 and 18000 from station a , b and c.