This is a video preview to the shooting range model posted in February 2010. [sociallocker][/sociallocker] Read More... "A Virtual Shooting Range in Excel – video preview"
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 #11- 360 full coverage – loops by George Lungu – This section fixes an angle issue so that the virtual aircraft will now be able to perform both backward and forward loops. Upgrading… Read More... "Longitudinal Aircraft Dynamics #11 – full 360 degree operation – aerobatics, inverted flight and loops – FINAL"
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] Longitudinal Aircraft Dynamics #10- the numerical method by George Lungu – This section deals worksheet implementation of the numerical setup for a dynamic modeling of the flight. The… Read More... "Longitudinal Aircraft Dynamics #10 – implementing the numerical method"
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]… Read More... "2D Projectile Motion Tutorial #7"
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] Projectile Motion Tutorial #5 by George Lungu – a 2D projectile motion model of projectile dynamics including… Read More... "2D Projectile Motion Tutorial #6"
Hi Folks, As a kid was fascinated with high power rifles, sniper rifles, cannons and in general, fast projectiles. 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… Read More... "2D Projectile Motion Model #1 – a virtual tactical shooting range"