Category Archives: Newton

Sydney Opera House: the designs that didn’t make it

Posted on 10/02/2019 by dougaj4

From the Guardian: In 1956, the New South Wales premier Joseph Cahill announced a competition – open to anyone – to design a national opera house at Bennelong Point in Sydney. There were more than 200 entries and the eventual … Continue reading →

Posted in Bach, Newton | Tagged , | Leave a comment

Multiple Integration with Scipy

Posted on 31/01/2019 by dougaj4

Scipy has 3 functions for multiple numerical integration in the scipy.integrate module: dblquad: Compute a double integral. tplquad: Compute a triple integral’ nquad: Integration over multiple variables. I have written six functions to call these functions from Excel, via Pyxll: Each … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , | 6 Comments

Another (very slow) way of computing pi

Posted on 24/01/2019 by dougaj4

The previous post included 100 Python code one-liners for calculating pi that recalculates in a fraction of a second.  The video below shows an alternative approach that is a little slower: How much slower?  If you had a computer that would … Continue reading →

Posted in Bach, Maths, Newton | Tagged , , | 2 Comments

mpmath for Excel

Posted on 13/01/2019 by dougaj4

mpmath has been mentioned in passing here before, but not in any detail.  The mpmath site says: mpmath is a free (BSD licensed) Python library for real and complex floating-point arithmetic with arbitrary precision. It has been developed by Fredrik … Continue reading →

Posted in Excel, Link to Python, Maths, PyXLL, UDFs, VBA, xlwings | Tagged , , , , , , , , | 7 Comments

More updates to ArcSpline and IP2

Posted on 27/12/2018 by dougaj4

I have uploaded version 2.18 of the IP2 spreadsheet to: IP2.zip The new version includes updates to the IP, IP_4, and ArcSpline functions, as described below.  The download is free and includes full open-source code. The IP and IP_4 functions find … Continue reading →

Posted in Arrays, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , | 2 Comments