The RC Design Functions spreadsheet has had two further recent revisions:
9.08 21-Feb-25 CircUPF EC2 parameters corrected to allow variation of reduction factors for steel and rectangular stress block factors.
9.09 6-Mar-25 Calculation of depth NA amended in UMomPF for NA outside section
The revised file can be downloaded from:
See: RC Design Functions 9.07 for more details of recent revisions.
The VBA version of the 3DFrame spreadsheet has now been updated to allow geometric non-linear effects to be included. The new version can be downloaded from:
For more details of the VBA 3DFrame see 3DFrame update, and for the Python version, which also includes non-linear materials analysis and combination of multiple load cases see 3DFrame-py-comb.
The input for the new 3DFrame-NLGeom spreadsheet allows for setting the maximum number of load iterations and the relative displacement tolerance.
The output format is the same as previous VBA versions, except the number of iterations and maximum displacement error are now shown.
In the screenshots below bending moment and deflection results for a portal frame with very high vertical and horizontal loads are compared with Strand7 results, also allowing for geometric non-linear effects, with linear elastic material properties. The results are in very close agreement for all cases.
The UMomPF function performs ultimate load analysis for codes using the partial factor approach, including Eurocode 2. The input for Eurocode 2 includes an optional table allowing alternative values to be input for various parameters, including stress reduction factors, and stress block definition values. It was recently pointed out that some of these parameters were having no effect on the results. This has now been fixed, and the revised file has been uploaded to:
The example below shows results for a section with axial load close to the balance load, first with default Eurocode 2 parameters (click on any image for full-size view):
Then with the reduction factors adjusted to be equivalent to the AS 3600 value for sections in compression, and the stress block set to rectangular, with stress and depth equal to the AS 3600 values for 50 MPa concrete:
The 3DFrame-py spreadsheet has now been updated with provisions for saving multiple load cases and the associated results, and analysis with factored combinations of multiple load cases.
The new files can be downloaded from:
See Installing 3DFrame-py for installation details, and details of other Python modules required. Also see Python and pyxll for details of the required pyxll package, including a coupon code for a 10% discount.
Load cases are entered and saved on the Input 2 sheet:
Factored load combinations can then be defined on the Combinations sheet:
The analysis is then run on the Output sheet:
This sheet has the following new options:
Deflections and bending moments are shown below for a portal frame under very high vertical and transverse loads, including geometric non-linear results. Results are very close to Strand7 results, which are also plotted in the graphs, and display as the same line:
Many of the download links here in older posts use the format http:// rather than https://, and these links now don’t work in Windows. If you find a non-working download link, here is what you can do:
 | Z on Downloads |
| py_xlCBA – Sup… on py_xlCBA update | |
 | dougaj4 on Downloads |
| Z on Downloads |
| py_xlCBA update | Ne… on Calling PyCBA from Excel | |
| Z on Reinforced concrete elastic an… |
| dougaj4 on Reinforced concrete elastic an… |
 | khoitsma on Continuous beam animations wit… |
| Z on Reinforced concrete elastic an… |
| dougaj4 on Reinforced concrete elastic an… |
| dougaj4 on Reinforced concrete elastic an… |
| Z on Reinforced concrete elastic an… |
| Z on Reinforced concrete elastic an… |
| dougaj4 on Downloads |
| dougaj4 on Installing Adobe Reader non-DC… |
Newton Excel Bach, not (just) an Excel Blog 