Graeme’s summary of the new features in the spreadsheet:

The Tanh-Sinh quadrature workbook has been enhanced as follows:

The Tanh-Sinh integrator in the workbook is the fastest and simplest finite-interval integrator on the planet!! It’s the new benchmark for Tanh-Sinh integrator performance!

The speed of the Tanh-Sinh, DE1, DE2 and DE3 programs has been increased through using recent (2017) programs provided by César Rodríguez. The programs are simpler and faster than those used previously. The state-of-the-art in Tanh-Sinh integration has been moved forward.

A fast finite interval program TINT has been added. It runs at over twice the speed of the Gauss-Kronrod program.

The speed of the Gauss-Kronrod program has been improved through modifications developed by Berntsen, Espelid and Sorevik.

The Romberg integrator, written by the author, may be the fastest and most accurate Romberg integrator on the planet!!

Now includes over 1200 test integrals with true results. This may be the largest set of diverse test integrals available at no cost. It includes several of the “standard” sets of test integrals in wide use.

The Plotter worksheet now shows two plots: the plot of the selected function over the finite interval (a,b), and the plot of the selected function after being transformed by the Tanh-Sinh function.

My on-sheet demonstration of the workings of the Tanh-Sinh code has now also been added to the spreadsheet (see Numerical integration with on-sheet calculations for background and sample screen-shots).

The WP 34s version of the code by César Rodríguez is available from :

See the Copyright tab of the download spreadsheet for many other links.

Update: 7th Nov 2020:

Graeme has made a minor correction to the double-exponential limit constant (now set to 6.56) in the 2 x T-S and 3 x DE programs. This is the figure for which exp(exp(6.56)) remains (just) under the 1.79 x 10^308 max figure as set by IEEE 754.

The version number is now 5.01, and the new version may be downloaded from the link at the top of this post.

Hello,
I just tested your spreadsheet. That is a great work but i encounter difficulty to make it run properly because it seems the VBA code doesn’t compilate on my version of Excel office 2016 32 bits

Hi there, I can’t find a direct contact for Graeme, but I wonder if we might have permission to use your list of test functions in the Boost C++ software project (www.boost.org) for testing against our DE integrators (https://www.boost.org/doc/libs/master/libs/math/doc/html/math_toolkit/double_exponential/de_tanh_sinh.html). We would obviously give full attribution, but unfortunately we are NOT able to use the GPL licence, it has to be this one: https://www.boost.org/LICENSE_1_0.txt. If you’re able to put me in touch with whoever can agree or not to this that would be wonderful.

Hello,

I just tested your spreadsheet. That is a great work but i encounter difficulty to make it run properly because it seems the VBA code doesn’t compilate on my version of Excel office 2016 32 bits

LikeLike

Thanks for letting me know. I’ll have a look and get back to you.

LikeLike

I just downloaded the latest version (5.02) and ran it on a 32 bit version of Excel 2010.

Everything seems to be working OK. Can you provide more details of the problems you are having?

LikeLike

Hi there, I can’t find a direct contact for Graeme, but I wonder if we might have permission to use your list of test functions in the Boost C++ software project (www.boost.org) for testing against our DE integrators (https://www.boost.org/doc/libs/master/libs/math/doc/html/math_toolkit/double_exponential/de_tanh_sinh.html). We would obviously give full attribution, but unfortunately we are NOT able to use the GPL licence, it has to be this one: https://www.boost.org/LICENSE_1_0.txt. If you’re able to put me in touch with whoever can agree or not to this that would be wonderful.

Many thanks for your help in this.

LikeLike