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

A Solver for Systems of Linear Equations in Excel

04/25/2011

This is a linear system of equations solver in Excel. The size of the system is programmable by the user from 2 to 20 which means, depending on the setting selection, the model can instantly find the solution of linear systems starting from 2 equations and 2 unknowns up to 20 equations and 20 unknowns. It uses the following built-in Excel spreadsheet functions: MMULT(), MINVERSE() and TRANSPOSE(). Like everything on…

Read More >>

A First Flight Simulator Model in Excel

04/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 >>