Category Archives: Numerical integration

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

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

Numerical Integration; Tanh-Sinh Quadrature v. 4.4

Posted on 23/11/2018 by dougaj4

Update 27 Nov 2018: Version 4.41 now available from the link below, with minor modifications for compatibility with Excel 2007. I recently received a new version (4.4) of the numerical integration spreadsheet by Graeme Dennes which is now available for … Continue reading →

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

Using Section Properties- Group

Posted on 24/06/2018 by dougaj4

Following a recent comment I have updated the documentation for finding the section properties of groups of shapes in the Section-Properties-Group spreadsheet.  The revised file can be downloaded from: Section Properties07-Group.zip The screenshots below illustrate use of the Group function to … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , | 8 Comments

xlwSciPy update for Python 3

Posted on 09/04/2018 by dougaj4

The xlwSciPy spreadsheet allows a wide variety of the science and maths functions in the Python Numpy and Scipy libraries to be called directly from Excel.  The spreadsheet has now been updated for use with Python 3.  The spreadsheet and … Continue reading →

Posted in Coordinate Geometry, Differential Equations, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Python Pandas, UDFs, VBA, xlwings | Tagged , , , , , , | 2 Comments