Convert number in (Deg) to direction (Text) N, NNE,...

[Haf]

Hello,

I was wondering if it was possible to convert wind direction in Deg (Number) to wind direction in Text (N,NNE,...) using Excel.

Thanks

Haf

 

[3cupsCoffey]

Use polar coordinates, (r, THETA), and plug THETA (in degrees) into the formula above and that should work.

Cheers,
~ Jim

I dont think i know what that means

 

[jamcall]

Cartesian Coordinates are in (x,y) = distance along x-axis and distance along y-axis.
Polar Coordinate are in (r, Theta) = distance from origin and angle from positive y-axis.

Going from point 1 (x1, y1) to point 2 (x2, y2), calculate a third (point 3) as (x3, y3) where x3 = x2 - x1 and y3 = y2 - y1.

The distance between the points, r, is =SQRT(x3^2+y3^2) from Pythagorean Thm

The angle from one to the other, Theta, is =DEGREES(ATAN2(x3, y3)).

Feed this value into the formula from earlier in the post to obtain your cardinal direction.

HTH,
~ Jim

 

[3cupsCoffey]

Cartesian Coordinates are in (x,y) = distance along x-axis and distance along y-axis.
Polar Coordinate are in (r, Theta) = distance from origin and angle from positive y-axis.

Going from point 1 (x1, y1) to point 2 (x2, y2), calculate a third (point 3) as (x3, y3) where x3 = x2 - x1 and y3 = y2 - y1.

The distance between the points, r, is =SQRT(x3^2+y3^2) from Pythagorean Thm

The angle from one to the other, Theta, is =DEGREES(ATAN2(x3, y3)).

Feed this value into the formula from earlier in the post to obtain your cardinal direction.

HTH,
~ Jim

I guess where I'm confused is where to add that value in the formula. I have successfully done the (r, thea)

I don't want to be of bother to you so I understand if I'm below a level of assistance lol.

Do i need to have (r,thea) in one column? right now i have it as R in a column and THEA in a column with a distance (in miles) in the third column first cell... maybe I'm creating the layout/table in error as well?

 

[jamcall]

I guess where I'm confused is where to add that value in the formula. I have successfully done the (r, thea)

I don't want to be of bother to you so I understand if I'm below a level of assistance lol.

Do i need to have (r,thea) in one column? right now i have it as R in a column and THEA in a column with a distance (in miles) in the third column first cell... maybe I'm creating the layout/table in error as well?

In whichever cell you want the cardinal direction to display, put the following formula from post #8 of this thread:

Code:
=CHOOSE(1+ROUND(A1/22.5,0),"N","NNE","NE","ENE","E","ESE","SE","SSE","S","SSW","SW","WSW","W","WNW","NW","NNW","N")

instead of A1 use the reference to your cell that contains Theta.

 

[3cupsCoffey]

In whichever cell you want the cardinal direction to display, put the following formula from post #8 of this thread:



instead of A1 use the reference to your cell that contains Theta.

ooooh my gosh, i'm such a dork. Yes, that makes plenty sense now. i was making it way harder than it needed to be when I read it. Thank you SOO much for your help.