Category Archives: UDFs

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

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

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

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

3DFrame-py-comb

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: 3DFrame-py.zip See Installing 3DFrame-py for installation details, and … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7, UDFs | Tagged , , , , , , , , , , | 1 Comment

3DFrame-py rel. 0.40

A new version of 3DFrame-py has been released and can be downloaded from: 3DFrame-py.zip 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 … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7, UDFs | Tagged , , , , , , , , , | 5 Comments

Scipy update and Linalgfuncs speed check

I have updated the Scipy code to remove repeated loading of the Numpy code, and to fix a number of other warnings from the pyxll log file. I have also updated the speed check of the various linear algebra solvers, … Continue reading

Posted in Arrays, Excel, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | Leave a comment