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

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. The PDF erroneously claims this is part #3 of the tutorial, whereas this is actually part #4 (it’s a typo in theContinue Reading

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. Excel anaglyph stereoscopy #3 – 3D-2D perspective conversion formulas by George Lungu – While the previous section introduced theContinue Reading

This tutorial explains the basic principles of creating and displaying anaglyph pictures. Excel anaglyph stereoscopy #2 – how to split the image by George Lungu – The previous section showed an improvement in the practical implementation of spreadsheet multiplication, namely based on the associativity of matrix multiplication the three elementary rotation matrices were combined in a composite rotation matrix whichContinue Reading

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

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 extensively be used in thisContinue Reading

This section finishes the macro analysis and continues with the conversion of the u-v 2D formula array into a chart-able 1D array. It also adds two columns to the chart-able 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 vertexContinue Reading

This section explains the spreadsheet  implementation of the perspective rotation and translation formulas within the Present array. It also shows 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). [sociallocker][/sociallocker] A Basic Flight Simulator in Excel #5 – the worksheet implementation of theContinue Reading

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. [sociallocker][/sociallocker] A Basic Flight Simulator in Excel #4 – creating the initial, current and previous landscape matrices by George Lungu – This section startsContinue Reading

This section deals with a simple method of creating the appearance of scene movement during the flight. Beside reviewing standandard rotation and translation formulas described before on this blog, the presentation begins to explain how to apply numerical-like methods to create a live and interactive model.   A Basic Flight Simulator in Excel #3 – calculating the scene rotation and translation as a resultContinue Reading

This is the second part of a tutorial explaining the creation of an “in-cockpit” flight simulator (versus the remote control simulator) model in Excel 2003. This section introduces some basic piloting background and nomenclature. A Basic Flight Simulator in Excel #2 – airplane positioning, control surfaces and turn dynamics by George Lungu – This tutorial explains the basics of airplaneContinue Reading

This is the first section of a tutorial explaining how to build a 3D flight simulator in Excel. This part deals with creating a joystick and a triangular ground mesh. The joystick model was explained in a previous post from January 2011 and the ground mesh was already used in the 3D roller-coaster. [sociallocker][/sociallocker] A Basic Flight Simulator in Excel #1 – usingContinue Reading

The previous section explained the VBA upgrades needed to make the score functional and new-game and end-game sound effects were added. This tutorial shows how fix some previous bugs and create a “demo play” option which means that both bats are automatically run by worksheet logic. This is the final part of the of the Pong tutorial series. [sociallocker][/sociallocker] Excel PONG Tutorial #10 – addingContinue Reading

This section explains how to add score board logic on the worksheet and how to display the score on the court chart using sprites. [sociallocker][/sociallocker] Excel PONG Tutorial #8 – creating a score display by George Lungu – The previous tutorial showed how to associate sound effects (including crowd applause and laughter) to ball collision events. This section (which is aContinue Reading