Creating a Speedometer in Excel, Part #2 – tutorial


The previous tutorial (first half) explained how to download a speedometer picture from 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…


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 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…


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


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


Hello everybody, 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 real device the stick head movement is confined within a square (with a side…


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 from a question I was asked by a finance person at…


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


There are many available built-in spreadsheet functions in Excel. Ocasionaly 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 love to hear from you. [sociallocker][/sociallocker]


Digital Clock Model – an Excel 2007 adaptation


Hello!  Due to some incompatibility, I re-adjusted the old digital clock for the 2007 version of Excel. In Excel 2003 or earlier if you click on a chart point twice (with a certain delay between clicks) you can paste a picture and have the data point actually convert into that picture. In 2007 the same trick works but somehow the picture expands by something like 20%, which makes a lot of…


Game of PONG #2


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…


Game of Pong #1 – a dynamic training box with sound effects


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”…