| The First Challenge Program for Physics 160: 2002, Spring | |||||||||||||||
| vertical motion with air resistance | |||||||||||||||
| This one has n=1, which was the way the problem was stated: | |||||||||||||||
| FIRST several rows of Excel Worksheet | Full Integers Table | The Halves Table | |||||||||||||
| Relevant Physical quantities | dt (in $E$8) | b (in $F$8) | n (in $G$8) | t | x | v | a | x(1/2) | v(1/2) | a(1/2) | |||||
| physical gen. Equation | 0.025 | 0.025 | 1 | t1=t0+dt | x1=x0+vh*dt | v1=v0+ah*dt | a1 | xh=x0+(v0*dt)/2 | vh=v0+(a0*dt)/2 | ah | |||||
| next line of equations | t2=t1+dt | x2=x1+v3*dt | v2=v1+a3*dt | a2 | x3=x1+(v1*dt)/2 | v3=v1+(a1*dt)/2 | |||||||||
| initial conditions | x0 (in $E$11) | v0 (in $F$11) | g (in $G$11) | 0 | 0 | 20 | -19.8 | ||||||||
| first line: | Excel equations | 0 | 20 | 9.8 | 0.025 | 0 | 20 | -19.8 | 0.25 | 19.7525 | -19.554 | ||||
| next line: | Excel equations | 0.05 | 0.4938125 | 19.51114921 | -19.3171 | 0.25 | 19.7525 | -19.554 | |||||||
| 0.075 | 0.987625 | 19.02229843 | -18.8462 | 0.737701865 | 19.26968517 | -19.083 | |||||||||
| a is -(g + b*v*(abs(v))^n) | 0.1 | 1.469367129 | 18.54522295 | -18.3981 | 1.22540373 | 18.78672098 | -18.6235 | ||||||||
| a1, a2, and ah are just versions that use appropriate v's | 0.125 | 1.939035154 | 18.0796349 | -17.9718 | 1.701182416 | 18.3152463 | -18.1862 | ||||||||
| 0.15 | 2.396916311 | 17.62497974 | -17.566 | 2.16503059 | 17.85498702 | -17.77 | |||||||||
| 0.175 | 2.843290987 | 17.18072939 | -17.1794 | 2.617228558 | 17.40540477 | -17.3737 | |||||||||
| 0.2 | 3.278426106 | 16.74638682 | -16.811 | 3.058050104 | 16.96598644 | -16.9961 | |||||||||