VertX – a Very Useful Macro for Extracting the Vertex Coordinates of Freeforms – part #1

05/14/2011

Using autoshape freeforms is a very easy way to duplicate object outlines from pictures. It is convenient to create a freeform and once created, its vertices (points) can be edited with without difficulty.  Aditional points can be inserted and others can be deleted. This is a tutorial about a series of macros which allow the extraction of freeform vertex coordiantes to a worksheet range in Excel. These coordinates can be later employed to create 3D wireframe…

Read More >>

Excel Drawing – creating graphical object data

05/13/2011

This tutorial will introduce the reader to creating simple drawings in Excel by using the “Freeform” auto shape. Later on, we will be able to convert this data in x-y-z vertex information for various models by using a macro. [sociallocker][/sociallocker]

Read More >>

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

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

Read More >>

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

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

Read More >>

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

05/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 model. [sociallocker][/sociallocker]

Read More >>

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

05/09/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)…

Read More >>

A 2D Demo for Spherical Mirrors in Excel – with virtual reflected rays

05/05/2011

This is a demonstrative model for 2D spherical mirror ray tracing in Excel displaying both the real reflected rays and the virtual reflected rays. You you have the option of turning the visibility of the virtual rays off if you wish.  It works in Excel 2003 at about 40 frames per second and in Excel 2007 at about 4 frames per second. You can start it in  a hands-off demo mode by…

Read More >>

Introduction to Anaglyph Stereoscopy in Excel – part #1: a more efficient composite rotation in the 3D Cartesian space

05/04/2011

I made a stereoscopic model in October last year, however, choosing the wrong colors (red and blue on a black background, the effect was very weak (if any). This series was suggested to me last week by one of the guests here on the website, Don L. (thanks Don!), who sent me his stereoscopic cube. I opened the model, put on my goggles and his cube literally popped out of the…

Read More >>

A Preliminary 2D Ray Tracing Demo for Spherical Mirrors in Excel

04/30/2011

This is a demonstrative model for 2D spherical mirror ray tracing in Excel. It works in Excel 2003 at about 40 frames per second and in Excel 2007 at about 4 frames per second. You can start it in  a hands-off demo mode by clicking the “Fully Automatic Demo” button and at any time you can hit the the “Demo Style” button to choose a flexible (pulsating) mirror or a…

Read More >>