Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Cubic Splines
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Deflections and Moments in Rectangular Plates
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Installing Adobe Reader non-DC version.
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
Recent Comments
Tag Archives: Center
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
Two new functions for IP.xls
Edit 8 Feb 2012: The functions described below have been superseded by new versions which are described at https://newtonexcelbach.wordpress.com/2009/08/18/finding-circle-centres-in-3d/. That link also gives a description (with diagrams!) of how the functions work. The download file for the new versions is … Continue reading