Recent Comments
Tag Archives: VBA
Solving cubic equations – background and timing
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 cubic equations, Excel, Numba, Numpy, Polynomials, Pyhon, PyXLL, Quartic equations, UDFs, VBA
Leave a comment
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 array functions, AS 3600, AS 5100, BS 5400, Devlength, Eurocode 2, Excel, RC Design Functions, UDF, UMom, VBA
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 BS 5400, Eurocode 2, Excel, RC Design Functions, shear capacity, UDF, UMomPF, VBA
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 AS 3600, AS 5100.5, Combined Shear and Torsion, Excel, Reinforced Design Functions, shear capacity, UDF, UMom, VBA
Leave a comment
Removing Add-ins
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 Add-in problems, Excel, Link to Python, Regedit, Remove add-ins, VBA, Windows registry
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 