Tag Archives: UDF

Using RC Design Functions 4 – Umom and new MaxAx function

Posted on 21/07/2013 by dougaj4

Previous post in this series. Download latest version of RC Design Functions6. Previous posts in this series have looked at elastic design functions.  We now move on to functions for ultimate limit state (ULS) analysis of reinforced concrete sections: UMom: … Continue reading →

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

Concrete ULS spreadsheet update-2

Posted on 17/07/2013 by dougaj4

The concrete ULS design spreadsheet last posted at: Concrete ULS spreadsheet update has been updated to fix a problem encountered with non-symmetrical reinforcement using the Eurocode 2 rectangular stress block. Download from ULS Design Functions. Typical input and output interaction diagram are … Continue reading →

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

Concrete ULS spreadsheet update

Posted on 10/07/2013 by dougaj4

The ULS Design Functions spreadsheet has been updated with the addition of provision for the Eurocode 2 rectangular stress block.  The new spreadsheet can be downloaded from:  ULS Design Functions.zip (including full open-source code). For more details see: ULS Analysis … Continue reading →

Posted in Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 10 Comments

Using Index() as an array function

Posted on 23/06/2013 by dougaj4

As promised, this post looks at using the Excel built in Index() function to operate on arrays; it also provides a VBA user defined function (UDF), VBIndex, which simplifies working with arrays within VBA, and also provides improved functionality when … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , | 3 Comments

Using RC Design Functions – 3

Posted on 08/06/2013 by dougaj4

In the previous post in this series I looked at the results available from the EStress function in the RC Design Functions spreadsheet.  Three associated functions are: EstressCap PLCurve TStiff EStressCap finds the maximum bending moment for a specified axial load, … Continue reading →

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