Tag Archives: VBA

ULS Design Functions 2.16

Posted on 25/02/2023 by dougaj4

The ULS Design Spreadsheet has now been updated to Version 2.16, which can be downloaded from: ULS Design Functions The main new feature is the option to design for prestress loads applied to circular tanks. Due to axi-symmetric effects, when … Continue reading →

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

Using ConbeamU

Posted on 20/01/2023 by dougaj4

This post was prompted by a thread at Eng-Tips: https://www.eng-tips.com/threads/deflection-equations.501339/#post-8860838 The beam analysis functions in the ConbeamU spreadsheet allow for the use of any SI units, or any non-SI units found in the long list included with the spreadsheet. I … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , , , | 12 Comments

RC Design Functions 9.03; compression strut angle adjustment

Posted on 11/11/2022 by dougaj4

The RC Design Functions spreadsheet has now been updated to Version 9.03, and is available for free download from: RC Design Functions9.zip The new version includes a number of corrections to the calculation of beam shear and torsion capacity to … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | 2 Comments

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