Brian C.

asked • 12/20/23

Non-Constant Acceleration of a Car Drag Racing on a Quarter Mile Track. What am I doing wrong?

I'm a retired engineer and my hobby is racing my Cadillac at the local quarter mile track. Being a numbers geek by training I decided to write an Excel program that could take my time slip and spit out all kinds of interesting data to show how my car was performing and how any modifications effected that performance.


Here is a typical Time Slip I get at the end of my Quarter Mile Pass:

0s 0'

1.490s 60'

4.426s 330'

6.789s 660' 104.23mph

8.802s 1000'

10.505s 1320' 133.09mph


Put this Time vs Position data into Excel and it will provide you w/ (I'm using a 5th Degree Polynomial)


y = -.0002x^5+.0134x^4-.5431x^3+14.532x^2+19.778x and an R^2 = 1


all nicely plotted out for you on a graph.


I chose to take .0011s snapshots of my POSITION and the TIME it took to get there as I go down the track.


Then I take the First Derivative of the above function to get my Velocity at any position along the way.


Easy enough.


I seem to run into a problem when I take the Second Derivative of the above function to obtain the Acceleration of my car at any Position along the Track.


The Acceleration behaves as it should by slowly decreasing as I travel down the track due to Aero and Rolling Drag (I introduce Rolling Resistance and Aerodynamic Drag into program) but for some reason as I approach the around 1000' the Acceleration begins to increase. Sometimes a small amount and other times by crazy amounts.


The problem arises when calculating HP and you need an accurate Acceleration Value and the values I get at the end of the track result in my car having 900 HP when it is closer to 635.


What am I doing wrong?


Is this not a classic example of the Position, Velocity Acceleration physics problem we all had in College where calculus shows us that Velocity is the First Derivative of Position and Acceleration is the Second Derivative of Position.


What assumptions am I making that are wrong?


Am I over / under parametrizing?


Is a Polynomial function the best approach or should I be using a Power Function?


HELP!



2 Answers By Expert Tutors

By:

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.