Category Archives: VBA

Solving cubic equations – background and timing

Posted on 25/10/2022 by dougaj4

For more information on the polynomial functions, including quartic and higher order solvers, see: Solving Quadratic, Cubic, Quartic and higher order equations; examples Re-reading the Wikipedia article on solving cubic equations, I noticed that the trigonometrical solution for finding 3 real … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , , , , , | Leave a comment

RC Design Functions 9.02; DevLength function

Posted on 13/09/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 28/08/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 10/08/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

Microsoft blocking VBA in downloaded files (or do they?)

Posted on 12/07/2022 by dougaj4

Microsoft announced earlier this year that they would be automatically blocking macros in downloaded Office files (as a security measure), then recently they said they wouldn’t, then yesterday they said they would, but not right now. For more details, plus … Continue reading →

Posted in Computing - general, Excel, UDFs, VBA | Tagged , , | 1 Comment