Tag Archives: VBA

RC Design Functions 9.02; DevLength function

Posted on September 13, 2022 by dougaj4

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

Posted on August 28, 2022 by dougaj4

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

Posted on August 10, 2022 by dougaj4

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

Removing Add-ins

Posted on June 5, 2022 by dougaj4

Recently I had problems with an Excel Add-in that was still trying to run, and generating error messages, even after being removed from the add-in list and uninstalled. After much searching and trying suggested methods that didn’t work, I finally … Continue reading →

Posted in Computing - general, Excel, Link to dll, Link to Python, VBA | Tagged , , , , , , | Leave a comment

VBA procedures for the Numerical Analysis of Tabular Functions

Posted on March 12, 2022 by dougaj4

Long time on-line friend Alfred Vachris has recently been converting Fortran code developed through his working career into VBA: I had the opportunity to work at Grumman while going to Graduate School and they gave me a part-time job as … Continue reading →

Posted in Coordinate Geometry, Curve fitting, Excel, Fortran, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 1 Comment