Category Archives: UDFs

Tanh-Sinh Quadrature V4.1

Posted on 16/03/2013 by dougaj4

The latest update to the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes is now available for download from: Tanh-Sinh. As usual, the download includes full open-source code and extensive documentation. Version 4.1 Release Notes  1.   Small but useful accuracy improvements have been … Continue reading →

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , | 1 Comment

what Microsoft think VBA is good for …

Posted on 06/03/2013 by dougaj4

The front page of Excel for Developers now has a link entitled VBA, which takes you to: VBA for Excel developers which has a link entitled When to use VBA and why which says: There are three principal reasons to consider VBA … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , | 9 Comments

Function to make a list of functions …

Posted on 11/02/2013 by dougaj4

… and other procedures. I wanted to make a list of all the VBA procedures in a workbook, and discovered that Excel doesn’t have a built-in way of doing that.  People have written code to work their way around that of course, … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 3 Comments

Precise Angles and XNumbers

Posted on 28/01/2013 by dougaj4

Further to comments by Georg under: The angle between two vectors, in 2D or 3D I have added four alternative ways of calculating the angle between two 3D vectors to the VectorFunc spreadsheet.  The new version can be downloaded from: http://interactiveds.com.au/software/VectorFunc.xlsb. … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

Charts and Charting

Posted on 27/01/2013 by dougaj4

I don’t do a lot on Excel charts because there are already a number of excellent blogs and sites that specialise in that area; notably: Peltier Tech Blog but after compiling my “Downloads by Category” page I found that I … Continue reading →

Posted in Charts, Excel, UDFs, VBA | Tagged , , , | Leave a comment