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