Electronics > Projects, Designs, and Technical Stuff

Convert Acceleration into Displacement

(1/1)

**Billo**:

Is there an application that I can use to convert non-linear acceleration into displacement?

The data is acceleration vs time in CSV format.

I then want to view a chart of displacement vs time, either in the suggested application or else save the new data into a CSV file.

Thanks for any help you can give me, Bill.

**allanw**:

Just numerically integrate twice to get displacement. Take a running sum of the acceleration*timestep to get velocity, then running sum of velocity*timestep to get position. Should be doable in Excel. More info here:

http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=numerical+integration+excel

**Alex**:

Use the trapezoidal integration method using Excel and double integrate.

If you interested in the overall integral and not individual points, be careful with the integration results as integrations need a constant to be added to the result.

If you are looking at alternating acceleration (eg vibration), make sure your raw data doesnt have a DC offset. If not, force it to have a 0 mean value. Otherwise your displacement will shoot to an unrealistic value over time.

Alex.

**Mechatrommer**:

here, the least i can do. assuming you are collecting acceleratormeter data convert into acceleration and time interval are provided/calculated.

avst.jpg = the concept

avst.xls = the implementation (rough one)

**Billo**:

WOW !! Super Replies and Super Fast.

Thanks very much to you all.

Bill

Navigation

[0] Message Index

Go to full version