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.)
5th May 2025: Released a further update (version 24) to the “John Clarke Australian Verse” document.
6th April 2025: Released a new spreadsheet aimed at spreadsheet developers. This tests the behaviour of Excel’s IS… functions when they are fed a range of different input types.
24th January 2025: Released a heap of trivial minor updates for the following items.
» Edge of a semi-infinite slab on an elastic foundation (V1.10)
» Loaded cable (V5.06)
» Analysis of reinforced concrete cross-section (V4.11)
» Dynamics of a two-degree-of-freedom system (V5.01)
» Dynamic analysis of machinery foundation (V4.06)
» Dynamic buckling of Euler column under short-duration loading (V1.07)
» Buckling analysis of a stiffened cylinder under radial pressure (V1.07)
» Simulation of random dynamic pedestrian loadings on a bridge (V2.02)
» Maximising mixing at a table (V1.03)
» Maximising mixing at a multi-session tournament (V5.02)
» Template for DIY spreadsheets (V1.04)
This was done mainly to clean up a bit of accumulated tinkerings.
13th September 2024: Released a further update (version 23) to the “John Clarke Australian Verse” document.
13th August 2024: Released a minor update (2.01) of the “Solar Angles” spreadsheet. Some potentially confusing comments have been clarified.
9th August 2024: Released a minor update (1.09) of the “Parking analysis” spreadsheet. The changes relate to the occasional problem with meandering command buttons.
30th July 2024: Released very minor revisions to four spreadsheets. The revisions merely make the spreadsheets more compatible with my evolving “standard format”:
» Extreme Value (V3.06)
» Parking Analysis (V1.08)
» Stiffened Cylinder (V1.06)
» Table Mixing (V1.02))
29th July 2024: Released a minor update (2.04) of the “Multiple regression” spreadsheet. The changes are entirely within the Documentation worksheet.
26th July 2024: Released a significant new version (5.00) of the “Dynamics of a two-degree-of-freedom system” spreadsheet. This corrects a long-standing error in the Harmonic results table, where some of the phasors had their phase angles wrong by exactly 180°.
12th July 2024: Released yet another new version (4.01) of the “Dynamics of a two-degree-of-freedom system” spreadsheet. The changes are further refinements in the TimeHistory_Calcs worksheet, including adding a bit of user-control over what is displayed in the graphs.
15th June 2024: Added a new non-software item, that being a pair of presentations I gave on the design and construction of Australia’s Alice Springs to Darwin railway line.
19th March 2024: Released a new version of the Draped Beam analysis spreadsheet. This can now include in the analysis an external moment applied at the lift-off point. There are also a few minor cosmetic improvements.
28th February 2024: A completely new item. A spreadsheet that helps the organisers of multi-session social tournaments to assign players to playing tables in such a way that ensures no player sits with any other player more than once.
19th January 2024: Released a very minor revision to several spreadsheets. The revision corrected a rare and totally inconsequential error where the “Documentation” worksheet’s index could show the wrong row number. The vulnerable spreadsheets were:
» Analysis of a draped beam (V1.02)
» Loaded cable (V5.05)
» Analysis of reinforced concrete cross-section (V4.10)
» Dynamics of a two-degree-of-freedom system (V3.08)
» Horizontal Lifeline cable (V2.06)
» ‘Dynamic buckling’ of Euler column under short-duration loading (V1.06)
» Simulation of random dynamic pedestrian loadings on a bridge (V2.01)
» ‘Template’ for DIY spreadsheets (V1.03)
In addition, the Dynamic buckling and the Two degree of freedom spreadsheets also had some very minor improvements incorporated into these new releases.
16th January 2024: Released a minor update (version 5.04) to the “Loaded Cable” spreadsheet. There are no calculational changes.
16th January 2024: Released an absolutely trivial update to the “Understanding and using your brain” document.
13th February 2023:
(1) Changed the download package for the Beam on Elastic Foundation program to include the executable file with its extension changed from .EXE to .ZZZ in an attempt to thwart overzealous protection systems.
(2) Rearranged entries on the Software Downloads page in an attempt at more logical ordering. Perhaps a slight improvement?
s n i p s n i p s n i p
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.