Author Archives: dougaj4

3D Frame Update

Following a comment here I have updated the code for the 3DFrame spreadsheet to calculate shear deflections correctly for sections with a different shear area for each transverse principal axis. The updated files can be downloaded from: 3DFrame.zip A note … Continue reading

Posted in Excel, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , | Leave a comment

Elastic Biaxial Bending

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

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

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

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