Tag Archives: UDF

ULS Design Functions update

Posted on May 23, 2021 by dougaj4

The ULS Design Functions spreadsheet has been updated with further changes related to the new Australian Standard for concrete structures; AS 3600-2018, and with some other fixes.  The new version can be downloaded from: ULS Design Functions.zip The changes in … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , | Leave a comment

More on RC design of circular sections

Posted on December 23, 2020 by dougaj4

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 , , , , , , , , | 4 Comments

Newton-Raphson and Brent’s Method – Solver examples

Posted on November 8, 2020 by dougaj4

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 , , , , , | Leave a comment

Using Excel with Python and ctypes

Posted on October 5, 2020 by dougaj4

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 , , , , , | Leave a comment

Spherical Geometry and Vincenty’s Formulae

Posted on September 27, 2020 by dougaj4

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 , , , , , , | Leave a comment