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

May 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

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

Anaglyph Charts Demo #2- an animated heat transfer model using a red-cyan wireframe chart

May 12, 2011

This is another basic demo investigating the feasibility of using anaglyph wireframes to plot scientiffic data. Open the attached worksheet and with your 3D glasses on, watch the chart. The data is a dynamic temperature map obtained from a 2D heat transfer model in a metal plate. The heat model is complete and you can run it with various parameters. You can hit “Start / Pause” and manually adjust the pitch and…

Read More >>

Anaglyph Charts Demo #1- creating 3D effects on charts using red-cyan elementary chips (sprites)

May 11, 2011

This is a basic demo investigating the feasibility of using anaglyph sprites to plot scientiffic data. Open the attached worksheet and with your 3D glasses on, watch the chart. The data results are various temperature maps obtained from a 2D heat transfer model in a metal plate. You have 4 different selectable mapps there but you can also invert the pattern using the “Flip” button. I find the 3D effect to be decent but not good enough…

Read More >>