Category Archives: VBA

More on the Excel Evaluate function

Posted on 14/12/2010 by dougaj4

Previous posts have presented the Eval() User Defined Function, using the Evaluate function in VBA to evaluate mathematical functions displayed as text (Evaluate Function, Evaluate Function – Update).  It was recently pointed out by Jeff Weir that the Evaluate function has its origins … Continue reading →

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

Interpolation Update

Posted on 07/12/2010 by dougaj4

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

Maximum distance between two points

Posted on 27/11/2010 by dougaj4

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 →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 1 Comment

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