Category Archives: Excel

New Links

Posted on 29/03/2025 by dougaj4

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

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

ULS Design Functions-biax 0.08

Posted on 16/03/2025 by dougaj4

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

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

RC Design Functions 9.09

Posted on 12/03/2025 by dougaj4

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

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

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