ULS Design Functions update

The ULS Design Functions spreadsheet has been updated with further changes related to the new Australian Standard for concrete structures; AS 3600-2018, and with some other fixes.  The new version can be downloaded from:

ULS Design Functions.zip

The changes in the new version are:

  • The code input now has provision for an additional reduction factor, applied to the concrete stress, for use where the AS 3600 rectangular stress block is being used with a section where the width of the compression zone reduces towards the compression face. The code requires a 5% reduction (factor = 0.95) for circular sections, or a 10% reduction (factor = 0.9) for any other section with reducing width, such as the rotated square section shown below.
  • The maximum axial load calculation for Eurocode 2 with non-rectangular stress blocks has been modified to correctly account for steel in compression.
  • The routine for finding the depth of the Neutral Axis has been modified to improve performance in sections with multiple layers of reinforcement.
This entry was posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA and tagged , , , , , , , . Bookmark the permalink.

13 Responses to ULS Design Functions update

  1. SHAMIL NURI says:

    Hi,

    While opening the excel sheet and after activating “enable editing” the sheet works improperly and some data is missing or input/output data can not be reachable. I cannot solve this. Please help me with this problem.

    Like

    • dougaj4 says:

      I’m happy to help if you provide some details, including:
      Computer type and OS version
      Excel version
      Exactly what is missing or “not reachable”
      Please also send a copy of your file to my gmail address (dougaj4)

      Like

    • Ata says:

      I’m having the same problems. I get #Value errors. I also get a type mismatch error from VBA on the non-biaxial excel file.

      Like

      • dougaj4 says:

        I am still working on this.
        Can you provide more details of the Type Mismatch error?
        Where and when does it occur?

        Like

        • Benata says:

          The error is Run-time error ’13’ and type mismatch shows line is:
          “If TFace = 1 Then YNA = SectDepth – Depth_NA Else YNA = Depth_NA”
          “YNA = SectDepth – Depth_NA Else” is the highlighted code snippet.
          Works without error when I comment the entire line out. However the formulas fail.
          Result is “#VALUE!” errors everywhere. No eccentricity, no depth of neutral axis. Even with the section you have provided as an example. Also some more info for office I use. It’s Localized Turkish Office 2016, genuine license.

          P.S: I’ve seen your excel file work on other websites. Great piece of work.

          Like

          • Benata says:

            In addition, Depth_NA has Error 2015 on value.

            Like

          • Benata says:

            Tested in English localization. Nothing different.

            Like

          • dougaj4 says:

            Thanks for the details.
            Both you and Shamil Nuri are using the Turkish Language version, so it may be something hidden in there that isn’t connected to the Office language settings.

            The VBA error you are getting is in the routine that re-draws the section, it doesn’t affect the calculation. The VBA has an error because the NA depth on the spreadsheet is an error value. I have now uploaded an updated version that will complete if there is an error. I also changed the name of the cell from Depth_NA to DepthNA, in case the underscore is a problem in the Turkish version (but I doubt if that will make any difference).

            If you can send a copy of your spreadsheet to my GMail account (dougaj4 at gmail) I will have another look, but at the moment I have no idea what the problem is.

            It might also be worth asking a general problem on a Turkish language forum, to check if there are any known problems with Excel VBA in the Turkish version.

            Like

          • dougaj4 says:

            Also after reading the thread here:
            https://social.msdn.microsoft.com/Forums/en-US/ac672d85-3a88-488d-9687-4d0b71a9b357/cellquotfilenamequot-function-gives-value-errors-with-turkish-language
            I have changed the format of the cells with the units from “number” to “string”
            The revised file is copied to the download zip file.

            Like

  2. SHAMIL NURI says:

    Thank you for your reply,
    I use HP notebook, Windows 10 Pro, Office 365 Excel version.

    I’ve sent to your gmail address (dougaj4@gmail.com) ss of error windows.

    Like

    • dougaj4 says:

      Thanks for the details.
      The problem is the error value in the NA Angle cell (Cell E6 on the Input sheet).
      This is a user input, but it is also changed by the macro when you click the Adjust NA Angle button, so that may be where the error came from from.
      Just enter zero, then click the adjust NA button, and it should find the correct angle so that the resultant reaction moments have the same direction as the resultant of the input moments.

      Like

      • SHAMIL NURI says:

        Sir, unfortunately the problem is not solved by the way you suggested. I’ve tried on another notebook with MS Office 2010, even there I’m getting the same error.

        Like

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.