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"
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… Read More... "A basic 3-body Planetary System"
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 Newtonian 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,… Read More... "How to Model a Basic 2-body Planetary System"
This post shows the steps for building a first model of a single pole RC high pass filter (HPF) in Excel based on numerical solution using the finite difference method. It is quite elementary to understand, try to go through the proof regardless of your background. [sociallocker][/sociallocker] Basic Filters – Part 2 (1-Pole High Pass Filter) Numerical Solutions to Differential Equations… Read More... "Introduction to Numerical Methods – Basic Filters #2"
This post shows the steps for building a first model of a single pole RC low pass filter (LPF) in Excel based on numerical solution using the finite difference method. It is quite easy to understand, try to go through the proof regardless of your background. [sociallocker][/sociallocker] Basic Filters – Part 1 (1-Pole Low Pass Filter) – Numerical Solutions to Differential Equations (Finite Difference… Read More... "Introduction to Numerical Methods – Basic Filters #1"