Author Archives: dougaj4

Chris Hadfield reviews 2016

Posted on 01/01/2017 by dougaj4

Canadian Astronaut, Commander Chris Hadfield, reminds us of all the great many positives that happened in 2016. : It’s easy to forget that this year saw a great many positives

Posted in Bach, Newton | Tagged | Leave a comment

Transferring and converting strings in Excel and Python

Posted on 26/12/2016 by dougaj4

The load table for the 3D Frame spreadsheet has a column listing the global axis for each load as text (X, Y, or Z).  In the VBA version the table is converted to a variant array, and the axes are handled … Continue reading →

Posted in Excel, Link to Python, Newton, NumPy and SciPy, VBA | Tagged , , , , , , , , | Leave a comment

Brent’s Method and a daft engineer’s blog

Posted on 23/12/2016 by dougaj4

Browsing links on Brent’s Method I found: Daft Engineer – Numerical Methods and Excel* which is well worth a look (plenty of stuff on statistics and Python, with the odd dash of Excel).  The link has VBA code for a … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , | 3 Comments

The Lime in the Coconut …

Posted on 14/12/2016 by dougaj4

… is a song by Harry Nilsson, released in 1972: but somehow, the BBC managed to record three gorillas singing the same song in 1971: Thereafter, the song was recorded by a wide variety of creatures, including Muppets: and Dannii … Continue reading →

Posted in Bach | Tagged , , , | Leave a comment

3D Frames, axes and stiffness matrices

Posted on 09/12/2016 by dougaj4

In the course of adding provision for spring end releases to the 3DFrame spreadsheet, I have also tidied up the code for generating the structure stiffness matrix, and added some documentation to the spreadsheet.  The revised spreadsheet (version 2.02) can … Continue reading →

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , , , | 10 Comments