Concrete ULS spreadsheet update-2

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 shown below for a simple rectangular section with asymmetric reinforcement.

Umom Input

Umom Input

Umom Interaction Diagram

Umom Interaction Diagram

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

11 Responses to Concrete ULS spreadsheet update-2

  1. Pingback: Reinforced Concrete – ULS capacity under combined axial load and biaxial bending | Newton Excel Bach, not (just) an Excel Blog

  2. 3PlankWalker says:

    Not able to download the second update.


  3. Michael Perlini says:


    Not sure if you will see it, since it is so old, but there is a bug in the spreadsheet. When you flip the tension face to the top, it doesn’t pick up the yield strength of the bar correctly (you have to copy the value down in the table). You can check by flipping the tension face on the sample circle section, the moment capacity reduces significantly, when it should remain the same.

    Thanks for these spreadsheets, they come in very handy when I’m trying to squeeze the last bit out of a section!



  4. dougaj4 says:

    Thanks for letting me know Michael. All comments get reported when they are posted, so no problem commenting on old posts.
    Which version of the spreadsheet are you using (see the “about” sheet)? I ask because the download version is 2.04, which doesn’t have the problem, but my development version is 2.05, and has the problem you describe. I have fixed it, but I just need to check I haven’t un-fixed anything else.
    If you could e-mail a copy of your version to dougaj4 at gmail, that would be helpful.


  5. Pingback: ULS Design Functions – update for AS 3600 | Newton Excel Bach, not (just) an Excel Blog

  6. Sunny says:

    unable to download


    • dougaj4 says:

      Can you give more details?
      It downloads with no problem for me.


      • Sunny says:

        thank you for the reply,

        it says as below (in Chrome):
        The site ahead contains harmful programs
        Attackers on might attempt to trick you into installing programs that harm your browsing experience (for example, by changing your homepage or showing extra ads on sites you visit). Learn more
        To get Chrome’s highest level of security, turn on enhanced protection

        Not sure why it says the above .

        However in internet explorer,
        i could download and open it.

        Thank you for the prompt response.


        • dougaj4 says:

          OK, I’ll contact the web company tomorrow and check their security is OK.
          Thanks for letting me know.


          • dougaj4 says:

            I have copied the download file to Onedrive, and edited the link at the top of the post to download the file from there, which seems to work OK from Chrome. At the moment the link on this page is the only one I have edited though.


Leave a Reply

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

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