Author Archives: dougaj4

Using Python optional arguments from Excel with pyxll

Posted on January 14, 2021 by dougaj4

Python functions allow optional arguments to be specified by allocating a default value to each optional argument. The pyxll add-in allows Python functions called from Excel to work in the same way, so any argument with a default value may … Continue reading →

Posted in Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , , | 1 Comment

Units4Excel Update

Posted on December 29, 2020 by dougaj4

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

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

More Open Source FEA Code Links

Posted on December 19, 2020 by dougaj4

The book Nonlinear Finite Element Analysis of Solids and Structures 2nd Edition has an associated python code package called pyFEM, but a search for this code finds several others with the same or similar names: The pyFEM sites associated with the … Continue reading →

Posted in Finite Element Analysis, Frame Analysis, Link to Python, Newton | Tagged , , , | Leave a comment

Lost Sydney

Posted on December 17, 2020 by dougaj4

Lost Sydney is a Facebook site with 100’s of photographs of Sydney, some dating back well over 100 years. This is Sydney’s story. Lost Sydney is not just about demolished buildings, it’s also about photos of Sydney’s past. Lost Sydney

Posted in Arch structures, Bach, Historic Bridges, Newton | Tagged , , | Leave a comment