New Links

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:

60 Best Excel Blogs and Websites in 2025

Those at the top of the list include several long running but still active sites, as well as several that I had not heard of before.

And scrolling down to number 26 we find none other than Newton Excel Bach 🙂

Posted in Bach, Computing - general, Excel, Newton | Tagged , , | Leave a comment

ULS Design Functions-biax 0.08

I have just uploaded a new version ULS Design Functions-biax, which can be downloaded (together with the uni-axial version) from:

ULS Design Functions.zip

The main changes are added code parameters from Eurocode 2:

Detailed output for a specified load and neutral axis angle is as in previous versions:

There are also functions that will generate various interaction diagrams:

For more details and examples see: Biaxial Bending Update.

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , , | Leave a comment

RC Design Functions 9.09

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:

RC Design Functions9.zip

See: RC Design Functions 9.07 for more details of recent revisions.

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | Leave a comment

3DFrame-NLGeom

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:

3DFrame.zip

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.

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, VBA | Tagged , , , , , | 3 Comments

RC Design Functions 9.07

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:

RC Design Functions9.zip

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:

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 1 Comment