Author Archives: dougaj4

The Conjugate Beam Method

Posted on 20/01/2017 by dougaj4

The Conjugate Beam Method is a variation of the Moment-Area Method that allows beam slopes and deflections to be calculated purely from the calculation of shear forces and bending moments of the beam with (in some cases) modified support conditions.  Both methods were … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton | Tagged , , , | 6 Comments

3D Frame analyses with spring releases – 2

Posted on 04/01/2017 by dougaj4

The latest version of the 3DFrame spreadsheet (previously presented here) includes provision for spring end releases, allowing for either rotational or translational springs in any direction.  These springs are now incorporated in the model by adjustment of the beam properties, … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , | Leave a comment

On the probability of frog croaks.

Posted on 02/01/2017 by dougaj4

A recent logical puzzle from TED discussed the probability of one of two frogs being female, if we know that at least one of them is male: This puzzle is discussed (arriving at different conclusions) here: and puzzles of this … Continue reading →

Posted in Excel, Maths, Newton, VBA | Tagged , , | Leave a comment

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