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?