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

#
inertia

#### 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 Model #1 – a virtual tactical shooting range

Read More >>
#### A basic 3-body Planetary System

Read More >>
#### How to Model a Basic 2-body Planetary System

Read More >>

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…

Hi folks, as a continuation to the previous tutorial here is a 3-body planetary model where the solution to the equations is contained in a static form, as a lookup table (I previously called it a “pure spreadsheet solution”). The model is static in the sense that after any parameter is changed, the solution data remains unchanged in a table until a new parameter is updated by the user. The display is dynamic however since an “Offset()” function…

Here is a tutorial explaining how to model a two dimensional 2-body planetary system in Excel. It uses the Euler method of integration. The tutorial starts with explaining the simple newtonial laws acting on the two planets. There are essentially just two forces acting on each body at any time: the inertia and the gravitational attraction. During each small time step, from the distance between bodies we can calculate the gravitational…