Research Project (Sorting Data, please advise)

JohnNash — Sun, 01 Dec 2013 03:35:46 GMT

Hello,

I am currently working on a research project where I have 9 rain gauges located throughout a farm where I will collect rainfall totals for a calendar year and do statistical analysis and determine the sensitivity of rain gauge measurements.

Here is my problem:

I have a spreadsheet which lists the rain gauge name, wind direction, windspeed, precipitation type, and precipitation amount for each rain event in a row. One thing I would like to do is plot the precipitation totals for specific wind directions (N, NE, E, SE, S, SW, W, and NW). How can I sum the precip totals for each individual storm event based on wind direction? For instance:

Rain Gauge Name Date dir_1 Type_1 Precip_1 Date_1 dir_2 Type_2 Precip_2
RG1 10/3/13 NE Rain 1.02 10/5/13 SE Rain 1.05

and I would like to plot only northeast winds first, then SE...etc..(obviously over the course of a year I will have many precipitation events)

I would like to map windspeed and precipitation type as well, however each gauge will have multiple events so how does one accomplish this task or sort the data?

topic Research Project (Sorting Data, please advise) in Mapping Questions

Research Project (Sorting Data, please advise)