ULS Design Functions 2.13

I have uploaded another update to the ULS Design Functions spreadsheet with some new features and fixes.  The new version can be downloaded from:

ULS Design Functions.zip

The changes in the new version are:

  • Stress block type 3 will now use the Eurocode full parabolic stress block.
  • In previous versions entering a reinforcement yield stress of 600 MPa resulted in a divide by zero error. This has now been fixed.
  • Using the AS 3600 rectangular stress block, there has been a minor correction to the calculation of section capacity when the neutral axis is at or beyond the “tension” face, so that linear interpolation is used, as required by the code.

The Eurocode parabolic stress block may be used with AS 3600 and AS 5100, as well as Eurocode 2:

Interaction diagrams to AS 3600 are shown below for the rectangular stress block (including 10% reduction in concrete stress for a non-rectangular section, the Eurocode parabolic-rectangular stress block, and the full parabolic stress block:

This entry was posted in Concrete, Excel, Newton, UDFs, VBA and tagged , , , , , , , , . Bookmark the permalink.

5 Responses to ULS Design Functions 2.13

  1. Chatree L. says:

    Can I use this spreadsheet for Ultra-High Performance Concrete (UHPC)? I want to determine the ULS section capacity for UHPC concrete with fcu of 200 MPa.


    • dougaj4 says:

      No, it’s not really applicable to UHPC. It ignores all concrete in tension, which (as far as I know) is not what is done for UHPC design. Also the stress block parameters used for 100 MPa concrete are probably not appropriate for UHPC.


      • Chartree L. says:

        Hello dougaj4, thanks for your comments. As you have seen above description in “The changes in the new version are:”. The author has said that “In previous versions entering a concrete yield stress of 600 MPa resulted in a divide by zero error. This has now been fixed”. Then, I think that this spreadsheet may be used for concrete up to 600 MPa like UHPC. I am now learning how to design such UHPC in ULS since nowaday it is lack of design knowledge. Does anyone has a guideline for me?


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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.