Category Archives: Newton

Numerical Integration; Tanh-Sinh Quadrature v. 4.42

Posted on 17/03/2019 by dougaj4

Back to Newton and Excel. I recently received a new update to the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes, which may be downloaded from: Tanh_Sinh Quadrature. From the Readme: The Tanh-Sinh quadrature workbook has been enhanced as follows: The Tanh-Sinh … Continue reading →

Posted in Charts, Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , , | 10 Comments

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