Converting wind direction to angles

[libertyforall]

I am trying to figure out the best way to convert column B
which has wind direction into degrees in a column C. I am using the
following conversion. My column A would have speed; column B would
have direction; column C would have direction in degrees according the
the conversion below.

N 0
NNE 22.5
NE 45
ENE 67.5
E 90
ESE 112.5
SE 135
SSE 157.5
S 180
SSW 202.5
SW 225
WSW 247.5
W 270
WNW 292.5
NW 315
NNW 337.5

 

[Ron Rosenfeld]

I am trying to figure out the best way to convert column B
which has wind direction into degrees in a column C. I am using the
following conversion. My column A would have speed; column B would
have direction; column C would have direction in degrees according the
the conversion below.

N 0
NNE 22.5
NE 45
ENE 67.5
E 90
ESE 112.5
SE 135
SSE 157.5
S 180
SSW 202.5
SW 225
WSW 247.5
W 270
WNW 292.5
NW 315
NNW 337.5

Use a simple lookup table.

In some unused part of your worksheet, M1:N16, for example, place the above
table.

Then use this formula:

C2: =VLOOKUP(B2,$M$1:$N$16,2,FALSE)

This will return #N/A if the entry in column B is not valid.
--ron

 

[Bernard Liengme]

And do remember that if you use trig functions, Excel want the angle in
radians. See functions RADIANS and DEGREES
best wishes

 

[patrick.van.santen]

Degree to Angles (and vv)

By just using the list as already displayed you will make mistakes. Degrees are ranged from 0-359 and angles are ranged from North to East to South to West and then on to North again, usually in steps of 22.5degrees (e.g. 2-strokes of 11.25degree, because in maritime terms a quadrant is subdivided in 4-strokes).

Thus in my view, the best way to organise your conversion will be to arrange intervals and assign any value in that interval to a certain angle, by using 1-stroke to the left and 1-stroke to the right.

N would then be identified with angles from >=348,75degree (e.g. 0 - 11,25) to <011,25degree.
NNE would then be [11,25 - 33,75) and so on.