Starting from this question I am trying figuring out the equation to calculate the needed time to get from 0 to 65 mph for a car, without using multiple excel formulas across cells as I've done till now.
I know that the forces acting on the car are:
1) $F_e = \frac {P_e}{v}$
being Pe = Power of engine in W and v of course speed in m/s ; let's assume this power is constant at any speed.
2) $F_d = 0.5\rho C_dAv^2-mgC_{rr} $
- rho = air denisty = 1.2 g/m3
- Cd = air drag coefficient = 0.3
- A = frontal area = 2.2 m2
- m = mass 1000 kg
- g = 9.18 m/s2
- Crr = wheels drag = 0.01
So the total force is:
Ft = Fe - Fd
This is of course = m * dv/dt :
$F_t = m\frac{dv}{dt}$
$F_e - F_d = m\frac{dv}{dt}$
$\frac{P}{v} - 0.5 \rho C_d A v^2 - mgC_{rr} = m\frac{dv}{dt}$
grouping constants and sorting by power:
$- K_1 v^2 + \frac{P}{v} - K_2 = m\frac{dv}{dt}$
Now I don't know where to go from here, I can't get how to separate t and v with so many terms, powers and constants...
Start condition is v=0; end condition is v = 27.8; what I'm trying to get is t.
From
$$ - K_1 v^2 + \frac{P}{v} - K_2 = m\frac{dv}{dt} $$
we get
$$ \frac{m v dv}{P- K_1 v^3 - K_2 v} = dt $$
now
being $v_1, v_2 ,v_3$ the three roots of $P-K_1v^3-K_2 v = 0$ we have
$$ \frac{m v dv}{(v-v_1)(v-v_2)(v-v_3)} = dt $$
giving after integration
$$ \frac{m (v_1 (v_2-v_3) \ln (v-v_1)+v_2 (v_3-v_1) \ln (v-v_2)+v_3 (v_1-v_2) \ln(v-v_3))}{(v_1-v_2) (v_1-v_3) (v_2-v_3)} = t + C_0 $$
or
$$ (v_1 (v_2-v_3) \ln (v-v_1)+v_2 (v_3-v_1) \ln (v-v_2)+v_3 (v_1-v_2) \ln (v-v_3)) = \frac{(v_1-v_2) (v_1-v_3) (v_2-v_3)}{m}(t+C_0) $$
or
$$ (v-v_1)^{v_1(v_2-v_3)}(v-v_2)^{v_2(v_3-v_1)}(v-v_3)^{v_3(v_1-v_2)} = C_1e^{\frac{(v_1-v_2) (v_1-v_3) (v_2-v_3)}{m}t} $$
Adding constants for readability:
$$ (v-v_1)^{\alpha}(v-v_2)^{\beta}(v-v_3)^{\gamma} = C_1e^{\frac{\delta}{m}t} $$
now for $t = 0$ assuming $v = 0$ and at $t = t_f$ with $v_f = 27.8$ we have
$$ (-v_1)^{\alpha}(-v_2)^{\beta}(-v_3)^{\gamma} = C_1\\ (v_f-v_1)^{\alpha}(v_f-v_2)^{\beta}(v_f-v_3)^{\gamma} = C_1e^{\frac{\delta}{m}t_f} $$
and thus
$$ t_f = \frac{m}{\delta}\ln\left(\frac{(v_f-v_1)^{\alpha}(v_f-v_2)^{\beta}(v_f-v_3)^{\gamma}}{(-v_1)^{\alpha}(-v_2)^{\beta}(-v_3)^{\gamma}}\right) $$
NOTE
At this point supposing we have the inversion $v = f(t, C_1)$ we could follow with
$$ v = \frac{ds}{dt} = f(t,C_1) $$
obtaining after integration
$$ s(t) = g(t,C_1,C_2) $$
anyway I would suggest the numerical approach.