This is the fourth part of a series of tutorials explaining how to create a realistic clock in MS Excel using free form sprites. The sprites are created in PowerPoint and imported in Excel as images. This part (part #4) deals with planning the clock face layout. How to make a realistic looking digital clock in MS Excel – Part… Read More... "How to make a realistic looking digital clock in MS Excel – Part #4 – (create a clock face layout – PowerPoint design)"
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"
Since not everybody has Excel and more and more people are on the dumbed down new versions (2007 and 2010), I am presenting these previews to give the readers a feel of the real speed and feel of some of the models in older Excel versions (in this case 2003). This preview refers to an older model. [sociallocker][/sociallocker] Read More... "A Basic Planetary System – video preview"
In this tutorial, most of the calculations for the numerical simulation a SMD (spring-mas-damper) system will be consolidated into a single formula, the coordinate formula. In this case, in order to calculate the coordinate at the end of a any time step, we will need just the coordinates from the previous two time steps and of course the input parameters (constants). These… Read More... "Casual Introduction to Numerical Methods – spring-mass-damper system model – part#5"
This tutorial explains the principles to generating animation for the spring-mass-damper system analyzed in the previous presentations. [sociallocker][/sociallocker] A casual approach to numerical modeling – part #4 – a Spring-Mass-Damper-System – creating the animation by George Lungu – We are trying to generate animation for the system sketched above knowing the deviation from the equilibrium function of time. This deviation is… Read More... "Casual Introduction to Numerical Methods – spring-mass-damper system model – part#4"
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] Projectile Motion Tutorial #5 – a 2D projectile motion model using numerical analysis of projectile dynamics (including aerodynamic drag)… Read More... "2D Projectile Motion Tutorial #5"
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. Projectile Motion… Read More... "2D Projectile Motion Tutorial #4"
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 rather slow. [sociallocker][/sociallocker] Projectile Motion Tutorial #3 –… Read More... "2D Projectile Motion Tutorial #3"
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… Read More... "2D Projectile Motion Tutorial #2"
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… Read More... "2D Projectile Motion Tutorial #1"
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"
Here is the third part of a tutorial in both elementary dynamics and numerical methods. It is written at a basic level and it shows you how to set up a dynamic model for numerical solving of simple differential equations. The dynamic model makes use of an infinite loop, which make the calculations advance in time. Instead of a large table… Read More... "Casual Introduction to Numerical Methods – a spring-mass-damper system model – part#3"
Here is the second part of a tutorial in both elementary dynamics and numerical methods. It is written at a basic level and it shows you how to solve a system of difference equations in an Excel table. It also starts to explain how to animate the model. [sociallocker][/sociallocker] A casual approach to numerical modeling – the Spring-Mass-Damper System – part 2.… Read More... "Casual Introduction to Numerical Methods – a spring-mass-damper system model – part#2"
Here is the first part of a casual tutorial in both elementary dynamics and numerical methods. It is written at a very basic level and it shows you how to solve a system of difference equations with a pencil and a paper and perhaps a pocket calculator to speed things up. A casual approach to numerical modeling – the Spring-Mass-Damper-System –… Read More... "Casual Introduction to Numerical Methods – a spring-mass-damper system model – part#1"