This page is intended to help visitors decide whether something of interest to them might have been loaded since their last visit.
18th September 2020: Released a new version (4.07) of the “Loaded Cable” spreadsheet. The main change in this update is a correction to the calculation of “belt & bollard” friction. Earlier versions calculated this in a NON-CONSERVATIVE way for cables that had a significant out-of-plane force component.
9th July 2020: Released a new version (3.03) of the “Dynamics of a two-degree-of-freedom system” spreadsheet. The main change in this update is the addition of a phasor diagram.
22nd May 2020: Added CESDb to the “Other sites” page.
16th March 2020: Released a new version (1.04) of the “Dynamic Buckling” spreadsheet. The main change in this update is the inclusion of an alternative force-time pulse shape.
6th March 2020: Released a new version (1.03) of the “Dynamic Buckling” spreadsheet. The main change in this update is the inclusion of the results of a verification exercise that used finite element analysis.
15th February 2020: Released a new version (4.06) of the “Loaded Cable” spreadsheet. The only change in this update is to make it possible, under user control, to analyse cables that are extremely slack or extremely extensible.
5th February 2020: Released a new version (4.03) of the “Dynamic Analysis of Machinery Foundation” spreadsheet. The main changes in this update reflect more informative documentation of the Coupled Analysis capability.
11th December 2019: Released a new version (4.04) of the Cross Section Analysis spreadsheet. This update hides unused lines in some of the output tables, to save printer paper.
14th October 2019: Released an update (version 14) to the “John Clarke Australian Verse” document. This update is relatively minor.
22nd July 2019: Released a new spreadsheet that calculates solar angles.
25th February 2019: Released a new spreadsheet that maximises the mixing among a group of people seated around a single table enjoying a multi-course meal. Between each course, they should change seats as per the plan this spreadsheet produces.
7th January 2019: Incorporated into several of the spreadsheets a warning if they are opened on non-Windows computers:
Analysis of reinforced concrete cross-section
Edge of slab on elastic foundation
Interior of slab on elastic foundation
Car parking analysis
Buckling of stiffened cylinder
25th October 2018: Released new versions of nearly all the engineering spreadsheets. This was triggered by the discovery of a very infrequent, possibly machine dependent, VBA error that occurs when the spreadsheet is opened. The problem seems to be related to code attempting to be executed before the page is ready, particularly when the spreadsheet opens in protected mode. I believe that the updated versions get around the problem, but cannot guarantee this. If you haven’t hit the problem you probably don’t need to download these new versions. But why not play safe and do it while you are here?
24th October 2018: Released a new spreadsheet. This one calculates the probabilities of an environmental “extreme event” occurring during the expected life of a project when the underlying “environmental regime” that throws up these events is changing with the passage of time.
July 2018: Released a major upgrade to the Loaded Cable spreadsheet (version 4.00). Responding to user requests I have extended it so that the applied point load can now include a Z component as well as X and Y components. At the same time, also in response to requests, I have rearranged the work area and added a lot of annotation to it.
April to 2nd May 2018: Web site was “down”, due to the combined effect of a minor glitch in some software and a major inattentiveness in me. My apologies to anyone who was inconvenienced. I’d like to say it won’t happen again, but I’d probably be lying.
October 2017: Uploaded an attempt to identify the poets and poems being parodied by John Clarke in his brilliant book “The Even More Complete Book of Australian Verse”.
August 2017: Uploaded a new version (1.02) of the Parking Analysis spreadsheet. Main change was trapping an error that would occur if the user analysed a development containing dwelling sizes for which no population statistics were available.
April 2017: Added a new spreadsheet that uses Monte‑Carlo simulation to investigate the adequacy (or otherwise) of the on‑site car parking provided by a residential real estate development.
December 2016: On about 20th December I was advised by my website hosting service that my site had been maliciously “compromised”, and so had been suspended. Since that time I have been gradually putting the pieces back together. I believe that this process has now been completed.
August 2016: Added a new spreadsheet to investigate (very crudely) the “dynamic buckling” of an Euler column subjected to a short-duration axial compression.
June 2016: Corrected a minor error in “horizontal lifeline” spreadsheet, where it threw up a host of “divide by zero” errors in its new dynamic analysis worksheet if the value of H was entered as exactly zero. Embarrassing, eh?
June 2016: The dynamic analysis worksheet of the “horizontal lifeline” spreadsheet was comprehensively reworked to allow the inclusion of “energy absorbers” in the analysis.
May 2015: I have at last had an opportunity to check my spreadsheets under Excel 2013. The checking was relatively superficial, but it suggests that none of them have any problems.
May 2015: Updated the paper about dynamic loadings on pedestrian bridges. The only change is the inclusion of the derivation of some of the equations presented in the paper.
May 2015: Added a spreadsheet demonstrating some useful, lesser-known features in Excel.
Feb 2015: “Multiple regression” spreadsheet made available for the first time.
Feb 2015: Site restored after about four days of inaccessibility caused by some glitch somewhere. Late New Year resolution: I must remember to check accessibility more frequently.
Sep 2014: Web site repaired after having been rendered totally inaccessible for about a fortnight.
“Dynamic analysis of machinery foundation” spreadsheet added.
“Private downloads” page created.
Very minor changes made to “Brain function” document.
Oct 2013: “Buckling analysis of stiffened cylinder” spreadsheet added.
Jun 2013: “Analysis of reinforced concrete cross-section” spreadsheet added.
This “site history” page created.
“Other sites” page created, and (very thinly) populated.
Jan 2013: “Dynamics of two degree-of-freedom system” spreadsheet added.
Nov 2012: Site created.