Recent Comments
Tag Archives: VBA
Interpolation Update
The interpolation functions in IP2.xls have been given an overhaul: The linear and quadratic interpolations routines have been modified to accept negative values. All the routines have been modified to convert the table range to an array, rather than using a … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Excel, Interpolation, logarithmic interpolation, quadratic interpolation, UDF, VBA
4 Comments
Maximum distance between two points
I have just written a short User Defined Function (UDF) to find the maximum distance between any two points from a list of coordinates, and since it may be useful to others, I will post it here. Here is the … Continue reading
Tanh-Sinh Quadrature Update 2
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 Excel, Gauss-Kronrod, numerical integration, Quadrature, Romberg, Tanh-Sinh, UDF, VBA
4 Comments
Getting hard disk physical serial numbers
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
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
Newton Excel Bach, not (just) an Excel Blog 