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:
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.
Newton Excel Bach, not (just) an Excel Blog 
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.
LikeLike
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)
LikeLike
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.
LikeLike
I am still working on this.
Can you provide more details of the Type Mismatch error?
Where and when does it occur?
LikeLike
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.
LikeLike
In addition, Depth_NA has Error 2015 on value.
LikeLike
Tested in English localization. Nothing different.
LikeLike
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.
LikeLike
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.
LikeLike
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.
LikeLike
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.
LikeLike
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.
LikeLike
If you send me a copy of your spreadsheet with zero entered as the NA angle I will have a look.
LikeLike