A Basic Planetary System – video preview


Since not everybody has Excel and more and more people are on the dumbed down new versions (2007 and 2010) I am presenting these previews to give the readers a feel of the real speed and feel of some of the models in older Excel versions (in this case 2003). This preview refers to an older model. [sociallocker][/sociallocker]


Newton Generalized Treatment


Most of people have heard of Newton’s second law, mass, moment of inertia or the definition of the acceleration both linear and angular. The stuff presented here is elementary (9th grade), yet it is generally not properly understood. What happens when one applies a bunch arbitrary forces on an arbirtarily shaped body?  The resultant force vector produces a linear acceleration while the resultant torque produces a resultant angular acceleration around…


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


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


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


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]


Introduction to Anaglyph Stereoscopy in Excel – part #5: adding a joystick to control the yaw and pitch rates of the 3D cube


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]