Recent Comments
Author Archives: dougaj4
Charting a Mathematical Function with Defined Names
This post is a compilation of information from Stephen Bullen, Jan Karel Pieterse, and George Lungu. To quote JKP “When doing mathematics, wouldn’t it be nice if we could type an equation into a cell in Excel and immediately see … Continue reading
Posted in Arrays, Charts, Excel, Maths
Tagged Chart, defined names, Excel, Lissajous Figures, plot function
7 Comments
More on the Excel Evaluate function
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 Eval, EvalText, Evaluate, Excel, numerical integration, Substitutea, UDF, VBA
4 Comments
Interpolation Update
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 Excel, Interpolation, logarithmic interpolation, quadratic interpolation, UDF, VBA
4 Comments
ULS design of reinforced concrete to AS 3600 and ACI 318
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 ACI 318, AS 3600, Concrete, Reinforced Concrete, Section Analysis, Ultimate capacity
3 Comments
AS 3600 (Concrete Structures Code) Amendment 1
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
