Author Archives: dougaj4

Boxing Day on the James Craig

Posted on 27/12/2015 by dougaj4

The James Craig is a 19th Century square rigger, restored by the Sydney Heritage Fleet, which makes regular sailings from Sydney Harbour open to the public, including a Boxing Day trip to observe the departing Sydney-Hobart race: The crew (all volunteers) … Continue reading →

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

More on Sums

Posted on 18/12/2015 by dougaj4

My post from last week, on using the Aggregate function to find the maximum and minimum of a range ignoring errors, was linked in the Contextures Blog’s weekly roundup, which also linked to the Contextures page of Sum Function examples.  This includes … Continue reading →

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

Sean Taylor

Posted on 13/12/2015 by dougaj4

Another excellent UK musician I had never heard of, and judging by the number of YouTube hits, neither have you: Someone comments that John Martyn comes to mind, so maybe this duo is not so surprising: Sean Taylor, Wikipedia Sean … Continue reading →

Posted in Bach | Tagged , | Leave a comment

Max, Min, and Aggregate

Posted on 11/12/2015 by dougaj4

Recently I needed to find the maximum and minimum of a range of values including some #N/A values.  Searching found a variety of solutions, of which the simplest (that works in all versions) seems to be: =MAX(IF(ISNUMBER(datarange),datarange)) =MIN(IF(ISNUMBER(datarange),datarange)) The function … Continue reading →

Posted in Excel | Tagged , , , , | 5 Comments

ConBeamU 4.08

Posted on 29/11/2015 by dougaj4

The continuous beam spreadsheet has had another update to fix a problem when point loads were applied to cantilevers, and the first support position was not listed as an output point.  The new version (4.08) can be downloaded from: ConbeamU.zip … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , | 1 Comment