Basic 3D-2D (Perspective) Visualization

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 persective calculations are done. The cube can be zoomed and it can also be rotated in azimuth and altitude using simple macros. [sociallocker][/sociallocker]

Read More >>

Pendulum

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 is an oscillatory device made up of a concentrated weight…

Read More >>