This section explains how to add score board logic on the worksheet and how to display the score on the court chart using sprites. [sociallocker][/sociallocker] Excel PONG Tutorial #8 – creating a score display by George Lungu – The previous tutorial showed how to associate sound effects (including crowd applause and laughter) to ball collision events. This section (which is a… Read More... "How to make a game of PONG in Excel – part #8"
This section of the tutorial explains how to add sounds to the Pong game created previously. There are four types of sound effects: collision with the walls, collision with the bats, missed ball by the player (crowd laughter) and missed ball by the virtual opponent (crowd applause). [sociallocker][/sociallocker] Excel PONG Tutorial #7 – associating sound effects to ball collision events by George Lungu… Read More... "How to make a game of PONG in Excel – part #7"
This section explains how to create a compound sound effect from elementary sounds. In the first example (two macros), the sound is played in a loop which is a native internal loop within the “PlaySound” function (using the flag option: SND_LOOP = &H8). A second function (the “Beep” function) creates a tone generator with adjustable frequency and play time. The Beep function… Read More... "Playing Sounds in Excel Using VBA – part #2"
This tutorial is an introduction to VBA sound playing macros in Excel. The sound effects can be used in various scientific and engineering models or in games. It first shows the general syntax of a sound playing macro and few sources of downloading free .wav sound files. The first demo macro plays a short sound a single time and the… Read More... "Playing Sounds in Excel Using VBA – part #1"
In the previous section a special ball return formula was implemented. Bat #1 was assigned the y-coordinate of the ball and in this way a very simple opponent algorithm was implemented. The problem with this algorithm is that by having Bat #1 perfectly tracking the ball, the opponent was unbeatable. This section shows how to add adjustable skill levels to… Read More... "How to make a game of PONG in Excel – part #6"
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"
In this section two bats are created (the opponent’s bat and the player’s bat). The player’s bat movements are controlled by the vertical mouse movement. The geometry of movement, placement and charting of the bats are explained. [sociallocker][/sociallocker] Excel PONG Tutorial #2 – creating the pong bat animation with various options by George Lungu -In this tutorial (which is a… Read More... "How to make a game of PONG in Excel – part #2"
This post contains the first part of a series of tutorials demonstrating how to build a lively game of Pong in Excel. The section deals with the bat movement VBA macro, and plotting the “court” or “tennis-table” on a 2D scatter chart. [sociallocker][/sociallocker] Excel PONG Tutorial #1 – creating the pong table and bat animation by George Lungu PONG facts:… Read More... "How to make a game of PONG in Excel – part #1"
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"
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"