#### How to make a game of PONG in Excel – part #5

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.

Skip to content
# Excel Unusual

## Science, Engineering, Games in Excel

#
Month: February 2011

#### How to make a game of PONG in Excel – part #5

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.

Read More >>
#### How to make a game of PONG in Excel – part #4

Read More >>
#### How to make a game of PONG in Excel – part #3

Read More >>
#### How to make a game of PONG in Excel – part #2

Read More >>
#### How to make a game of PONG in Excel – part #1

Read More >>
#### Casual Introduction to Numerical Methods – spring-mass-damper system model – part#5

Read More >>
#### Casual Introduction to Numerical Methods – spring-mass-damper system model – part#4

Read More >>
#### 2D Projectile Motion Tutorial #7

Read More >>
#### 2D Projectile Motion Tutorial #6

Read More >>
#### Near-Exponential VBA Conversion

Read More >>

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.

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 input parameters are: mass, damping ratio, spring constant and time…

This tutorial explains the principles to generating animation for the spring-mass-damper system analyzed in the previous presentations.

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.

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.

The macro in this tutorial creates a near exponential variable conversion to be used for very large dynamic range input data entry . If for instance, we have to adjust a parameter from 1 to 1 million we can either make a spin button which can go from 1 to 1 million in unity steps (which would take for ever), or implement an exponential scheme. We would like an exponential series of powers of…