### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Taming Symbols in Excel
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Fitting high order polynomials

### Recent Comments

OliviaHoros on Commenting a block of code in… Column buckling unde… on Using Frame4Buckle with the Al… Column buckling unde… on Buckling of columns with varyi… dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update DonB on Biaxial bending update Perko on Installing Adobe Reader non-DC… Python Traps | Newto… on The meaning of = in Pytho… dougaj4 on P-Y Curve function Zhitong Zhang on P-Y Curve function Matt Cornell on Newton’s Cradle Clive James and Pete… on The Barrow Poets dougaj4 on Excel to Alglib via xlwin…

# 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