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):
Further details of the PView function will be given in the next post.