Since not everybody has Excel and more and more people are on the dumbed down new versions (2007 and 2010), I am presenting these previews to give the readers a feel of the real speed and feel of some of the models in older Excel versions (in this case 2003). This preview refers to an older model. [sociallocker][/sociallocker] Read More... "A Basic Planetary System – video preview"
This is a video preview for the 3D animated roller coaster previously presented on this blog. A tutorial on this topic will be posted later. [sociallocker]>[/sociallocker] Read More... "A 3D Animated Excel Roller Coaster – video preview"
Hi everybody, Today we’ll talk about dynamic macros very useful in engineering modeling, scientific modeling, games etc. Dynamic macros are created using two different type of loops: “For” and “Do”. – Two different but equivalent conditional “Do” loops are explored. – It is shown that macros can be assigned to drawing shapes, pictures, graph, etc. – A highly valuable Run/Pause macro… Read More... "Dynamic Macros #1"
This is an Excel workbook containing a dynamic model of a basic binary planetary system. [sociallocker][/sociallocker] Read More... "Basic Planetary Simulator"
The first two worksheets of this Excel workbook illustrate the creation and display of a rectangle by using a 2D scatter plot. They also show how to adjust its size, translate and rotate it. In the third worksheet a wire-frame cube is created. 3D-2D perspective calculations are done. The cube can be zoomed and it can also be rotated in… Read More... "Basic 3D-2D (Perspective) Visualization"
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"