Nov 28 2022 08:59 AM
Hey all,
Looking for some help for a dynamics/mechanical engineering problem. I am trying to find the minimum stopping distance of a truck given two coefficients of static friction (mu) when a 50 kg sandbag is added 0.5 meters forward of the rear axle. The two coefficients represent two different tire brands.
I found an expression (that has been verified) to find the acceleration of the truck which I can then find velocity from. So once velocity is zero, I would look at the distance (s) and that is the minimum stopping distance.
I haven't set a spreadsheet up like this before and am having trouble doing so. My professor recommended making inputs, but that is again something I have never used. I appreciate any help you all can offer. Thanks!
Nov 28 2022 11:17 AM - edited Nov 28 2022 11:23 AM
@ngerdes so first off you say you found the correct equation for acceleration but I don't think so. It's been a loooong time since I took statics and dynamics but your sum of the Fy forces appears to add normal forces that are on an angle to the vertical with gravitational forces on the masses which are vertical ... I don't think they add that way. Further more you are summing them up equally and maybe they can or do end up summing that way but I suspect the whole point of specifically noting the location of the sandbag further back is to make you calculate the individual component values for the the normal forces on each pair of wheels. I am also confused because you are given coefficient of STATIC friction but the system is in motion so you should be using coefficient of dynamic friction (you know how it is harder to get something to start moving but once it is moving it is easier to keep it moving). So those issues aside I want to also introduce you to excel NAMES (if you don't know already). So under Formulas and then Name Manager. In this name manager you can add all the constants and then corresponding variables. For example:
As you can see I added a bunch of the constants and then started to add some calculated values like the highlighted line is the weight (force) of the sandbag so it is g * Smass. So instead of doing the calculation in a cell on the worksheet you can define it as a name. You could also do it in a cell (e.g. cell D5) and then you can define a name to be =$D$5 and then use that name.
Finally it appears the prof wants you to do a sequential formula where each row uses the previous row. So in the first row calculate or type the initial values (e.g. in D5 you type 29 or using the above names you could type =v_i). Then in D6 you type something like =D5 - acc * dt where acc is the acceleration and dt is the time delta. Then as you copy that cell down, each copy will refer to the cell above it (just like D6 referred to D5 then D7 will refer to D6 and so on).
I hope that helps.
Nov 28 2022 01:11 PM
@mtarler Thank you tons for introducing me to NAMES. I understand your concerns in the first portion of the comment and I thought the same thing at first. The sum of forces in the y-direction doesn't take into account the incline because of small angle approximation (i.e. it's really close to 1 so it would add unneeded complexity). For the coefficient of friction, we are assuming the truck is on an ice road and it's wheels are just about to slip, not already slipping because of modern technology like ABS. Hope that makes sense and makes you more confident in my equation.
I attached a few pictures of what my spreadsheet looks like and the equations/formulas I used. It seems like I went wrong somewhere because velocity drops to nearly zero immediately then rises as the cells move down. It should gradually decrease until velocity is zero, which would indicate the displacement (s) it traveled.
Nov 28 2022 03:31 PM