### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Fitting high order polynomials
- The angle between two vectors, Python version
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Retrieving unique values from a range or array ...
- Combining arrays

### Recent Comments

# Tag Archives: perspective projection

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

## Daily Download 16: Intersections, interpolations, and rotations

There is only one download file today: http://interactiveds.com.au/software/IP2.ZIP , but it contains a wealth of different functions dealing with 2D and 3D geometry, including intersections of lines, circles and spheres, simple interpolation functions, and functions for rotating points in 2D … Continue reading

Posted in Coordinate Geometry, Drawing, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, interpolations, intersections, perspective projection, polar coordinates, rotations, UDF, VBA
Leave a comment

## Alternative IP and Rotations

In response to the 3D Intersections and PView Function posts Lori Miller has sent me two very elegant alternative ways of achieving similar results. The first is an on-spreadsheet solution to the intersection of two lines, using the LinEst function: Note … Continue reading

Posted in Arrays, Charts, Charts, Coordinate Geometry, Excel
Tagged defined names, Hypecube, IP, perspective projection
Leave a comment

## PView Function

As promised in the previous post, here are further details of the PView User Defined Function (UDF), included in the IP2 spreadsheet, which can be downloaded (including full open source code) from IP2.ZIP. The PView UDF works by multiplying the 3D … Continue reading

Posted in Arrays, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA
Tagged Excel, perspective projection, PView, rotation matrix, UDF, VBA, XY chart
3 Comments