Anaglyph Stereoscopy in Excel – video preview

July 16, 2011

This is a video preview of a series of posts and models covering anaglyph stereoscopy applied in Excel. The following is a list of links internal to this blog covering the aforementioned topic: – a series of five tutorials in anaglyph stereoscopy leading to the creation of a 3D rotating cube(part#1, part#2, part#3, part#4 and part#5) associated to an Excel model. – Cosmos Naive, Anaglyph Charts Demo #1 and Anaglyph…

Read More >>

Excel Tetris – a video demonstration

June 29, 2011

This is a video demo of an older game of Tetris model in Excel. The model is designed for Excel 2003 or earlier versions and it’s too loaded with graphics to work well in Excel 2007 or 2010. You can however try opening it in the newer versions of Excel. I wasn’t personally able to run it satisfactory in 2007.

Read More >>

A Game of Tetris in Excel – video preview

June 28, 2011

This is a video preview of an older game of Tetris model in Excel. The model is designed for Excel 2003 or earlier versions and it’s too loaded with graphics to work well in Excel 2007 or 2010. You can however try opening it in the newer versions of Excel. I wasn’t personally able to run it in 2007.

Read More >>

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

May 15, 2011

The first macro created in this section of the tutorial improves on the previously developed macro by correcting the up-down orientation of the shape, referencing the shape position to the coordinate of the first drawn point and closing the shape by repeating the coordinates of the first point at the end of the table. A last macro is then created which can retrieve multiple shape vertex coordinates, placing them in a table…

Read More >>

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

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

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.

Read More >>

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

Read More >>

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

May 4, 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 >>

Flight Simulator Tutorial #7 – upgrading the joystick chart, adding a reset button and a throttle scroll bar

April 22, 2011

This section displays the landscape on a 2D scatter chart and also upgrades the joystick chart by adding a dial behind the joystick image. This technique of using a stack of a back chart to display dial sprites and a front chart with transparent background to display various control devices, indicator needles and text will extensivly be used in this and future models.

Read More >>

Flight Simulator Tutorial #6 – macro review, scene derivation and integration, mapping of the 2D u-v data into a chartable 1D array, rejecting image artifacts

April 21, 2011

This section finishes the macro analysis and continues with the conversion of the u-v 2D formula array into a chartable 1D array. It also adds two columns to the chartable array, a masking condition for each triangle and masked u-coordinate which will throw out of the visible portion of the chart any shape which has a minimum of one vertex behind the virtual pilot. The section also explains the phenomenon…

Read More >>

Flight Simulator Tutorial #5 – the worksheet implementation of the perspective handling formulas and VBA the macros

April 20, 2011

This section explains the spreadsheet  implementation of the perspective rotation and translation formulas within the Present array and also the implementation of the 3D-2D conversion formulas within the Past array, then it goes on to presenting the VBA macros used (the Reset and JoyStick macros). The PDF and XLF files were updated -04/22/2011, 5:20 pm MST.

Read More >>

A First Flight Simulator Model in Excel

April 18, 2011

This is the first version of a 3D flight simulator in Excel. Start by adjusting the zoom on your file to fit the screen, so you can see the whole chart and the buttons underneath, then click “Reset” and then click the red dot in the center of the joystick. After that, the joystick handle will “stick” to your mouse pointer so your mouse becomes the airplane control. Back and forth mouse…

Read More >>