### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Taming Symbols in Excel
- The angle between two vectors, Python version
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- The angle between two vectors, in 2D or 3D
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Using VBA Evaluate as an Array Function

### Recent Comments

josh on Import Data from a Picture to… Melanie Safka + Mile… on Melanie Safka Mohd Yousef on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update dougaj4 on Beam Fixed End Actions by Maca… Peka Odendaal (@PKOd… on Beam Fixed End Actions by Maca… Gerardo Freyre on The history of the theory of b… dougaj4 on Time in hours and minutes betw… SDAmy on Time in hours and minutes betw…

# Tag Archives: defined names

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

## Charting a Mathematical Function with Defined Names

This post is a compilation of information from Stephen Bullen, Jan Karel Pieterse, and George Lungu. To quote JKP “When doing mathematics, wouldn’t it be nice if we could type an equation into a cell in Excel and immediately see … Continue reading

Posted in Arrays, Charts, Excel, Maths
Tagged Chart, defined names, Excel, Lissajous Figures, plot function
7 Comments