PView Function

As promised in the previous post, here are further details of the PView User Defined Function (UDF), included in the IP2 spreadsheet, which can be downloaded (including full open source code) from IP2.ZIP.

The PView UDF works by multiplying the 3D coordinates of any set of points by a rotation matrix.  The resulting array of 2D coordinates can be plotted in an XY (scatter) chart in the usual way.  The function input and output is described in the screen shot below, together with a plot of an example; a simple box structure with a doorway, and a spiral line plotted on one wall.

PView input and plot of sample output (click for full size view)

Part of the output array is shown in the next screen shot.  The function output is a single array, which must be entered as an array function.

Pview Output array

This entry was posted in Arrays, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA and tagged , , , , , , . Bookmark the permalink.

3 Responses to PView Function

  1. Pingback: Alternative IP and Rotations | Newton Excel Bach, not (just) an Excel Blog

  2. Pingback: Daily Download 16: Intersections, interpolations, and rotations | Newton Excel Bach, not (just) an Excel Blog

  3. Pingback: Charts and Charting | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s