Category Archives: Concrete

Equivalent Stress Blocks

Posted on 19/10/2011 by dougaj4

Previous posts (e.g. Stress blocks in AS 3600) have presented Excel User Defined Functions (UDFs) that determine the ultimate bending strength of a reinforced concrete section with the use of a rectangular concrete stress block, with depth and stress factors … Continue reading →

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

Using Beam Design Functions

Posted on 07/09/2011 by dougaj4

“Beam Design Functions” is an Excel spreadsheet providing a User Defined Function (UDF) that will calculate the stresses, strains, forces and moments in a reinforced or prestressed concrete section subject to any specified bending moment and axial load, using an … Continue reading →

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

Using LatPilePY

Posted on 09/07/2011 by dougaj4

LatPilePY is a User Defined Function (UDF) used to analyse the deflections and load actions in laterally loaded piles.  It was presented in this post: LatPilePY.  In response to an e-mail request, this post will give step by step instructions for … Continue reading →

Posted in Arrays, Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , , | Leave a comment

Non linear regression – 2; ALGLIB functions

Posted on 05/03/2011 by dougaj4

The previous post looked at using the Excel Solver to fit a non-linear equation to a given set of data, using the least squares method.  This approach is reasonably convenient and straightforward, but it has a number of disadvantages: The … Continue reading →

Posted in AlgLib, Concrete, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 8 Comments

Non linear regression – 1

Posted on 01/03/2011 by dougaj4

Recent posts have described how to fit linear equations (or equations that can be made linear) to a set of data, using the Excel Linest functions, or User Defined Functions (UDF’s) linking to the ALGLIB library (see Using LINEST for non-linear … Continue reading →

Posted in AlgLib, Concrete, Excel, Maths, Newton | Tagged , , , | 6 Comments