2
I have some data measured at non uniform time intervals, for example:
Time(s) Value(KB)
2.1 304
43.0 400
60.2 380
87.0 440
89.5 445
102.2 460
124.3 470
I have this in a CSV with the time increasing from T=0 as above, and I want to sample Value
at a periodic interval (60 seconds) to match some other data that I have.
I was trying to use Microsoft Excel 2007 to accomplish the task of reducing the data to just the values that are closest to each 60 second interval (there is a bit of data so whether it is always higher (124.3
), or lower (102.2
), or absolute value closest (124.3
), is not important). I have tried applying a formula to the Time column (MOD(Tn, 60)) but I cannot hit on a way to take this output (Time values cycling between 0 and 60) and filter out everything but the closest value to 60 in each cycle. Any suggestions?
Thanks! It was actually the wrong reference - it should have been
D1
instead ofA1
, i.e. figure out the delta between the full minute (D1) and the two closest matches. Fixed! – Peter Albert – 2013-01-23T10:22:07.547