Home |
Search |
Today's Posts |
#1
|
|||
|
|||
correcting wind direction data
is there an easy way using excel 2000 to correct wind direction data by 90
degrees to the left ( minus 90 degrees) we have a couple of years worth of 15min readings to correct. |
#2
|
|||
|
|||
You might be able to use the paste special command. In an empty cell put -90
(make it the same format as the data you want to change). Then copy it, highlight the cells you want to minus 90 from, and click EDIT, and then PASTE SPECIAL. Towards the bottom of the screen you will see a plus option which you click on and then push OK (or make the cell 90 and use the minus option). If this is confusing you can watch the PASTE SPECIAL video clip on http://www.auditexcel.co.za/othertools.html . "big eye" wrote: is there an easy way using excel 2000 to correct wind direction data by 90 degrees to the left ( minus 90 degrees) we have a couple of years worth of 15min readings to correct. |
#3
|
|||
|
|||
Big Eye,
How about just adding in another column and making it equal to the wind direction minus 90, then using that column for your calculations? Eric "big eye" wrote: is there an easy way using excel 2000 to correct wind direction data by 90 degrees to the left ( minus 90 degrees) we have a couple of years worth of 15min readings to correct. |
#4
|
|||
|
|||
I think you'll have to be more specific about how you entered the data and what
you want your data to look like when you're done. did you enter 0 to 360 -180 to 180 Or even N, E, NE, NNE, etc? big eye wrote: is there an easy way using excel 2000 to correct wind direction data by 90 degrees to the left ( minus 90 degrees) we have a couple of years worth of 15min readings to correct. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I import formmail data to a custom excel template? | Excel Worksheet Functions | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions |