I’ve done a handful of animations lately:
- Gas Prices – Animated Bar Chart for Excel
- Gas Prices – Animated Bar Chart for Excel 2
- Gapminder for Excel
- Rolling Wheel Animation
This example shows the position and path of a moving projectile which is launched at a given velocity and angle. The math is high school physics, with a little calculus and trig thrown in. If you want to see that, download the workbook (link below), or consult a textbook or a smart kid.
The workbook has a data entry area and my usual animation controls. When the angle and velocity are entered, a results table shows how long the projectile will be in flight, how long it will take to get to maximum altitude, and what altitude and distance the projectile will reach. Some assumptions were made to simplify the model, as in all physics problems. The ground is flat at sea level, and the effect of air resistance is neglected.
Set the angle to 45° and the velocity to 100 m/s, and start the animation.
Here is the end of the animation for 30° and 7 m/s.
And this one is for 75° and 100 m/s
The workbook containing this model can be downloaded here: Ballistics.zip.