how to filter excel data into constant time intervals and interpolate missing values

Hi there,

I got a large set of measured excel data that includes time in seconds and the deflection in mm in every 0.15 seconds. is there any way I can compute time and deflection for every 0.5 seconds? keeping in mind that because the data is in every 0.15 seconds, the code must be able to interpolate the value for 0.5 seconds, 1 second and so on till the data lasts?

Also please not that there might be some displacement data that is missing.

example of the first 10 data is given below.

time (s) Deflection [mm]

0 0

0.3079945 -

0.4427779 0.000990608

0.5901728 0.001493948

0.7378332 0.003823488

0.8852572 0.001567887

1.0328169 0.002345335

1.1806231 0.002779566

1.3286996 0.004666345

Answer 1

[Star Strider]

Use the Signal Processing Toolbox resample function. If you are doing signal processing, this is the only function that will produce appropriate results. It uses an anti-aliasing filter to prevent unwanted froquencies from being aliased into the output signal during the resampling process.