Graeme Dennes has updated his Tanh-Sinh Quadrature spreadsheet to V 6.0. The new version (including full open source code) may be downloaded from:
Graeme’s summary of the new features in the spreadsheet:
- All programs run at near twice the speed of the v5.03 programs.
- The accuracy of the finite interval programs has been improved.
- All programs are written in Excel VBA.
- As implemented, the Tanh-Sinh integrator may be the fastest Excel VBA finite-interval integrator available.
5. The Romberg integrator may be the fastest and most accurate Excel VBA Romberg integrator available.
6. Now includes over 1200 test integrals with true results to 15 significant digits. 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.
7. The Plotter worksheet shows two plots: the plot of the selected function over the specified finite interval, and the (part) plot of the function after being transformed by the Tanh-Sinh function. It’s the transformed function which is integrated by the Tanh-Sinh integrator over the entire real line (-inf to +inf).
8. The workbook provides a convenient test bed for developing and implementing Excel VBA integration programs and for comparing the performance of your programs with the programs in this workbook. Replace the core integration code in one of the program modules which have the same interval type as your own program, retrofitting your code into the existing program structure.
9. Should you develop an Excel VBA Tanh-Sinh integrator program which improves on the accuracy and speed of the Tanh-Sinh program in the workbook, I urge you to leave a comment on Newton Excel Bach and I will happily recognise your contribution.
Note that the speed improvement is clearly visible when integrating VBA functions. When integrating functions entered as text on the spreadsheet nearly all the computation time is in converting the text values and symbols to numerical values.
As always, if you have any questions or comments, please leave a comment below.





