My Blogroll (bottom of the right-hand column) is badly in need of updating, but the link below has a list of 60 currently active Excel blogs and websites:
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 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: