Recent Comments
Elastic Biaxial Bend… on Biaxial bending update 
Bill Harvey on Floating Point Precision … Floating Point Preci… on When does 35 not equal 35… 
dougaj4 on mpmath for Excel dougaj4 on mpmath for Excel 
Kapt Blasto on mpmath for Excel 
mktisis on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness… mktisis on 3D Frame with zero stiffness… 
th3budd on Time in hours and minutes betw… dougaj4 on Moving Load Spreadsheet… 
Ario on Moving Load Spreadsheet… dougaj4 on About Newton Excel Bach 
David Graves on About Newton Excel Bach
Tag Archives: VBA
Units4Excel Update
As discussed here, I have updated the Units4Excel spreadsheet, with the list of non-SI units updated from the latest Wikipedia table. The EvalU user defined function (UDF) has also been modified with three output options, as shown in the screen-shot … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Evaluate text functions, Excel, UDFs, Unit aware calculations, VBA
5 Comments
More on RC design of circular sections
Following the last post on this topic (Reinforced Concrete Design for Circular Sections to Eurocode 2) I have added provision for parabolic-linear concrete stress blocks to the ULS Design Functions spreadsheet. The Circu function in the RC Design Functions spreadsheet has … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged ACI 318, AS 3600, Circular reinforced concrete sections, Comparison of codes, Eurocode 2, Excel, UDF, ULS Design Functions, VBA
4 Comments
Extracting text from an Internet table
For use in my Units spreadsheet (Units4Excel) I want to extract the unit conversion values from the comprehensive Wikipedia unit conversion table. On Wikipedia the table looks like this: and when copied and pasted as Unicode text into Excel, like … Continue reading
Posted in Excel, Newton, UDFs, VBA
Tagged Excel, Extract from text, UDFs, Unit conversion, Units, Units4Excel, VBA, Wikipedia
3 Comments
Tanh-Sinh Quadrature update
Following some comments here Graeme Dennes and I have modified the start-up code for the Tanh-Sinh Quadrature spreadsheet to avoid problems opening the file when first downloaded, or copied to a new computer. The new file is located (as before) … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, Tanh-Sinh Quadrature, UDFs, VBA
Leave a comment
Newton-Raphson and Brent’s Method – Solver examples
I recently discovered the Computing Skillset site (via open-struct-engineer), which has good information on the basis and use of the Newton-Raphson method: The Newton Raphson method explained, details, pictures, python code Highly instructive examples for the Newton Raphson method I … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Brents method, Computing Skillset, Excel, Newton Raphson Method, UDF, VBA
Leave a comment
