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: UDF
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
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
Using Excel with Python and ctypes
The Strand7 API provides an interface between the Strand7 Finite Element Analysis program and external software. It works with many different languages, including Python, which uses ctypes to transfer data to and from the API functions. It is essential that … Continue reading
Posted in Beam Bending, Excel, Link to dll, Link to Python, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged ctypes, Excel, Python, PyXLL, Strand7 API, UDF
Leave a comment
Spherical Geometry and Vincenty’s Formulae
Wikipedia has detailed articles on: Spherical Geometry and Vincenty’s Formulae (for geometric calculations on an ellipsoid). The spreadsheet Vincenty.zip uses those resources to perform the following calculations, using both on-sheet calculations and VBA user-defined functions (UDF’s): Calculation of distance and … Continue reading
Posted in Computing - general, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged ellipsoid area, ellipsoid distance, Excel, Spherical Geometry, UDF, VBA, Vincenty's Formulae
Leave a comment
Concrete Stress Blocks
Back in 2010 and 2011 posts here looked at a comparison of alternative stress blocks in the then new AS 3600, and a procedure for calculating parameters for a rectangular stress block exactly equivalent to the Eurocode 2 parabolic-rectangular stress … Continue reading
