Instant 3D-2D Perspective Mapping – the Navigator Functions – a convenient pair of user defined functions

02/02/2011

     This tutorial explains a pair of important user defined functions, the “Navigator_u()” and the “Navigator_v()”. These functions save the user nine columns of formulas by calculating the effects of: 3-dimenssional shift, rotations around the three axes of coordinates and 3D-2D perspective mapping. These user defined functions are also easy to use compared to writing all the perspective mapping equations from scratch. In the previous 3D perspective tutorials we took…

Read More >>

3D-2D Perspective Mapping in Excel – part #2

01/31/2011

The first half of this presentation dealt with mapping a 3D scene onto a 2D surface which can be a computer screen, a projection screen or the retina of the eye. By doing so we preserve much of the feel of depth of the scene. Of course when we look at an picture we get only part of the feel of depth because our both eyes see the same image….

Read More >>

3D-2D Perspective Mapping in Excel – part #1

01/31/2011

In computer graphics we often need to be able to display a three-dimensional image in two dimensions and preserve the perspective appearance. If we walk on a straight road, it appears that the road narrows with the distance. This is the perspective effect and it is a result of mapping a three-dimensional image on a two-dimensional surface (i.e. a computer monitor, a screen, or the retina of the eye). This tutorial…

Read More >>

Modeling a Three-Pendulum Harmonograph – tutorial: part #2

01/23/2011

Hi guys, here is the second part of a tutorial describing the matematical equations used in modeling a three-pendulum harmonograph (automatic drawing machine). It pertains to the second version of the model. This section describes the kinematic equations involved in the articulated linkage mechanism on the top of the table, the custom spreadsheet functions used in the model and some overall considerations about the partition of the spreadsheet.  This is an…

Read More >>

Modeling a Three-Pendulum Harmonograph – tutorial: part #1

01/19/2011

Hi guys, here is the first part of a tutorial describing the matematical equations used in modeling a three-pendulum harmonograph (automatic drawing machine). It pertains to the second version of the model. This section refers only to the kinematic equations for the movement of three pendulums. A second section will be published later and it will describe the kinematic equations involved in the articulated linkage mechanism on the top of the table,…

Read More >>