Author Archives: dougaj4

Iterative solvers and arrays

Posted on October 21, 2018

A recent thread at Eng-Tips was looking for a solution to the problem described  below: The solutions to this problem described below can be downloaded from: ItSolve.zip and xlScipy3.zip The ItSolve.xlsb spreadsheet contains a user defined function (UDF) to solve iterative … Continue reading →

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

Australian Greenhouse Gas Emissions

Posted on October 3, 2018

What the Australian  Government says: PM claims Australia will meet Paris target ‘in a canter’ despite emissions climbing. Morrison says rate of increase not as high as previous years and renewables investment will ensure Australia meets commitment pm-claims-australia-will-meet-paris-target-in-a-canter-despite-emissions-climbing What the … Continue reading →

Posted in Climate, Newton | Tagged , , | 1 Comment

Time in hours and minutes between two dates

Posted on September 30, 2018

Dates and times in Excel are stored as a date number, which is the number of days since 1 January 1900, with the value after the decimal point representing the time of day. To calculate the number of hours between … Continue reading →

Posted in Excel | Tagged , , , , | 4 Comments

New AS 3600 and RC Design Functions 8

Posted on September 23, 2018

A revised version of the Australian Concrete Structures code, AS 3600, was recently published, with many significant changes, including: Changes to ULS reduction Factors Creep and shrinkage Curvature and deflection calculations Crack width calculation and stress limits Major  changes to … Continue reading →

Posted in Concrete, Newton, UDFs, VBA | Tagged , , , , , | 1 Comment

2 more Moves Through the Fair

Posted on September 20, 2018

I have just mended a broken link in the previous installment of “She moves Through the Fair”. Here are two more, from Tir Eolas: and Tara McNeill:

Posted in Bach | Tagged , , | 2 Comments

Arc-spline update

Posted on September 9, 2018

The input for the first version of the Arcspline function required the coordinates of the centre of each arc, as well as the angle of the tangents at each end of the arc.  I have now added a new version with … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 7 Comments

Using Redim and 3DFrame

Posted on August 31, 2018

I recently received a query about the 3DFrame spreadsheet failing to run.  The problem was that the code was trying to Redim an array that had not been previously created with a Dim statement.  This does not cause a problem … Continue reading →

Posted in Excel, Frame Analysis, VBA | Tagged , , , | 1 Comment