Author Archives: dougaj4

Elastic Biaxial Bending

Posted on April 11, 2021 by dougaj4

Spreadsheets performing Ultimate Limit State analysis with biaxial moments have been presented previously, most recently here: Biaxial bending update I have now modified the Beam Design Functions spreadsheet to carry out a biaxial moment analysis with linear elastic material properties. … Continue reading →

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

Floating Point Precision Problems

Posted on April 5, 2021 by dougaj4

A question on Quora : prompted me to look at how these numbers are handled in Excel, in VBA called from Excel, and in Python called from Excel via pyxll. The results are shown in the screenshot below: Column A … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , , , | 1 Comment

Raining on the Rock

Posted on March 25, 2021 by dougaj4

Raining on the Rock is the name of a song by John Williamson; released in 1987, it was recently re-released with a new video: It is also what happened at Uluru this week:

Posted in Bach | Tagged , , | Leave a comment

CSpline and Malware

Posted on March 13, 2021 by dougaj4

I was recently informed that the Malwarebyte program was raising a warning for the CSpline2 download. On checking I found that the spreadsheet had a VBA module called frmPickwb which was not my code. The file has now been updated, … Continue reading →

Posted in Computing - general, Curve fitting, UDFs, VBA | Tagged , , | Leave a comment

Lambda and VBA

Posted on February 28, 2021 by dougaj4

The new Excel Lambda function (see here for more details and links) is currently only available to those signed up to the Beta Preview version of Excel 365, but is has been favourably reviewed by almost all of those who … Continue reading →

Posted in Computing - general, Excel, UDFs, VBA | Tagged , , , , | Leave a comment