Recent Comments
Tag Archives: Excel
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
New Excel Engineering Blog
I just found Excel Unusual, which has been going since September this year. Here’s what the Author says: “Finding engineering work quite un-challenging lately I decided to start this blog in which to share cool ways of solving engineering problems or … Continue reading
Posted in Animation, Excel, Newton
Tagged 3D graphics, animation, engineering, Excel, science
13 Comments
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
