Category Archives: UDFs

Tanh-Sinh Quadrature Update 2

Posted on 22/11/2010 by dougaj4

I have copied the latest version of Graeme Dennes’ Tanh-Sinh Quadrature spreadsheet to my download site:  Click here to download Tanh-Sinh.zip As before, the download includes full open-source code, and detailed notes by Graeme. In the new version the Gauss-Kronrod function … Continue reading →

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

Getting hard disk physical serial numbers

Posted on 21/11/2010 by dougaj4

There was a question at Eng-Tips about how to get the physical serial number of a hard disk (rather than the soft number, that is changed by a re-format): http://eng-tips.com/viewthread.cfm?qid=285948&page=1 A search found this discussion with the answer: http://thedailyreviewer.com/office/view/programmatically-obtain-the-hard-disks-serial-number-from-vba-101853101 (see answer … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | 1 Comment

Revision to CSpline2.xls

Posted on 11/11/2010 by dougaj4

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 , , | 6 Comments

Tanh-Sinh Quadrature update

Posted on 20/10/2010 by dougaj4

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 , , , , , , , | 9 Comments

Interactive File List

Posted on 20/10/2010 by dougaj4

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 →

Posted in Excel, UDFs, VBA | Tagged , , | Leave a comment