Tag Archives: Excel

New Excel Engineering Blog

Posted on 26/11/2010 by dougaj4

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

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

Tool-tip tip

Posted on 10/11/2010 by dougaj4

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 →

Posted in Excel, 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