Tag Archives: UDF

RC Design Functions 9.02; DevLength function

The RC Design Functions spreadsheet has now been updated to Version 9.02, and is available for free download from: RC Design Functions9.zip Changes in the new version include: The new DevLength function returns reinforcement development length to AS 3600, AS … Continue reading

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

RC Design Functions 9.01; Shear for Eurocode 2 and BS 5400

The RC Design Functions spreadsheet has now been updated to Version 9.01, and is available for free download from: RC Design Functions9.zip The UMomPF function returns ultimate bending and axial load capacity to the Eurocode 2 and BS 5400 design … Continue reading

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

RC Design Functions 9.0

The RC Design Functions 9.0 spreadsheet is now available for free download from: RC Design Functions9.zip The main change is update of shear capacity calculations for the latest versions of the Australian codes; AS 3600 and AS 5100. Shear data … Continue reading

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

Rounding to significant figures

Edited 19th Feb 22, following comment from Larry Schuster Excel does not have a function to round numbers to a specified number of significant numbers, and (rather to my surprise) neither does Python. It is not too hard to write … Continue reading

Posted in Excel, Link to Python, Maths, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , , | 7 Comments

ConbeamU update

I recently discovered that the continuous beam function from the ConbeamU spreadsheet was giving incorrect results for cantilevers at the left hand end, if the cantilever had more than one segment and no point loads. The corrected version (Rel 4.16) … Continue reading

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