A video preview of yet another sprite animation model in Excel. [sociallocker][/sociallocker] Read More... "City Lights in North America – video preview"
A video preview to a sprite animation model in Excel. [sociallocker][/sociallocker] Read More... "Day and Night Over the Atlantic – 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"
In certain models we need to be able to change the scale of the chart axes function of the result of a simulation. Excel charts do have auto-scaling as a default option but sometimes the scaling values we get are not what we need. Another reason against using auto-scaling is that during the time the model runs, the scale self-adjusts and… Read More... "Easy Zoom – Chart Axis Scaling Using VBA"
Here is another example of sprite animation in Excel (Office 2007 will work fine, though a little bit slower). We’d love to hear from you. George Read More... "City Lights in North America – sprite animation"
Hi guys, here is an animation I made yesterday by downloading 120 pictures of the Earth taken 12 minutes apart by satelites above the equator at 30 degrees longitude west on 10/01/2010. The pictures are 500 x 500 pixels and they are pasted as a background of a chart by a slimmed down VBA macro. You can change the speed of… Read More... "Day and Night Over the Atlantic – an example of sprite animation"
A roller coaster in Excel 2003 in 3-dimension (perspective view). To start de ride after download, click the little sun icon in the NE corner of the chart. Most of the calculations are done in the spreadsheet with very little VBA as a “glue”. The display is created on a plain 2D scatter plot. [sociallocker][/sociallocker] Read More... "Animated Roller Coaster in Excel"
This is a basic pendulum model in Excel. Enjoy! [sociallocker][/sociallocker] This is an animated Excel model of a pendulum that you can download here. For fast modeling speed, please use older versions of excel (1997-2003). In the following section, background information about pendulums in general will be presented: Pendulum meaning, a simple pendulum definition, what is a pendulum? A pendulum… Read More... "Pendulum"