#### A Legacy Speedometer Model – video preview

07/03/2011

This is a video preview of an older Excel model of a speedometer. [sociallocker][/sociallocker]

#### An Analog Clock Model – video preview

07/01/2011

This is a video preview of the analog clock series which include a model section and a tutorial section. [sociallocker][/sociallocker]

#### Longitudinal Aircraft Dynamics #5 – finishing the aircraft

05/29/2011

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 #4 – virtual aircraft definition

05/27/2011

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. [sociallocker][/sociallocker]

#### Introduction to Geometrical Optics – a 2D ray tracing Excel model for spherical mirrors – Part 5

05/01/2011

This brief section takes the two previously created custom VBA functions (Reflect() and Chart_Reflect()) and use them to create the data for both the incident and the reflected bundles of rays within the same table. The data is then plotted on the same chart with the mirror and the result is a preliminary model which you can experiment with. [sociallocker][/sociallocker]

#### Introduction to Geometrical Optics – a 2D ray tracing Excel model for spherical mirrors – Part 4

04/29/2011

This section begins by charting the incident rays on the same 2D acatter chart with the mirror and then explains how to derive the Cartesian coordinates for a “final” point which together with the point of incidence will define the reflected ray. A custom VBA function is created for this purpose. [sociallocker][/sociallocker]

#### Three-Pendulum Harmonograph #2 – an improved version

01/16/2011

Hi! Here is an improved (faster and cleaner) version of the harmonograph. The worksheet has three different areas, the physical machine (a photo of the machine build out of wood by Karl Sims), the virtual machine (which is a 2D chart with a top view of a model showing the three pendulum ends, the drawing table, and the linkage mechanism which connects pendulum #1, pendulum #2 and the pencil) and the detailed curve area….

#### Three-Pendulum Harmonograph (#1)- an automatic drawing machine

12/27/2010

Ladies and Gentlemen, you will like this. Here is a harmonograph in MS Excel 2003 which models a real one build by Karl Sims. Watch the video first to know what to expect. I could have built it from the bare drawing equations but that would have been too easy and no fun at all so I tried to model the real mechanism with 3 pendulums and the linkage rods. It…

#### A Speedometer in Excel

12/18/2010

Here is a speedometer in Excel 2003. It’s an old file and the charting wasn’t done in the most economic fashion. I used too many series while I could have consolidated a lot of the dial curves. It is still a good example of animation and displaying custom numbers on a chart. There are two VBA macros involved, one for changing the speed value and the other for randomly changing the…

#### Tutorial – a Static Lissajous Emulator

12/11/2010

Hi there, this is a tutorial explaining the construction of a very basic Lissajous emulator in Excel. It’s supposed to be very easy to understand at the high school level.  Good luck, George [sociallocker][/sociallocker]