Category Archives: UDFs

ULS design of reinforced concrete, AS, ACI and European codes

Posted on 21/12/2010 by dougaj4

The previous post in this series compared the results of current and previous Australian Standards, and the ACI 318 code, for the ultimate bending capacity of a rectangular reinforced concrete section, subject to combined bending and axial load.  I have now extended … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs | Tagged , , , , , , , , | 1 Comment

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