I have been performing drop testing with a product. Collected data shows displacement during the freefall and deceleration to a stop. I've tried several methods of data smoothing and curve fitting. The best I have achieved gives incorrect initial velocity and acceleration.
In the image below, after smoothing (blue line), it shows an initial velocity rather an acceleration from zero. Any ideas on how to accomplish my goal would be appreciated. See the attached Mathcad Prime 9 document.
Thanks,
Bob
How should supersmooth know that you want a curve with a zero slope at t=0?
From the given data (red) it really does not look that way:
If you know the type of equation you expect for drop(t), you could try a non-linear regression to find its best fitting parameters using the measured data.
Just a question because I am confused: When I look at the Excel component
I can't see that you export column A to a variable "Time", Nonetheless variable "Time" with the correct unit seconds is defined after the Excel component. I wonder where an assignment like
which obviously must be present would hide ?? I was not able to find it even after resizing the component.
Hi Werner, I was certain you'd respond.
Time is in the output of the spreadsheet. Not sure why you don't see it.
It is always a challenge to make recorded data reflect reality. In reality, the drop starts from zero distance and proceeds. Noisy data makes it a challenge. With a pencil and paper, it is easy to draw lines over the data to make the curves. The challenge is getting the computer to understand what you eye sees intuitively.
Supersmooth does a nice job of making the line my eye sees. Unfortunately, I'm not being successful in taking that to the next step of deriving velocity and acceleration cleanly. I don't know if there is a better method of normalizing and fitting the data.
