Following the previous post, I have added several new functions connected with intersections of lines and planes, and a function to generate a perspective plot from 3D coordinates. The new functions have been added to the IP2.xls worksheet, which can be downloaded (including full open source code) from IP2.ZIP.

Note that all the functions return results as an array, and must be entered as an array function:

- Enter the function as shown in the examples
- Select the complete output range, with the function in the top-left corner
- Press F2 (edit)
- Press ctrl-shift-enter

The new functions are shown in the screen shots below (click any image for full size view):

PDist3D - Perpendicular distance from a point to a plane

PlaneCoeff; Coefficients of a plane specified by 3 points

IPPlaneLine: Intersection point of a plane and a line segment

IPPlanePlane: Intersection line of two planes

PView: Perspective projection of 3D Lines, showing IPPlanePlane output

Further details of the PView function will be given in the next post.

### Like this:

Like Loading...

*Related*

Pingback: Intersections, interpolations, and rotations | Newton Excel Bach, not (just) an Excel Blog

Pingback: PView Function | Newton Excel Bach, not (just) an Excel Blog

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

line 1 ( x , y)

-35 100

-25 101

-18 105

-15 105

-8.123762376 108

-7.663 108

-4.507949153 109.5775254

-3.924997729 109.8690001

0 110

3.925 109.869

7.663 108

20.3282 101.6674

25 101

25.0001 100

———————————-

line 2

-3.925 109.869

0 110

3.925 109.869

13.663 105

100 105

—————————————

ip udf not giving all meeting points

please post revised version

LikeLike

The problem is that the two lines are exactly coincident between 0 110 and

3.925 109.869, so the end points of these lines are not treated as intersection points.

LikeLike

Nice tool. Not sure how to make this in add-in. Is this possible ?

LikeLike

Yes, just save as an add-in (xlam), then register the add-in using File-Options-Addins, click the Go… button next to Excel add-ins down the bottom, and select the box for IP2 (or whatever you have called it).

All the functions should then be available from any open workbook.

LikeLike