G
Guest
I need to calculate 24hr moving averages of several columns of imported data
(see example below).
Column A has date and time the data is collected, the data is initally in
approx. 15min cycles, but at the end of the data (about row 1100) data is in
hourly cycles. Occasionally the imported data does not record a date or time
and occasionally, cycles of data may be missed for various reasons.
Example:
Date and Time Elevation (mm) RL 24hr Av (mid)
5/11/2005 10:42 -2.7
5/11/2005 10:51 -0.5
5/11/2005 11:05 -0.5
5/11/2005 11:19 -0.8
5/11/2005 11:34 -0.3
5/11/2005 11:49 0
5/11/2005 12:12 -0.1
5/11/2005 12:26 -0.5
5/11/2005 12:40 -0.6
Note: date is Australian format = dd/mm/yyyy
The data is extensive and there is considerable scatter so I need to try and
develop a way that will accurately calculate the 24 hour moving average, that
accounts for the above irregularities and that can somehow be incorporated
into a dragable formula. Ultimately this will be plotted in a graph.
Is this possible in a formula??
cheers,
Nadia
(see example below).
Column A has date and time the data is collected, the data is initally in
approx. 15min cycles, but at the end of the data (about row 1100) data is in
hourly cycles. Occasionally the imported data does not record a date or time
and occasionally, cycles of data may be missed for various reasons.
Example:
Date and Time Elevation (mm) RL 24hr Av (mid)
5/11/2005 10:42 -2.7
5/11/2005 10:51 -0.5
5/11/2005 11:05 -0.5
5/11/2005 11:19 -0.8
5/11/2005 11:34 -0.3
5/11/2005 11:49 0
5/11/2005 12:12 -0.1
5/11/2005 12:26 -0.5
5/11/2005 12:40 -0.6
Note: date is Australian format = dd/mm/yyyy
The data is extensive and there is considerable scatter so I need to try and
develop a way that will accurately calculate the 24 hour moving average, that
accounts for the above irregularities and that can somehow be incorporated
into a dragable formula. Ultimately this will be plotted in a graph.
Is this possible in a formula??
cheers,
Nadia