Daily Download 3: ULS design of reinforced concrete sections

Today’s downloads provide a spreadsheet providing Ultimate Limit State (ULS) analysis of reinforced or prestressed concrete sections, and an iterative method for finding the depth of the Neutral Axis in a circular reinforced concrete section.

 The ULS analysis spreadsheet is described at: ULS Analysis of Concrete Beams; now with added units it may be downloaded from:


Input and output are similar to the SLS function in Beam Design Functions, presented yesterday, with the added feature that the function is unit aware, and will accept input and output in a variety of accepted units:

UMom Function Input

The spreadsheet to find the neutral axis depth is described at: Calling a function as a variable – another example.  It may be downloaded from:


The function uses Brent’s Method to solve an equation by iteration, and is included the Circe function (part of RC Design Functions spreadsheet) presented yesterday:

Finding the depth of neutral axis using Brent’s Method

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

21 Responses to Daily Download 3: ULS design of reinforced concrete sections

  1. metroxx says:

    In ULS Design functions possible to define only Axial force? What about moment ?


    • dougaj4 says:

      As hadwao says, the input is the axial load and the tension face, and the output is the maximum bending moment allowed with that axial force. You can check the design moment capacity (phi.Mu) for any specified axial load, or you can use the interaction diagram to check that any combination of P* and M* is within the area bounded by the capacity line (the red line).


  2. hadwao says:

    for defined normal force max. bending moment is a result


  3. metroxx says:

    Is it planned in future to add check according to eurocode 2 in ULS design functions?
    Thank you


  4. metroxx says:

    Maybe it is too much, but when it is planned to add design according EC2?
    With regards …


  5. metroxx says:

    It looks like there no need too much changes in code to add EC2 check (principle the same?). Also in Australian codes there is phi to find design bending and axial load capacity? What is the reason, in EC2 no such thing.


    • dougaj4 says:

      There are some fairly major differences between the EC 2 approach and the Australian (and American) codes, but I am working on it.

      In EC2 the concrete and steel strengths are factored down (by different factors). In AS 3600 the calculation is done using the full strength, and the resulting bending capacity is then factored down, by a variable factor depending on the axial load.


    • dougaj4 says:

      See https://newtonexcelbach.wordpress.com/2013/07/10/concrete-uls-spreadsheet-update/ for new version including Eurocode 2. Just the rectangular stress block at the moment. The parabolic-rectangular block will follow eventually, but that will need more work.


  6. metroxx says:

    I have played with different shapes of section and founded that one of them didn’t want to calculate. Below you can find a link to the file:
    With regards …


  7. borja1980 says:

    hi. These days i have been consulting your spreadsheets. i have to contratulate you for your work. in the past, i have tried to make a routine to design concrete sections, with vba, but i never tought about using the excel array functions to automate the process. i would like to ask you a question: in the spreadsheet for uls concrete section design, the spreadsheet is setup in such a way that it takes the section data with the reinforcement areas, and then it return the ultimate bendin moment.
    would it be possible for the routine to work the other way, i mean, give like input data the design axial force and design bending moment, and that the routine returns the reinforcement areas¿
    that way, it would be possible to take data output of a fea software, like sap2000, or csibridge, and with your spreadsheet, and obtain the reinforcement in a matter of second.
    again, your spreasheets are impresive.


    • dougaj4 says:

      Thanks for the comments.
      I will have a look at calculating the minimum reinforcement area when I have time.

      The reason I haven’t done it before is because the way I work is to set up a table (or tables) of section details, including reinforcement, and plot graphs of section capacity and design bending moment and shear, and adjust the reinforcement so the capacity line is always outside the design action line. If there are a large number of different load cases with different axial loads I also sometimes plot all the design actions on a moment (or shear) – axial load interaction diagram, and again adjust the reinforcement manually.

      But the minimum reinforcement area will be an interesting exercise, and will also be useful, so I will have a look at it.


    • dougaj4 says:

      See: https://newtonexcelbach.wordpress.com/2016/05/21/rc-design-functions-update/

      At the moment the revised functions are in the RC Design Functions spreadsheet, that does SLS and ULS design for rectangular sections with two layers of reinforcement, but I will look at adding the same functionality to the beam design spreadsheets.


  8. Pingback: RC Design Functions update | 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