Category Archives: UDFs

Numerical Integration; Tanh-Sinh Quadrature v. 4.42

Posted on March 17, 2019 by

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 , , , , , , , , | Leave a comment

Multiple Integration with Scipy

Posted on January 31, 2019 by

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

mpmath for Excel

Posted on January 13, 2019 by

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 , , , , , , , , | Leave a comment

Transferring large arrays with Pyxll

Posted on January 5, 2019 by

Pyxll is a commercial Excel add-in linking Excel and Python.  The latest version  offers greatly improved performance in transferring data between Excel and Python as Numpy arrays, amongst many other new features and improvements. To check what this means in practice, … Continue reading →

Posted in Arrays, Excel, Frame Analysis, Link to Python, PyXLL, UDFs, VBA | Tagged , , , , , , | Leave a comment

More updates to ArcSpline and IP2

Posted on December 27, 2018 by

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 , , , , , , , | Leave a comment

More SciPy Solvers

Posted on December 19, 2018 by

The xlwings Scipy spreadsheet has been updated with a new example of the xl_SolveF function, that uses the Scipy Optimize root function.  The new spreadsheet can be downloaded from: xlScipy3.zip The new example uses a python function ic_calc (included in the … Continue reading →

Posted in Excel, Link to Python, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , | Leave a comment

Numerical Integration; Tanh-Sinh Quadrature v. 4.4

Posted on November 23, 2018 by

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