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… Read More... "Anaglyph Charts Demo #2- an animated heat transfer model using a red-cyan wireframe chart"
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… Read More... "Anaglyph Charts Demo #1- creating 3D effects on charts using red-cyan elementary chips (sprites)"
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… Read More... "Introduction to Anaglyph Stereoscopy in Excel – part #5: adding a joystick to control the yaw and pitch rates of the 3D cube"
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 excellent example of anaglyph stereoscopy in action showing you… Read More... "Cosmos Naive – a very basic demo of anaglyph stereoscopy with sprites in Excel"
This is an older model of planetary motion in 3D containing eight planets. A video preview can be watched here. [sociallocker][/sociallocker] Read More... "A Legacy 3D Octal Planetary Model"
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"
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"
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)"
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"
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"