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

07/10/2011

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

#### Longitudinal Aircraft Dynamics #11 – full 360 degree operation – aerobatics, inverted flight and loops – FINAL

06/06/2011

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]

#### Longitudinal Aircraft Dynamics #10 – implementing the numerical method

06/05/2011

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]

#### 2D Projectile Motion Tutorial #7

02/20/2011

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]

#### 2D Projectile Motion Tutorial #6

02/19/2011

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]

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

02/06/2011

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…