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:
From the Readme:
The Tanh-Sinh quadrature workbook has been enhanced as follows:
- The Tanh-Sinh integrator in the workbook may be the fastest finite-interval integrator on the planet!!
- The speed of the DE programs has been doubled.
- 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.
- Minor change to allow compatibility with Excel 2007.
- Minor correction.
Graeme Dennes
Newton Excel Bach, not (just) an Excel Blog 
As absolutely no one else has put an example of using this quadrature method in Excel on the web it I would help a lot of folks to see an example ( non-VBA for us dummies!)
LikeLike
You can find a list of posts related to this spreadsheet at:
https://newtonexcelbach.com/2012/10/03/daily-download-17-numerical-integration/
and these give more background information.
But really the best bet is to download the latest version and look at the many examples in there. Note that you don’t need any VBA to use the spreadsheet, you just enter the function in the same way as a built in Excel function, but if you are interested in the coding it is all open source, and very well documented by the author (Graeme Dennes).
Any questions, please ask.
LikeLike
I am writing a book on Excel Math use, hopefully to provide students of color or disadvantaged to see how it could stimulate their discovery in science, make better decisions and maybe get a fun rewarding job, as I had as an engineer . So I need to show how to execute a problem.
LikeLike
Did you download the spreadsheet?
I am not sure what you are looking for exactly, some practical examples, or working through the maths on the spreadsheet?
LikeLike
I need practical examples executed on spreadsheet without VBA to show how the method works.
I did download a spreadsheet but haven’t learned how to reverse engineer a VBA program.
LikeLike
Dave – I’m having a look at this, and making some progress, although I’m not sure how useful it will be for a student text as the procedure is fairly complex compared with the more widely known numerical integration methods, and I’m struggling to understand how it all works myself.
Could you send your email contact details to dougaj4 at the gmail address, and I’ll send a spreadsheet to have a look at when I have tidied things up.
LikeLike
That would be wonderful! Lots of talk, much of it confusing, on the web. I set up a spreadsheet with all the abscissas and weights, but still get the wrong answer, A lot of people could benefit if you posted that sheet
LikeLike
See https://newtonexcelbach.com/2020/07/08/numerical-integration-with-on-sheet-calculations/
for spreadsheet calculations working through a simplified (but still very fast and accurate) Tanh-Sinh integration procedure.
LikeLike
Pingback: Numerical integration with on-sheet calculations | Newton Excel Bach, not (just) an Excel Blog
Pingback: Numerical integration with on-sheet calculations | Newton Excel Bach, not (just) an Excel Blog