Anaglyph Charts Demo #2- an animated heat transfer model using a red-cyan wireframe chart

May 12, 2011

This is another basic demo investigating the feasibility of using anaglyph wireframes to plot scientiffic data. Open the attached worksheet and with your 3D glasses on, watch the chart. The data is a dynamic temperature map obtained from a 2D heat transfer model in a metal plate. The heat model is complete and you can run it with various parameters. You can hit “Start / Pause” and manually adjust the pitch and…


Anaglyph Charts Demo #1- creating 3D effects on charts using red-cyan elementary chips (sprites)

May 11, 2011

This is a basic demo investigating the feasibility of using anaglyph sprites to plot scientiffic data. Open the attached worksheet and with your 3D glasses on, watch the chart. The data results are various temperature maps obtained from a 2D heat transfer model in a metal plate. You have 4 different selectable mapps there but you can also invert the pattern using the “Flip” button. I find the 3D effect to be decent but not good enough…


Introduction to Anaglyph Stereoscopy in Excel – part #5: adding a joystick to control the yaw and pitch rates of the 3D cube

May 10, 2011

In this section, a joystick is added to the model which controlls the  yaw rate and the pitch rate (not the angles!) of the stereoscopic cube. This joystick was used before in a dedicated tutorial and in the flight simulator tutorial. Its importance in future models can not be underestimated, hence I decided to cover this virtual device again. Use your 3D glasses while running the mkodel.


Cosmos Naive – a very basic demo of anaglyph stereoscopy with sprites in Excel

May 9, 2011

Reach out for your 3D goggles because this is a representation of the Cosmos through the eyes of a 5-year old. The model displays a few objects at various depths and move two of them back and forth on a chart to demonstrate the stereoscopic effect. Though very simplistic it is an excelent example of anaglyph stereoscopy in action showing you how it’s built. The farther the red and cyan (turquoise)…


3-Body Planetary System with Options

Planetary model
October 8, 2010

Here is a 3-body system with 3D graphics. I made it about 2 years ago but I’ve been updating it lately. 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’ve just bought a legit copy from<> for 50$ but I didn’t have a chance to install it yet. I need to add  few more…


Dynamic Lissajous Emulator

October 1, 2010

This is a dynamic Lissajous emulator in the sense that the waveform is obtained by combining 2 time varying sinusoidal waves with different frequencies. Recommending this site to your friends would be highly appreciated.   Thanks for your support!


Static Lissajous Emulators (2D and 3D)

September 29, 2010

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 paranthesis, 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 Lissajous figure and the second one has a 3D Lissajous pattern obtained from three different…


Basic 3D-2D (Perspective) Visualization

September 27, 2010

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 persective calculations are done. The cube can be zoomed and it can also be rotated in azimuth and altitude using simple macros.  


Roller Coaster

September 20, 2010

A roller coaster in Exel 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.