This section finalizes the aircraft (glider) by inserting the wing, the horizontal stabilizer and a center of gravity (CG) sprite in the layout. [sociallocker][/sociallocker] Longitudinal Aircraft Dynamics #5- putting the glider together by George Lungu – This section puts together the fuselage, main wing and stabilizer with the proper scale, shift and rotation determined by the input parameters. Scaling and… Read More... "Longitudinal Aircraft Dynamics #5 – finishing the aircraft"
This section is dedicated to modeling the 3D perspective effect in Excel 2003 standard.
This section of the tutorial explains how to create the 2D aircraft components for the animated longitudinal stability model. The first part deals with extracting the x-y coordinates for the fuselage, canopy, vertical stabilizer and rudder. The second part handles the main wing airfoil and the horizontal stabilizer airfoil. All thses parts will be put together in the next section.… Read More... "Longitudinal Aircraft Dynamics #4 – virtual aircraft definition"
This section discusses the layout of the virtual plane and provides for the worksheet implementation of the plane dimensions as input parameters controlled by spin buttons and macros. In the final part a freeform is used to generate raw data for the fuselage. [sociallocker][/sociallocker] Longitudinal Aircraft Dynamics #3- defining the virtual aircraft by George Lungu – This section of the tutorial… Read More... "Longitudinal Aircraft Dynamics #3 – layout parameters and wireframe fuselage generation"
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… Read More... "VertX – a Very Useful Macro for Extracting the Vertex Coordinates of Freeforms – part #2"
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… Read More... "VertX – a Very Useful Macro for Extracting the Vertex Coordinates of Freeforms – part #1"
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] Drawing in Excel – part #1 – an introduction tocreating freeform type autoshapes – On this blog we will soon need to… Read More... "Excel Drawing – creating graphical object data"
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… Read More... "Anaglyph Charts Demo #2- an animated heat transfer model using a red-cyan wireframe chart"
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… Read More... "Anaglyph Charts Demo #1- creating 3D effects on charts using red-cyan elementary chips (sprites)"
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… Read More... "Introduction to Anaglyph Stereoscopy in Excel – part #5: adding a joystick to control the yaw and pitch rates of the 3D cube"
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 you… Read More... "Cosmos Naive – a very basic demo of anaglyph stereoscopy with sprites in Excel"
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 the… Read More... "Introduction to Anaglyph Stereoscopy in Excel – part #4: worksheet implementation of a stereoscopic cube"
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 the… Read More... "Introduction to Anaglyph Stereoscopy in Excel – part #3: a few analogies and the derivation of the stereoscopic 3D-2D perspective conversion formulas"
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 which… Read More... "Introduction to Anaglyph Stereoscopy in Excel – part #2: the principles of creating and viewing 3D pictures"
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.… Read More... "A 2D Demo for Spherical Mirrors in Excel – with virtual reflected rays"