Author Archives: dougaj4

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

ULS design of reinforced concrete to AS 3600 and ACI 318

Posted on 05/12/2010 by dougaj4

Following on from the previous post I have modified my RC Design Functions spreadsheet to incorporate the US ACI 318 design code requirements, as well as the recent revision to the Australian code, AS 3600.  The revised spreadsheet will be uploaded … Continue reading →

Posted in Beam Bending, Concrete, Newton | Tagged , , , , , | 3 Comments

AS 3600 (Concrete Structures Code) Amendment 1

Posted on 29/11/2010 by dougaj4

The first amendment to the current (2009) version of the Australian Standard for Concrete Structures (AS 3600) was recently released for free download.  SAI Global have not seen fit to notify purchasers of the standard of this amendment, but it … Continue reading →

Posted in Beam Bending, Concrete, Newton | Tagged , | Leave a comment

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