[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
Solved

# Excel Calculating linear motion

Posted on 2014-01-28
Medium Priority
289 Views
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
0
Question by:simonwait
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 5

LVL 8

Expert Comment

ID: 39814807
I suggest use =LINEST function of excel.
0

LVL 23

Expert Comment

ID: 39815264
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
0

LVL 23

Expert Comment

ID: 39815330
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....
0

LVL 23

Expert Comment

ID: 39815362
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.
0

LVL 23

Accepted Solution

Danny Child earned 2000 total points
ID: 39815484
Try this.
It works on the basis of assuming you DO reach your Vmax, and then decelerate as defined.

It then works out the distance travelled, and if this is GREATER than your actual distance, it must therefore be in proportion to theoretical distance / actual distance.

I haven't added in the coasting bit, but presumably, under those terms, there are 3 stages:
accn until it reaches Vmax,
then coasts for precisely the correct time,
and thento allow for perfect deceleration to 0 within the overall time window.

not hard to calc...
ee-linear-velocity-2.xlsx
0

LVL 1

Author Comment

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

LVL 23

Expert Comment

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

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
###### Suggested Courses
Course of the Month14 days, 6 hours left to enroll