Recent Comments
Category Archives: Coordinate Geometry
Cubic Spline Update
The previous post in this series presented a User Defined Function (UDF) to fit a cubic spline to a series of points defined by XY coordinates. Each segment of the resulting spline is defined by a separate cubic curve, which may be … Continue reading
Geometric Tools
I was recently sent a link to: Geometric Tools Documentation Which has a host of pdf files with detailed instructions on all manner of geometric calculations. The focus of the site is animation for games programs, but there is plenty … Continue reading
Posted in Coordinate Geometry, Maths, Newton
Tagged Coordinate Geometry, Geometric Tools
Leave a comment
Finding Circle Centres in 3D
In 2 new functions for IP.xls I described two Excel User Defined Functions (UDFs) to find the radius and centre of a circle defined by 3D coordinates for either 3 points on the circumference, or for two tangent points and the … Continue reading
Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged 3D coordinates, Center, Circle Centre, direction cosines, Excel, IP2.xls, Radius, UDF, VBA
5 Comments
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 =PDist(Line,Points) Line is a range with at least two rows containing … Continue reading
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 Excel, Interpolation, Intersection Points, Polar Coordiantes, Rectangular Coordinates, UDF, VBA
37 Comments
Newton Excel Bach, not (just) an Excel Blog 