### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Using Goal Seek on Multiple Cells
- Commenting a block of code in VBA
- 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
- The Conjugate Beam Method
- Cubic Splines
- Downloads by category
- Deflections and Moments in Rectangular Plates

### Recent Comments

dougaj4 on Tanh-Sinh Quadrature v. 5… metroxx on Tanh-Sinh Quadrature v. 5… dougaj4 on Tanh-Sinh Quadrature v. 5… metroxx on Tanh-Sinh Quadrature v. 5… dougaj4 on Numerical Integration With Tan… Tanh-Sinh Quadrature… on Numerical Integration With Tan… Graeme Dennes on Numerical Integration With Tan… John Maddock on Numerical Integration With Tan… John Maddock on Numerical Integration With Tan… Charles Chika on Frame Analysis with Excel… dougaj4 on Weighted Least Squares Regress… NotOP on Weighted Least Squares Regress… Installing PyPardiso… on Making Finite Element Analysis… John Maddock on Numerical Integration With Tan… Graeme Dennes on Numerical Integration With Tan…

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

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