Coding data

U

UniStudent Coll

I have compass bearing wind direction forecast measurements with an accuracy
to one degree. Which is being compared to obserevd wind directions which is
recorded in the 16 points of the compass.

Using EXCEl 2007 I need to convert the forecast into the same format with
the following intervals to convert into the name next to it:

348.75-11.24 N
11.25 - 33.74 NNE
33.75 - 56.24 NE
56.25 - 78.74 ENE
78.75 - 101.24 E
101.25 - 123.74 ESE
123.75 - 146.24 SE
146.24 - 168.74 SSE
168.75 - 191.24 S
191.25 - 213.74 SSW
213.75 - 236.24 SW
236.25 - 258.74 WSW
258.75 - 281.24 W
281.25 - 303.74 WNW
303.75 - 326.24 NW
326.25 - 348.74 NNW

The other problem is that it is in degrees and im not sure if this will work
in this format in excel? ANy help would be greatly appreciated....
 
N

Niek Otten

Make a table in two columns like this:
0 N
11.25 NNE
33.75 NE
56.25 ENE
78.75 E
101.25 ESE
123.75 SE
146.24 SSE
168.75 S
191.25 SSW
213.75 SW
236.25 WSW
258.75 W
281.25 WNW
303.75 NW
326.25 NNW
348.75 N

With the degrees (as a normal number) in C1:
=VLOOKUP(C1,$A$1:$B$17,2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel



|I have compass bearing wind direction forecast measurements with an accuracy
| to one degree. Which is being compared to obserevd wind directions which is
| recorded in the 16 points of the compass.
|
| Using EXCEl 2007 I need to convert the forecast into the same format with
| the following intervals to convert into the name next to it:
|
| 348.75-11.24 N
| 11.25 - 33.74 NNE
| 33.75 - 56.24 NE
| 56.25 - 78.74 ENE
| 78.75 - 101.24 E
| 101.25 - 123.74 ESE
| 123.75 - 146.24 SE
| 146.24 - 168.74 SSE
| 168.75 - 191.24 S
| 191.25 - 213.74 SSW
| 213.75 - 236.24 SW
| 236.25 - 258.74 WSW
| 258.75 - 281.24 W
| 281.25 - 303.74 WNW
| 303.75 - 326.24 NW
| 326.25 - 348.74 NNW
|
| The other problem is that it is in degrees and im not sure if this will work
| in this format in excel? ANy help would be greatly appreciated....
 
Top