#### Creating a Digital Clock #2 – sprite driver, timing macro and functions, full model

01/09/2011

Hi guys, here is the final part of tutorial about creating a digital clock in Excel. It is a good tutorial about general use of sprites in animation, especially the first half. Tell us your thoughts. George [sociallocker][/sociallocker]

#### Creating a Digital Clock #1 – sprite generation

01/06/2011

Hi guys, this is part #1 of a tutorial showing how to generate sprites used in a digital clock model. Sprites are typically simplified images (usually two-dimensional) which are used to replace complex but remote 3D-objects in an image. When an object is far away from the viewer a three-dimensional representation is not necessary since the eye cannot see all the details, therefore the object is replaced with a much simple object…

#### Resizing, Translating and Rotating Shapes in Excel

11/15/2010

Five different shape alterations are presented: 1. Resizing – which can be done independently on each axis by multiplying the coordinates by a certain factor while the shape is centered in the origin. 2. Translation – which can be done independently on each axis by adding or subtracting a term to each coordinate. 3. Simple rotation – formulas were derived for rotation of a shape centered in origin by a…

#### Static VBA Macros

11/02/2010

Most parameters used in animations or physical models are changed by buttons called “spin buttons”. Excel is a spreadsheet but behind the table there is a engine used to automate certain spreadsheet functions. This engine can be programmed in a language with a very easy syntax called Visual Basic for Applications, in short VBA. VBA is a very convenient feature in Excel and it can be used almost without any…

#### Creating Shapes on a 2D Scatter Chart

10/01/2010

This post shows you how to draw a closed polygon (in this case a triangle for simplicity) on a 2D scatter plot in Excel 2003. 1. For this you need to sketch what you want to draw on a paper or just create a mental visualization. 2. In this sketch you need to define the vertices (corners) of the shape and figure out the approximate coordinates. 3. Create a table…