## Playing Sounds in Excel Using VBA – part #2

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 functionContinue Reading

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

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 toContinue Reading

## 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. [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 analyzedContinue Reading

## 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] Excel PONG Tutorial #4 – combining kinematics with collision events   by George Lungu – In this tutorial (which is a continuation of part#3) the kinematics ofContinue Reading

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

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 ballContinue Reading

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

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 aContinue Reading

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

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:Continue Reading

## Easy Zoom – Chart Axis Scaling Using VBA

In certain models we need to be able to change the scale of the chart axes function of the result of a simulation. Excel charts do have auto-scaling as a default option but sometimes the scaling values we get are not what we need. Another reason against using auto-scaling is that during the time the model runs, the scale self-adjusts andContinue Reading

## Creating a Speedometer in Excel, Part #2 – tutorial

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, trigonometryContinue Reading

## Creating a Speedometer in Excel, Part #1 – tutorial

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 theContinue Reading

## A Family of Speedometers in Excel

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, GeorgeContinue Reading

## A Virtual Joystick – How Can You Make That ? – tutorial

Hello everyone, this is a tutorial in which a virtual  Excel joystick controlled by mouse movements on a scatter chart has been demonstrated . While in operation, a macro updates the coordinates of the pointer in two spreadsheet cells. The two coordinates are then incorporated in formulas which limit the range of motion of the joystick. Just like a realContinue Reading

## Writing Excel User Defined Functions in VBA – part #2 – time stamping, concatenating date and text while maintaining the date format

Hi Folks, there are many available built-in spreadsheet functions in Excel. Ocasionaly one might need to write a special custom function. This second short tutorial is an introduction to that. Creating a “Time Stamp” function is presented as a first example after which a concatenation function between a custom formatted date and a string (text) is introduced. This last function came about fromContinue Reading

## Writing Excel User Defined Functions in VBA – part #1 – the distance function

There are many available built-in spreadsheet functions in Excel. Occasionally one might need a very special custom function. This short tutorial is an introduction about how to write a user defined function which calculate the distance between two points in a Cartesian plane. The topic will be continued and custom functions will occasionally be used in future models. We’d loveContinue Reading

## Creating a Digital Clock #2 – sprite driver, timing macro and functions, full model

Hi guys, here is the final part of tutorial about creating a digital clock in Excel. It is a good tutorial about general use of sprites in animation, especially the first half. Tell us your thoughts, George [sociallocker][/sociallocker] Building an Digital Clock in Excel – part #2 – a full digital clock model using the “digit” sprites by George LunguContinue Reading