Reinforced Concrete Section Analysis – 6; Ultimate Limit State

The previous post in this series included Excel User Defined Functions using closed form solutions to find the ultimate bending and axial load capacity of reinforced or prestressed concrete sections of any complex shape defined by rectangular or horizontal layers.  The paper ultimate-moment-capacity1  provides the derivation of the solutions used in these functions.  An extract from the paper is shown below.

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

3 Responses to Reinforced Concrete Section Analysis – 6; Ultimate Limit State

  1. Radu says:

    Hello Doug,
    sorry if you find this inappropriate; where would you suggest someone like me (structural engineer with no programming background) should start learning VBA in order to write some custom Excel functions?
    Thanks a lot,


  2. dougaj4 says:

    Hi Radu

    Well you could start here🙂

    The basics are covered here:
    and following posts cover a lot of the refinements. If you search this blog for UDF and/or VBA you should find a lot of useful information.

    Books I can recommend are Excel Power Programming by John Walkenbach and Excel for Engineers and Scientists by Joseph Bilo.

    Both are very readable, and don’t assume a huge amount of programming experience.

    If I had to pick one web site for reference it would be Chip Pearson’s site:

    In summary I’d say the best way to start was:

    Pick up the basics of how to get data from the spreadsheet into VBA and back again.

    Learn the basics of Basic; data types, control statements, and arrays etc.

    Start experimenting with some UDFs and recorded macros.

    For general questions you’ll get a better response at one of the discussion groups, but for any questions on anything posted here, feel free to ask here.

    Hope that helps



  3. Pingback: Units for Excel 4: Scripting dictionaries | Newton Excel Bach, not (just) an Excel Blog

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 )

Google+ photo

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

Connecting to %s