This is a video preview to the pong game model developed during a series of ten tutorials as linked in the brackets ( #1, #2, #3, #4, #5, #6, #7, #8, #9 and #10 )
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).
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 the virtual pong opponent.
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.
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.
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.
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.
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.
Hi there, this is a better version of Pong, in which you play with a virtual opponent. It does not have a score board yet and the opponent is theoretically unbeatable. I will be improving it further. Excel 2007 is quite slow on this one. In order to get maximum speed out of Excel 2007 make sure you zoom in as much as possible so only the chart and no calculation is visible while you…
Hi folks, this is a “practice box” for pong. The green button will “Start-Stop” the model and will also link the mouse to the bat (racket) for game control . The bat control is very smooth and quick and no mouse clicking is necessary. The red “Serve” button will shoot a new ball when you loose the old one (you don’t need to stop the model while re-serving). You can adjust the “bat size”, “stroke”…