Tag Archives: Maths

Brent’s Method; Update and Examples

Posted on December 6, 2017 by dougaj4

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 , , , , , , | 4 Comments

Spreadsheets all the way down

Posted on February 22, 2016 by dougaj4

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

Posted in Excel, Maths, Newton | Tagged , , | Leave a comment

A mystery curve links to Jupyter

Posted on July 16, 2015 by dougaj4

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

Pi day of the Century

Posted on March 14, 2015 by dougaj4

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 →

Posted in Charts, Excel, Maths, Newton | Tagged , , , , , | 6 Comments

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

Posted on May 22, 2014 by dougaj4

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 , , , , , , , , | 5 Comments