This page is intended to help visitors decide whether something of interest to them might have been loaded since their last visit. (Entries more than a few years old tend to get weeded out.)
21st July 2022: Released a minor update (version 17) to the “John Clarke Australian Verse” document.
4th July 2022: Completely new item. A program (not a spreadsheet) that analyses beams on an elastic foundation. This has been gradually developed over many years. It accommodates differing foundation stiffnesses, axial compressions, different stiffnesses for upwards and downwards displacements, lift-off, plus many other features.
13th January 2022: Released a minor update (version 2.05) to the Horizontal Lifeline spreadsheet, having added some comments on a way to accommodate non-rigid anchorages.
14th October 2021: Released a trivial revision (version 1.01) to the “template” spreadsheet.
6th October 2021: Released a new spreadsheet. This new offering uses Monte Carlo simulation in an attempt to determine the likely vibrations that a crowd of randomly walking pedestrians will induce in a flexible pedestrian bridge.
At the same time I released a minor revision (version 5.02) to the “Loaded Cable” spreadsheet. This reflects some minor refinements and some further tidying up.
18th August 2021: Released a major revision (version 5.00) to the “Loaded Cable” spreadsheet. This adds two significant new features:
» The cable’s endpoints can be supported elastically rather than rigidly.
» The cable can have different properties either side of the loaded point.
It also corrects a long-standing error where under some rare circumstances the Solver would converge onto a totally (and obviously) ludicrous solution.
[These improvements were “sponsored” by Melbourne’s sixth Covid lockdown.]
11th June 2021: Covid kindly allowed me to refine a rudimentary sort‑of “template” for use in developing future spreadsheets that will be underpinned by the same general interactions. Version 1.00 of this template is now able to be downloaded, along with a document that explains the philosophy behind it.
23rd March 2021: Released a new version (3.06) of the “Dynamics of a two-degree-of-freedom system” spreadsheet. The change in this update is what I hope is a small improvement in the clarity of the graph of the sensitivity analysis.
17th February 2021: Inspired by my third burst of Covid-induced lockdown, I developed and released a new version (3.04) of the “Dynamics of a two-degree-of-freedom system” spreadsheet. The main change in this update is the addition of a capability for sensitivity analysis, allowing the user to explore the effect of varying various defining parameters. This is a significant addition.
11th January 2021: Released a new version of the “edge of slab on elastic foundation” spreadsheet. Only significant change is a more detailed discussion of the apparently parabolic deflection contours under the action of a point load at the origin.
4th December 2020: Released a new version of the “analysis of reinforced concrete cross-section” spreadsheet. Main change is improved guidance on recalcitrant problems, supplemented by a few cosmetic improvements.
21st October 2020: Released new versions of the two “slab on elastic foundation” spreadsheets, adding to each the ability to rotate individually the predefined load shapes.
Edge of slab on elastic foundation, now version 1.05
Interior of slab on elastic foundation, now version 2.05
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.
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.
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.
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.
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”.
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.
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: 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.
s n i p s n i p s n i p
Nov 2012: Site created.