A 3D Flight Simulator – video preview

July 17, 2011

This is a preview to the 3D flight simulator model previously published on this blog.

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…

Building a game of Tetris #1– the generation and the rotation of the “tetrominoes”

June 30, 2011

This is the first section of a tutorial about the creation of a Tetris game in Excel using mainly spreadsheet formulas and very little VBA.

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.

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.

A 2D Animated Excel Roller Coaster – video preview

June 18, 2011

This is a video preview for the 3D animated roller coaster previously presented on this blog. A tutorial on this topic will be posted later.

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…

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…

Excel Drawing – creating graphical object data

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

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

Introduction to Anaglyph Stereoscopy in Excel – part #4: worksheet implementation of a stereoscopic cube

May 8, 2011

This is the final part of the anaglyph stereoscopy tutorial. This part deals with the prectical implementation of the concepts and formulas discussed before to create a 3D cube. You need 3D glasses to notice the stereoscopic effect. 0

Introduction to Anaglyph Stereoscopy in Excel – part #3: a few analogies and the derivation of the stereoscopic 3D-2D perspective conversion formulas

May 7, 2011

This section of the tutorial gives few more real life applications of the stereoscopic vision and also derives the stereoscopic 3D-2D perspective conversion formulas. These formulas are based on the approximation that the that both right and left eyes observe the same v-coordinate.

Introduction to Anaglyph Stereoscopy in Excel – part #2: the principles of creating and viewing 3D pictures

May 6, 2011

This tutorial explains the basic principles of creating and displaying anaglyph pictures.

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…

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.

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…

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.

Flight Simulator Tutorial #4 – matrix allocation and input parameter formulas (roll rate, pitch rate, throttle)

April 19, 2011

This section explains the top level functionality of the model, it also allocates the data and formula arrays needed for manipulating the scene image. The roll rate, pitch rate and throttle formulas are implemented in the worksheet.

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…