Category Archives: Excel

Tanh-Sinh Quadrature via F2PY – Part 2

Posted on 01/02/2016 by dougaj4

Lets look at some details of the coding. The original code (available here) includes routines “intdeini” to generate an array of points and weights of the quadrature formula, and “intde” to carry out the integration of any supplied function “f”. … Continue reading →

Posted in Excel, Link to dll, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , , , | Leave a comment

Tanh-Sinh Quadrature via F2PY

Posted on 31/01/2016 by dougaj4

Fast and accurate numerical integration routines based on the Tanh-Sinh method are available as Excel VBA based functions in the Tanh_Sinh Quadrature spreadsheet by Graeme Dennes.  Graeme’s VBA code is based on open source Fortran code by Takuya Ooura, which … Continue reading →

Posted in Excel, Fortran, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , , , | Leave a comment

Running Fortran from Python with F2PY

Posted on 13/01/2016 by dougaj4

The last post looking at using the Python F2Py package said: It is also necessary to install a Fortran compiler.  After some trial and error I found that the MinGW (Minimalist GNU for Windows) package worked well. Trying some simple examples … Continue reading →

Posted in Excel, Link to Python, NumPy and SciPy | Tagged , , , , | Leave a comment

xlSciPy – Python SciPy for Excel; Update with new functions

Posted on 04/01/2016 by dougaj4

The xlSciPy spreadsheet, previously described here, has been updated with new functions for integration, finding equation roots and maxima and minima, solving systems of non-linear equations, and evaluation of equations entered as text.  The new version (including full open-source VBA … Continue reading →

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

Worksheetfunction.Transpose – changed behaviour in Excel 2013 and 2016

Posted on 01/01/2016 by dougaj4

It is (fairly) well known that when using Worksheetfunction.Transpose on an array in VBA the array must be no more than 65,536 (2^16) rows long, or it will return an error. Recently when using Excel 2016 (32 bit) I thought … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , , , | 6 Comments