Tag Archives: numerical integration

Tanh-Sinh Quadrature V4.0

Since last September Graeme Dennes has continued work on his Tanh-Sinh Quadrature spreadsheet, and has recently released Version 4.0, which can be downloaded from: Tanh-Sinh. As usual, the download includes full open-source code and extensive documentation. The new version includes routines … Continue reading

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

Daily Download 17: Numerical Integration

Some simple numerical integration functions (using the trapezoidal rule and Simpson’s Rule) were included in the Eval2 spreadsheet, presented on Daily Download Day 15, but for purposes were better accuracy and/or higher speed are required more sophisticated methods will do a … Continue reading

Posted in AlgLib, Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , | Leave a comment

Daily Download 15: Evaluation of formulas in text

VBA has an Evaluate function that returns the numerical value of any text string representing a mathematical formula, but this is not directly available from the spreadsheet.  Today’s download is a User Defined Function (UDF) to provide this functionality, together with examples … Continue reading

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , | 1 Comment

Tanh-Sinh Quadrature V3.0

I have received from Graeme Dennes  another update to his Tanh-Sinh Quadrature spreadsheet, offering fast and convenient numerical integration functions.  The spreadsheet can be downloaded from: Tanh-Sinh Quadrature (including, as usual, full open source code). Here is Graeme’s description of the changes: Tanh-Sinh Quadrature … Continue reading

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

Tanh-Sinh Quadrature V2.1

Graeme Dennes has released another update to his Tanh-Sinh Quadrature spreadsheet, which can be downloaded from:  Tanh-Sinh Quadrature (including, as usual, full open source code).  Here is Graeme’s description of the changes: In Version 2.0, the nodes and weights array data … Continue reading

Posted in Excel, Newton, Numerical integration, UDFs, VBA | Tagged , , , , | 2 Comments