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

## Brent’s Method; Update and Examples

Brent’s Method is a refinement of Newton’s Method for the numerical solution of any equation with one variable. The User Defined Function (UDF) QuadBrent was described in: The Inverse Quadratic Method 3 – Brent’s Method Following a recent question, I have … Continue reading

Posted in Arrays, Excel, Maths, Newton, UDFs, VBA
Tagged Brents method, Excel, inverse quadratic, iterative solution, Maths, UDF, VBA
1 Comment

## Spreadsheets all the way down

If you need another reason to attend Excel Summit South, watch this video, and discover that mobile phones are spreadsheets all the way down.

## A mystery curve links to Jupyter

Reviewing some of my less visited links recently, I was intrigued by a post at The Math Less Travelled: The previous post at the site provides more details of the source of the curve, and some links to an interactive … Continue reading

Posted in Charts, Charts, Excel, Maths, Newton
Tagged curve generator, Excel, Jupyter, Maths, parametric curve, Python, Scatter chart
2 Comments

## Pi day of the Century

In North America, where today is 3-14-15, it is Pi day, and since there are not 31 days in April, the rest of us have to go along with that as well. Not only is it Pi day, it’s the … Continue reading

## Linking to Python with Excel-Python, and Python matrix functions

I have been experimenting for a few weeks with a new package linking Excel to Python, by the name of ExcelPython. Here is what the author says about it: “ExcelPython is a lightweight, easily distributable library for interfacing Excel and … Continue reading

Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, Maths, Matrix Functions, Python, Simultaneous equations, sparse matrix solvers, UDF, VBA
5 Comments