### Author Topic: Convert Acceleration into Displacement  (Read 6645 times)

0 Members and 1 Guest are viewing this topic.

#### Billo

• Newbie
• Posts: 2
##### Convert Acceleration into Displacement
« on: March 16, 2011, 09:41:13 am »
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.

#### allanw

• Frequent Contributor
• Posts: 343
##### Re: Convert Acceleration into Displacement
« Reply #1 on: March 16, 2011, 10:15:39 am »
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:

« Last Edit: March 16, 2011, 10:17:28 am by allanw »

#### Alex

• Guest
##### Re: Convert Acceleration into Displacement
« Reply #2 on: March 16, 2011, 12:57:12 pm »
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

• Super Contributor
• Posts: 11699
• Country:
• reassessing directives...
##### Re: Convert Acceleration into Displacement
« Reply #3 on: March 16, 2011, 02:52:25 pm »
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)
« Last Edit: March 16, 2011, 03:07:36 pm by Mechatrommer »
Nature: Evolution and the Illusion of Randomness (Stephen L. Talbott): Its now indisputable that... organisms “expertise” contextualizes its genome, and its nonsense to say that these powers are under the control of the genome being contextualized - Barbara McClintock

#### Billo

• Newbie
• Posts: 2
##### Re: Convert Acceleration into Displacement
« Reply #4 on: March 17, 2011, 08:32:12 am »
WOW !!  Super Replies and Super Fast.

Thanks very much to you all.

Bill

Smf