EJMT Abstract
Title |
3D Formulas for Spreadsheet |
Author |
ARRAY(0x1ca36765b70) |
Volume |
12 |
Number |
1 |
I will in this paper present a new model for a three dimensional coordinate system in which it is possible to visualize
three dimensional objects. In order to find the two dimensional coordinates needed, I use the principle of parallel
perspective for the unit vectors combined with the principle of the central perspective and a formula for the vanishing
points. The two formulas x and y for a general point (x 1 , y 1 , z 1 ) is found by the use of linear algebra. The formulas are
such that they can be used in any spreadsheet and visualized by connected scatter plots. Any object visualized this way
can be rotated by two independent variables, horizontal angle h and vertical angle v.