#### A Virtual Shooting Range in Excel – video preview

This is a video preview to the shooting range model posted in February 2010. [sociallocker][/sociallocker]

Skip to content
# Excel Unusual

## Science, Engineering, Games in Excel

#
gravity

#### A Virtual Shooting Range in Excel – video preview

This is a video preview to the shooting range model posted in February 2010. [sociallocker][/sociallocker]

Read More >>
#### 2D Projectile Motion Tutorial #5

Read More >>
#### 2D Projectile Motion Tutorial #4

Read More >>
#### 2D Projectile Motion Tutorial #3

Read More >>
#### 2D Projectile Motion Tutorial #2

Read More >>
#### 2D Projectile Motion Tutorial #1

Read More >>
#### 2D Projectile Motion Model #1 – a virtual tactical shooting range

Read More >>
#### Pendulum

Read More >>

This is the next in a series of projectile motion tutorials for creating 2D trajectory models using numerical analysis of projectile dynamics (including aerodynamic drag). The trajectory formulas were derived in the previous tutorial. This post describes the Excel implementation (spreadsheet formulas, VBA code, buttons and charts). [sociallocker][/sociallocker]

This tutorial derives the formulas of a projectile model taking into account the aerodynamic drag. A finite differences numerical method is used. Though fairly easy to apply and understand, this type of methods can solve much more complex problems than the high-school type approach shown in the previous tutorials. An Excel model will be implemented in the next section.

Now that we have a simple animated projectile motion (previous tutorial) let’s try to add on the chart the three instantaneous speed vectors associated with the projectile. These speed vectors are: the horizontal speed, vertical speed and the total speed vector. The model works in all Excel versions but in 2007 it’s painfully slow. [sociallocker][/sociallocker]

This part of the tutorial shows you how to animate the model created in the first part. Since it is addressed to beginners, this part of the tutorial will show you in detail how to create buttons and the associated macros for the input data interface and it will also show you how to animate the flight of the projectile and explain the VBA macro behind the animation. [sociallocker][/sociallocker]

This part of the tutorial will show you how to create the simplest possible projectile motion model using standard kinematic formulas from the first year of high school. The variable parameters of the model will be: initial height, initial speed and initial angle and time step. “g” – the gravitational constant will be set at 9.81 m/s^2. This model is a static one and it will be animated in the following…

Hi Folks, As a kid was fascinated with high power rifles, sniper rifles, cannons and in general, fast projectiles. As a kid I’ve been brainwashed with all sorts of urban legends about how far an AK 47 or a pistol can shoot or how thick a steel metal plate a bullet can penetrate at various distances. I’ve also watched some documentary about snipers and there were talking about highly bent trajectories, how…

This is a basic pendulum model in Excel. Enjoy! [sociallocker][/sociallocker] This is an animated Excel model of a pendulum that you can download here. For fast modeling speed, please use older versions of excel (1997-2003). In the following section, background information about pendulums in general will be presented: Pendulum meaning, a simple pendulum definition, what is a pendulum? A pendulum is an oscillatory device made up of a concentrated weight…