This is an introductory video about creating, scaling and animating wireframe shapes in MS Excel. The tutorial is made from the ground up starting with a blank workbook. A square is created. Scaling factors are added which can turn the square into a custom size rectangle. The tutorial demonstrate the use of VBA driven spin buttons and also VBA drivenContinue Reading

This is the fourth part of tutorial about making an interactive animated Excel model of a gated ring oscillator in MS Excel 2003. This section adds a joystick to the model which smoothly adjusts the RC delay constant (vertical movement) and the number of delay stages within the ring (horizontal movement). An additional function of the joystick is to control the gatingContinue Reading

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

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.Continue Reading

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

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

The macro in this tutorial creates a near exponential variable conversion to be used for very large dynamic range input data entry . If for instance, we have to adjust a parameter from 1 to 1 million we can either make a spin button which can go from 1 to 1 million in unity steps (which would take for ever), or implementContinue Reading

Most of the models on this blog are designed for Excel 2003 or earlier versions. Sometimes however, Excel 2007 or 2010 are the only versions available even though they might be far slower when running these models. This presentation is an introduction to Excel 2007 and it was suggested to me by one of my readers. [sociallocker] [/sociallocker] Creating, Sizing,Continue Reading

Hello folks, here is a tutorial about building a clock in Excel. Enjoy! [sociallocker][/sociallocker] Building a live Excel clock by George Lungu Here are a few date and time functions in VBA: Now  : Current date and time.   Example: 7/5/00 3:16:38 PM returned by Now Date  : Current date only.           Example: 7/5/00 returned by Date Time : Current time only.          Continue Reading