Velocity = Speed and direction
since we are going straight, Velocity=speed
V is in km/h
Potential energy is constant, at least as far as gravity is concerned, since we are not on a hill
Kinetic energy is 1/2*Mass*Velocity^2
KE=0.5mV^2
Mass is in kg (0.454 kg per lbm)
Velocity is in m/s (0.278 m/s per km/h)
KE is in Joules
Power is change in KE over time
P = (d/dt)KE
or
P = (KE2-KE1)/(T2-T1)
In units, Joules/s is Watts. (0.001341 Horsepower per Watt)
So, at each moment in time, as dictated by the timestamp during the acceleration run, we have Kinetic Energy. The change between any two points is Power.
Here's where the magic happens. During our acceleration run, we were accelerating the car's mass and seeing the results. But, we were also using power to overcome air drag, rolling resistance, etc. The way we account for this is the coast down. During the coast down, we are encountering the same air drag, rolling resistance, etc but instead of overcoming it, we are letting it slow us down.
By measuring the Power being used by drag forces to slow us down, we know how much extra power we used during our acceleration run. Using the GROWTH function in Excel, we can plot a decelleration curve, and more importantly, we can plug in discrete X-values (the velocity values for each timestamp in the acceleration run) to come up with timestamps for the decelleration that match up.