VertX – a Very Useful Macro for Extracting the Vertex Coordinates of Freeforms – part #2

05/15/2011

The first macro created in this section of the tutorial improves on the previously developed macro by correcting the up-down orientation of the shape, referencing the shape position to the coordinate of the first drawn point and closing the shape by repeating the coordinates of the first point at the end of the table. A last macro is then created which can retrieve multiple shape vertex coordinates, placing them in a table…

Read More >>

VertX – a Very Useful Macro for Extracting the Vertex Coordinates of Freeforms – part #1

05/14/2011

Using autoshape freeforms is a very easy way to duplicate object outlines from pictures. It is convenient to create a freeform and once created, its vertices (points) can be edited with without difficulty.  Aditional points can be inserted and others can be deleted. This is a tutorial about a series of macros which allow the extraction of freeform vertex coordiantes to a worksheet range in Excel. These coordinates can be later employed to create 3D wireframe…

Read More >>

Excel Drawing – creating graphical object data

05/13/2011

This tutorial will introduce the reader to creating simple drawings in Excel by using the “Freeform” auto shape. Later on, we will be able to convert this data in x-y-z vertex information for various models by using a macro. [sociallocker][/sociallocker]

Read More >>

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…

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 >>