#### 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

#
trajectory

#### 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 >>
#### Longitudinal Aircraft Dynamics #11 – full 360 degree operation – aerobatics, inverted flight and loops – FINAL

Read More >>
#### Longitudinal Aircraft Dynamics #10 – implementing the numerical method

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

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

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

Read More >>

This section updates an angle formula so that the virtual glider can now perform both backward and forward loops, as well as inverted flight. [sociallocker][/sociallocker]

This section of the turorial finalizes the main dynamics calculations and implements the numerical method for approximating the glider trajectory. At this point, the model is already functional but with a crude interface. [sociallocker][/sociallocker]

In the this tutorial, after we got most of the trajectory calculation concentrated in just two columns, we will write a custom VBA function (dual output) to replace the spreadsheet computations used. This process of starting with very simple models, then refining the calculations and then learning how to write custom functions for those calculations will be extremely useful later for developing more complex models. [sociallocker][/sociallocker]

This tutorial simplifies the previous model and manages to describe the (x,y) flight coordinates using just two formulas placed on columns D and E. A custom VBA trajectory function will be introduced in the next section which preserves the effects of gravity and aerodynamic drag. [sociallocker][/sociallocker]

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…