eJMT Abstract


Title 3D Formulas for Spreadsheet
Author Øystein NORDVIK
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.