Excel Tetris – a video demonstration

06/29/2011

This is a video demo of an older game of Tetris model in Excel. The model is designed for Excel 2003 or earlier versions and it’s too loaded with graphics to work well in Excel 2007 or 2010. You can however try opening it in the newer versions of Excel. I wasn’t personally able to run it satisfactory in 2007. [sociallocker][/sociallocker]

Read More >>

A Game of Tetris in Excel – video preview

06/28/2011

This is a video preview of an older game of Tetris model in Excel. The model is designed for Excel 2003 or earlier versions and it’s too loaded with graphics to work well in Excel 2007 or 2010. You can however try opening it in the newer versions of Excel. I wasn’t personally able to run it in 2007. [sociallocker][/sociallocker]

Read More >>

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…

Read More >>

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…

Read More >>