Recent Comments
Category Archives: VBA
Revision to CSpline2.xls
It was recently reported to me that the cubic spline spreadsheet CSpline2.xls (posted here) was crashing on loading in Excel 2003. It seems that the problem was with the ChartSpline function, and that there are no problems if this function is … Continue reading
Posted in Drawing, Excel, Maths, UDFs, VBA
Tagged bug fix, ChartSpline function, Cubic spline
6 Comments
Tool-tip tip
Mike Woodhouse (Grumpy Old Programmer) recently posted a handy little tip about tool-tips in the Visual Basic Editor. If you hover over a variable whilst de-bugging a VB routine, the current value of the variable is displayed as a tool-tip: but … Continue reading
Tanh-Sinh Quadrature update
Graeme Dennes has been continuing work on his Tanh-Sinh Quadrature function, and recently sent me a revised version, which can be downloaded from: Tanh-Sinh.zip The main change is a new automatic tolerance adjustment feature which automatically increases the tolerance for … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, Gauss-Kronrod, numerical integration, Quadrature, Romberg, Tanh-Sinh, UDF, VBA
9 Comments
Interactive File List
Microsoft recently introduced the facility to embed a link to a live spreadsheet stored on Windows Skydrive. This is my first attempt to use this facility. The spreadsheet below is a list of all the files published on this blog, together … Continue reading
Faster Integration with the Tanh-Sinh Method
In my previous post about numerical integration I mentioned that I would be writing about another lesser known method providing better speed and/or accuracy in many cases. The method is known as Tanh-Sinh quadrature, and has been implemented in Excel by a reader … Continue reading
Posted in Excel, Maths, Numerical integration, UDFs, VBA
Tagged Excel, Gauss-Kronrod, numerical integration, Quadrature, Romberg, Tanh-Sinh, UDF, VBA
3 Comments
Newton Excel Bach, not (just) an Excel Blog 