jcrboy wrote:My formulas are as such:
A2-D2 = 0
A3=A2+1 (drag from A3 to A62)
B3=B2+2 (drag from B3 to B17)
B18-B47=B17
B48-B62=0
C3=C2+B3 (drag from C3 to C62)
D3=D2+C3 (drag from D3 to D62)
I would come up with
C3 = C2+B2+0.5*(B3-B2)
That is, the speed at the end of the next second is:
C2 - the speed at the end of the previous second +
B2 - the speed added by the acceleration at the end of the previous second +
0.5*(B3-B2) - the speed added by the average of the acceleration during that second (since the increase in the acceleration is constant, we can just take half the difference between the previous and the current acceleration values)
Unfortunately, the calculation for D3 would be even worse, since the average velocity over the second is not so easily calculated as the increase in the velocity is not constant.
D18 = D17 + C17 + 0.5*(C18 - C17) will work, since the acceleration is no longer changing, but D3 to D17 is much more complicated.
I think we need to use markd's approach with calculus.