IP.xls updated

The spreadsheet IP.xls has been updated (previous post) with the addition of a function to find the minimum perpendicular distance from a point (or series of points) to a polyline: Pdist


Line is a range with at least two rows containing XY coordinatesof the polyline.  Points is a range with XY coordinates of one or more points.

Pdist returns an array of 3 values for each point:

The distance from the point to the nearest segment, and the X and Y components of this distance.

Open source code is included in the download file.

The screen shot below shows output from this function.

PDist output

PDist output

This entry was posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA. Bookmark the permalink.

1 Response to IP.xls updated

  1. Pingback: Daily Download 16: Intersections, interpolations, and rotations | 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.