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 driven… Read More... "How to Create Wire Frame Shapes for Excel Animation – Video Tutorial – Part 1"
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 gating… Read More... "An Interactive Gated Ring Oscillator Tutorial – part #4"
This is the third part of tutorial about making an interactive animated Excel model of a gated ring oscillator in MS Excel 2003. This section deals with upgrading the model from a static table based one (with only 800 time steps) to a hybrid static-dynamic which is reasonably fast, yet it can run for an indefinite number of time… Read More... "An Interactive Gated Ring Oscillator Tutorial – part #3"
This is a video preview of the analog clock series which include a model section and a tutorial section. [sociallocker][/sociallocker] Read More... "An Analog Clock Model – video preview"
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 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"
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"
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 implement… Read More... "Near-Exponential VBA Conversion"
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,… Read More... "Creating, Sizing, Translating and Rotating 2D Shapes in Excel 2007"
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. … Read More... "How to Make an Analog Clock in Excel"