Here is a speedometer in Excel 2003. It’s an old file and the charting wasn’t done in the most economic fashion. I used too many series while I could have consolidated a lot of the dial curves. It is still a good example of animation and displaying custom numbers on a chart. There are two VBA macros involved, one for changing… Read More... "A Speedometer in Excel"
This section is dedicated to modeling the 3D perspective effect in Excel 2003 standard.
A Realistic Looking Digital Clock Model
Hi guys, here is a dynamic digital clock model in Excel I made today. The display looks very realistic. I studied for this all the clocks in the house including the stove, microwave oven and washing machine clocks, plus some pictures on Google. It will display your local computer time. It uses “sprites” as a method of creating the digits. I… Read More... "A Realistic Looking Digital Clock Model"
Tutorial – a Static Lissajous Emulator
Hi there, this is a tutorial explaining the construction of a very basic Lissajous emulator in Excel. It’s supposed to be very easy to understand at the high school level. Good luck, George [sociallocker][/sociallocker] A Lissajous emulator in Excel by George Lungu Introduction: Jules A. Lissajous was a French mathematician from the 19th century – He wanted to visualize… Read More... "Tutorial – a Static Lissajous Emulator"
How to Make an Analog Clock in Excel
Hello folks, here is a tutorial about building a clock in Excel. Enjoy! [sociallocker][/sociallocker] Building a live Excel clock by George Lungu Here are a few date and time functions in VBA: Now : Current date and time. Example: 7/5/00 3:16:38 PM returned by Now Date : Current date only. Example: 7/5/00 returned by Date Time : Current time only. … Read More... "How to Make an Analog Clock in Excel"
Time in VBA Part#1 – Japanese Clocks
Hi guys, here is a simple file with a bunch of clocks. The code is very basic and the whole workbook is fully open so you can see how it’s done. All the spread sheet calculations are contained in the upper left corner and the VBA code is just few lines long. Click the “Run-Pause Clock” button to start or pause… Read More... "Time in VBA Part#1 – Japanese Clocks"
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"
Resizing, Translating and Rotating Shapes in Excel
Five different shape alterations are presented: 1. Resizing – which can be done independently on each axis by multiplying the coordinates by a certain factor while the shape is centered in the origin. 2. Translation – which can be done independently on each axis by adding or subtracting a term to each coordinate. 3. Simple rotation – formulas were derived… Read More... "Resizing, Translating and Rotating Shapes in Excel"
3-Body Planetary System with Options
Here is a 3-body system with 3D graphics. This model works at about 30 frames/second in Excel 2003 on a modern PC. In Excel 2007 it will run 10-15 times slower. I know 2010 is a lot faster than 2007. I need to add few more features. I am also thinking of adding a 3D gravitational surface map later (like… Read More... "3-Body Planetary System with Options"
Creating Shapes on a 2D Scatter Chart
This post shows you how to draw a closed polygon (in this case a triangle for simplicity) on a 2D scatter plot in Excel 2003. 1. For this you need to sketch what you want to draw on a paper or just create a mental visualization. 2. In this sketch you need to define the vertices (corners) of the shape… Read More... "Creating Shapes on a 2D Scatter Chart"
Dynamic Lissajous Emulator
This is a dynamic Lissajous emulator in the sense that the waveform is obtained by combining 2 time varying sinusoidal waves with different frequencies. [sociallocker][/sociallocker] Read More... "Dynamic Lissajous Emulator"
Static Lissajous Emulators (2D and 3D)
This is a static Lissajous emulator in the sense that the waveform is obtained by combining 2 static sinusoidal waves with different frequencies. As a parenthesis, I will be preparing a dynamic version which will look just like the wave shape seen on a real oscilloscope. The file presented here has two different worksheets, the first one contains a classic 2D… Read More... "Static Lissajous Emulators (2D and 3D)"
Triple Spring-Mass-Damper System
This is the model of a triple spring-mass-damper system in excel. [sociallocker][/sociallocker] Read More... "Triple Spring-Mass-Damper System"
Double Spring-Mass-Damper System
This is an animated model of a double spring-mass-damper system in excel. [sociallocker][/sociallocker] Read More... "Double Spring-Mass-Damper System"
Simple Spring-Mass-Damper System
This is the model of a simple spring-mass-damper system in excel. [sociallocker][/sociallocker] Read More... "Simple Spring-Mass-Damper System"