Tag Archives: VBA

3DFrame-NLGeom

Posted on 13/02/2025 by dougaj4

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 … Continue reading →

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

RC Design Functions 9.07

Posted on 08/02/2025 by dougaj4

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 … Continue reading →

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

Biaxial bending update 2

Posted on 13/12/2024 by dougaj4

It was recently reported that the VBA version of the biaxial bending spreadsheet was returning incorrect results when the neutral axis was exactly parallel to the Y axis. This problem has now been fixed, and the revised spreadsheet can be … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | 5 Comments

Regular Expressions in Excel

Posted on 25/05/2024 by dougaj4

I recently discovered that Microsoft are working on Excel functions to work with Regular Expressions. A beta version is currently available to those on the “insider” program, but this functionality has long been available through VBA, and can also be … Continue reading →

Posted in Excel, Link to Python, PyXLL, UDFs, VBA | Tagged , , , , , , | Leave a comment

RC Design Functions 9.06; Momcurve functions update

Posted on 30/03/2024 by dougaj4

The RC Design Functions spreadsheet has now been updated to Version 9.06, and is available for free download from: RC Design Functions9.zip The new version fixes a problem with the MomcurveTS function, which was returning an error for any input … Continue reading →

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