Tag Archives: Interpolation

Another update to IP.xls

Following some suggestions from Mike Seymour I have modified my polyline intersection function, and added a new version. The changes are: The data ranges for the new function, IP4(), are entered as four separate ranges, so the X and Y … Continue reading

Posted in Excel, Maths, UDFs, VBA | Tagged , , , , | 1 Comment

Intersections, interpolations, and rotations

Amongst the many and varied functions provided by Excel (or as far as I know any other spreadsheet) there are none that provide a one step process for linear interpolation, finding the intersection points of lines, or conversion between polar … Continue reading

Posted in Coordinate Geometry, Excel, UDFs, VBA | Tagged , , , , , , | 37 Comments