In this part of the tutorial, the analysis of the ball movement is continued. The effects of the collision events are introduced in the equations of movement. [sociallocker][/sociallocker] Excel PONG Tutorial #5 by George Lungu – combining kinematics with collision events – In this tutorial (which is a continuation of part#4) the kinematics of the ball is further analyzed… Read More... "How to make a game of PONG in Excel – part #5"
In this part of the tutorial the analysis of the ball movement is taken farther, to include such effects as bouncing off the walls of the court and collision with the bats. [sociallocker][/sociallocker] Excel PONG Tutorial #4 – combining kinematics with collision events by George Lungu – In this tutorial (which is a continuation of part#3) the kinematics of… Read More... "How to make a game of PONG in Excel – part #4"
In this tutorial (which is a continuation of part#2) the kinematics of the ball starts being implemented. Two new macros are being introduced, the “Serve” macro and the “Play” macro. [sociallocker][/sociallocker] Excel PONG Tutorial #3 – ball kinematics analysis – the serve by George Lungu – In this tutorial (which is a continuation of part#2) the kinematics of the ball… Read More... "How to make a game of PONG in Excel – part #3"
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"