Longitudinal Aircraft Dynamics #4 – virtual aircraft definition

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

Read More >>

Three-Pendulum Harmonograph #2 – an improved version

January 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….

Read More >>

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

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

Read More >>

A Speedometer in Excel

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

Read More >>

Tutorial – a Static Lissajous Emulator

December 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 Recommending this site to your friends would be highly appreciated.   Thanks for your support!

Read More >>