Tag Archives: UDF

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

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

Faster Integration with the Tanh-Sinh Method

Posted on 10/10/2010 by dougaj4

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

Working with FEM data and using the dictionary object

Posted on 26/09/2010 by dougaj4

This post features an Excel User Defined Function (UDF) to count the number of different element types (beams, plates, bricks and links) and the number of node restraints at each end of listed beams from a finite element model.  The … Continue reading →

Posted in Arrays, Excel, Finite Element Analysis, Newton, UDFs, VBA | Tagged , , , , , | 5 Comments