Reinforced Concrete Section Analysis – 5; Ultimate Limit State

Previous posts in this series have looked at the analysis of beams where the steel stress is within the elastic range, and the concrete stress is sufficiently low that the assumption of linear elastic behaviour in compression is a reasonable approximation.  I now move on to analysis for the ultimate limit state, where some or all of the steel is past its yield stress, and the concrete compression zone may be analysed as having a constant stress, close to its failure stress.

The file ULS Design Functions.zip contains User Defined Functions (UDF’s) that will find the ultimate bending capacity of any reinforced or prestressed concrete section (defined by rectangular or trapezoidal layers) with any number of layers of reinforcement, when subject to a specified axial load.  As for the elastic design functions, the analysis uses a closed form solution, rather than an iterative procedure.  The current version follows the Australian Standards AS 3600 or AS 5100.  Other codes will be added to future versions. Details of the procedure will be given in later posts.

Screen shots:

Input, circular section

Input, circular section

Output, circular section

Output, circular section

Interaction diagram

Interaction diagram

Advertisements
This entry was posted in Beam Bending, Excel, UDFs and tagged , , , , , , , . Bookmark the permalink.

5 Responses to Reinforced Concrete Section Analysis – 5; Ultimate Limit State

  1. Pingback: Reinforced Concrete Section Analysis - 6; Ultimate Limit State « Newton Excel Bach, not (just) an Excel Blog

  2. Very neat spreadsheet… Thank you for releasing the code under GPL. Nice to see another Structural with a CopyLeft soul… I’ve added a slenderness check to NZS 3101, and am in the process of implementing the NZ code as Code = 3 (No EN here! lol). Quite impressed with your work; Well done!

    Let me know if you want me to toss the finished result back your way. Happy to oblige.

    Cheers,

    YS

    Like

  3. dougaj4 says:

    YoungStructural – Thanks for the comments. I’d certainly be interested in seeing your implementation of the NZ code. You can either post a link here or email me at Gmail (DougAJ4).

    Also watch out for a new spreadsheet which I’ll be posting in the next few days with cut-down versions of both the elastic and ULS programs to use with rectangular sections with two layers of reinforcement. These have simplified data input, and are more convenient when checking multiple sections on rectangular members.

    Doug

    Like

  4. Pingback: Reinforced Concrete Section Analysis – with prestress « Newton Excel Bach, not (just) an Excel Blog

  5. Pingback: ULS Analysis of Concrete Beams; now with added units | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s