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… Read More... "Game of Pong #1 – a dynamic training box with sound effects"
I dedicate this section to modeling games in MS Excel. These are not the hidden Excel games such as the Easter Egg for instance. Download the free games available and use them in any version of Excel. Due to the excessive amount of new features, the new Excel versions would be slower though. Lean how to develop animations in MS Excel which you can use as games. You can certainly impress your colleagues. These are animations and games that YOU created! You can impress your bosses too. As a consequence you might snag yourself a bonus or even a promotion. Though seemingly hard, you might find developing certain games in a spreadsheet can be quite easy and satisfying. There nonetheless several different ways of creating such games. The first thing people are concerned when seeing excel games is animation. How can you possibly do that, they ask? Without trying to be exhaustive, there are essentially three methods to create animation in a spreadsheet.
Method #1 – Selective Cell Fill
The simplest method would be to selectively fill groups of spreadsheet cells with different colors and use VBA code (Visual Basic for Applications) to change these colors in time. This style of animation is better used in creating excel puzzles.
Method #2 – Shape Manipulation
You can create various shapes in PowerPoint or directly in Excel, using the “draw” menu. After properly renaming these shapes you can again use VBA game code to move them around, or re-scale them, or change the color in real time.
Method #3 – Using Wire Frames
You can also use a scatter chart to display x-y data as simple “wire-frame” objects. Of course you will need to develop basic algorithms or code to manipulate and change the data in time.
Method #4 – Scatter Charting
You can also use a scatter chart to display x-y vertices only and instead of markers you will paste an image on each vertex. This method is very similar to the previous one. The images manipulated on the chart are called “sprites”. Imagine a puppet show, where you can handle many different dolls but only a few are “active”, which means the spectators see them displayed above the curtain.
A Game of Tetris in Excel
Hi there, this is a Tetris game I made in Excel two years back. To start or to pause, click the yellow “sun” icon in the upper right corner of the chart. You can adjust the game level on the top side of the chart and also change the landscape by clicking “Landscape” on the bottom right. The landscape will… Read More... "A Game of Tetris in Excel"
Basic 3D-2D (Perspective) Visualization
The first two worksheets of this Excel workbook illustrate the creation and display of a rectangle by using a 2D scatter plot. They also show how to adjust its size, translate and rotate it. In the third worksheet a wire-frame cube is created. 3D-2D perspective calculations are done. The cube can be zoomed and it can also be rotated in… Read More... "Basic 3D-2D (Perspective) Visualization"
Animated Roller Coaster in Excel
A roller coaster in Excel 2003 in 3-dimension (perspective view). To start de ride after download, click the little sun icon in the NE corner of the chart. Most of the calculations are done in the spreadsheet with very little VBA as a “glue”. The display is created on a plain 2D scatter plot. [sociallocker][/sociallocker] Read More... "Animated Roller Coaster in Excel"