### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using Goal Seek on Multiple Cells
- Downloads by category
- Cubic Splines
- Commenting a block of code in VBA
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Daily Download 8: Drawing in Excel
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- The angle between two vectors, Python version
- Downloads
- Using LINEST for non-linear curve fitting

### Recent Comments

Bouarfa Mahi on Using the AlgLib ODE (Runge-Ku… dougaj4 on Using the AlgLib ODE (Runge-Ku… Bouarfa Mahi on Using the AlgLib ODE (Runge-Ku… Larry on Scarborough Fair g2-9ed9acc685824c666… on Scarborough Fair Daniel Crotzer on About Newton Excel Bach More SciPy Solvers |… on xlwSciPy update for Python… Graeme Dennes on Numerical Integration; Tanh-Si… Paul on Numerical Integration; Tanh-Si… Graeme Dennes on Numerical Integration; Tanh-Si… Paul on Numerical Integration; Tanh-Si… Paris Altidis on Numerical Integration; Tanh-Si… Erik Wynn on Cubic Splines dougaj4 on Cubic Splines Erik Wynn on Cubic Splines

# Tag Archives: Intersection Points

## IP2_py Update for Python3

The spreadsheet IP2_py provides a large number of geometric functions, including intersection points of lines, circles and planes, interpolation, rotations, and converting between coordinate systems. Many of the functions are available in VBA and Python versions. The Python code has now … Continue reading

## 3D Intersections

Following a discussion at the Eng-Tips Forum, I have written an Excel User Defined Function (UDF) to find the intersection point of two 3D line segments. The UDF has been added to the IP2 spreadsheet, which is available for free … Continue reading

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged 3D lines, Excel, Intersection Points, UDF, VBA
7 Comments

## 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