Tag Archives: UDF

ULS design of circular reinforced concrete columns

The RC Design Functions spreadsheet has been updated (to Version 8.04) with the addition of a CircU function for ULS design of circular reinforced concrete sections under combined bending and axial load.  The new version, including full open-source code, may … Continue reading

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

ULS Design Functions – update for AS 3600

The ULS Design Functions spreadsheet (last posted here) has been updated to the new Australian Standard for concrete structures; AS 3600-2018.  The new version can be downloaded from: ULS Design Functions.zip Note that the biaxial version included in the download … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , | 2 Comments

RC Design Functions 8_03

The RC Design Functions 8_03 spreadsheet is now available for free download from: RC Design Functions8.zip The main changes are: The NA layer check has been corrected for compression steel in tension The new AS 3600 crack width and curvature … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , | 9 Comments

Numerical Integration; Tanh-Sinh Quadrature v. 4.42

Back to Newton and Excel. I recently received a new update to the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes, which may be downloaded from: Tanh_Sinh Quadrature. From the Readme: The Tanh-Sinh quadrature workbook has been enhanced as follows: The Tanh-Sinh … Continue reading

Posted in Charts, Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , , | Leave a comment

Numerical Integration; Tanh-Sinh Quadrature v. 4.4

Update 27 Nov 2018: Version 4.41 now available from the link below, with minor modifications for compatibility with Excel 2007. I recently received a new version (4.4) of the numerical integration spreadsheet by Graeme Dennes which is now available for … Continue reading

Posted in Charts, Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , , | 9 Comments

AS 3600 and RC Design Functions 8.01

The updated RC Design Functions spreadsheet (presented here) included an updated UMom function to find the ultimate strength of a rectangular section under combined bending and axial load; but I omitted to include the revisions to the alpha2 and Gamma … Continue reading

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

Arcs and arc-splines

I have added two user defined functions (UDFs) to the IP2 spreadsheet to generate coordinates for a single  arc, or a series of arcs connected (if necessary) by straight lines.  The new version may be downloaded from: IP2.zip As an example … Continue reading

Posted in Animation, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA | Tagged , , , , , , | 1 Comment