asked on

Excel Calculating linear motion

Hi I am trying to calculate the linear motion of an object. The object starts from point (x1) and accelerates uniformly (a1) it may reach its desired max speed (vmax) before decelerating (d1) or it may never reach vmax. It will end at position (x1+1)

Ive started to put this into excel but think Im getting lost. Im not sure if this is a suitable question for EE or if it is really better on a maths site?
Axis-Motion.xlsx

Naresh Patel

I suggest use =LINEST function of excel.

Danny Child

I'm not totally sure how your numbers are working, but having just been wading through this with my son's physics revision, this may be helpful...

http://www.bbc.co.uk/bitesize/higher/physics/mech_matt/analyse_motion/revision/2/

and I cobbled them together into this sheet.
ee-linear-velocity.xlsx

Danny Child

I've taken the 2nd question from that website, and used it to test the calcs, as it's the closest to the your scenario....

Danny Child

OK, didn't notice your attachment, but working on it now.
Looks a bit tricky, as in your example, your Start and End speed are both 0, so if I understand correctly, it will accelerate constantly to some interim point, then decelerate back to zero.

ASKER CERTIFIED SOLUTION

Danny Child

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

simonwait

ASKER

Thanks I will take a look in the morning when I'm reunited back with my laptop

Danny Child

how's it going with this? Thought my solution was quite tight here, anything else you need?