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

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]

Skip to content
# Excel Unusual

## Science, Engineering, Games in Excel

#
excel

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

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]

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 >>
#### 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 >>
#### Creating a Speedometer in Excel, Part #2 – tutorial

Read More >>
#### Creating a Speedometer in Excel, Part #1 – tutorial

Read More >>
#### A Family of Speedometers in Excel

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

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

Read More >>

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]

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]

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. [sociallocker][/sociallocker]

The previous tutorial (first half) explained how to download a speedometer picture from www.flickr.com and how to alter it (delete the needle) using a freeware called Gimp (similar to Photoshop). – The model replaces the deleted needle from the picture with a moving one created from a chart line. – This second half of the tutorial explains the geometry, trigonometry and VBA code used to build a new rotating speedometer…

This is the first half of a tutorial which shows how to create a speedometer in Excel. The model is essentially a 2D scatter chart having as background the picture of a speedometer dial downloaded from www.flickr.com. Before using the photograph you need to erase the arm of the speedometer from the picture using Photoshop or other photo editing software. In the model I replaced the deleted arm with a moving arm created from…

Hi guys, by popular demand, this is a file containing five different animated speedometers and a tachometer (rpm-meter). I can recognize two models: a Toyota Camry and a Ford Crown Victoria. They work great. The rest I am not sure what they are, I would appreciate if you tell me. Just leave a comment. The model works in all versions of Excel. Cheers, George [sociallocker][/sociallocker]

Here is the third part of a tutorial in both elementary dynamics and numerical methods. It is written at a basic level and it shows you how to set up a dynamic model for numerical solving of simple differential equations. The dynamic model makes use of an infinite loop, which make the calculations advance in time. Instead of a large table with formulas, this time we have a small number of…

Here is the second part of a tutorial in both elementary dynamics and numerical methods. It is written at a basic level and it shows you how to solve a system of difference equations in an Excel table. It also starts to explain how to animate the model. [sociallocker][/sociallocker]