Software downloads


Introduction

See below for a list and brief description of my offerings.  These are all made available under the terms of the “GNU General Public License” developed by the Free Software Foundation.  A copy of this licence is included as part of the downloads.

The spreadsheets are all written for Microsoft’s Excel.  Most require that macros be enabled, and some require that the Solver add-in be activated.  Those with macros will run on Gatesian computers but not on Jobsian computers, due to differences in the way VBA is implemented.

If you wish to be kept abreast of any changes I might make to these offerings, please e-mail me using the information on the Contact me page.  Include in the e-mail the name(s) of the offering(s) you have downloaded.


Index of available items

Non-engineering stuff is at the bottom of the list.
     Interior of an infinite slab on an elastic foundation
     Edge of a semi-infinite slab on an elastic foundation
     Loaded cable
     Horizontal lifeline cable
     Dynamics of a two-degree-of-freedom system
     Behaviour of Euler column under short-duration axial compression
     Analysis of reinforced concrete cross-section
     Buckling analysis of a stiffened cylinder under radial pressure
     Dynamic analysis of machinery foundation
     Car parking analysis for a residential development
     Useful features in Excel
     Multiple regression
     Holiday cost sharing


Interior of an infinite slab on an elastic foundation

This is an Excel spreadsheet that calculates the bending moments and deflection that a set of arbitrarily-shaped pressure loadings produces in the interior of an infinite slab supported on an elastic foundation.  The present version is 2·02, uploaded in January 2017.

Click here to download Return to index Return to top of page


Edge of a semi-infinite slab on an elastic foundation

This is an Excel spreadsheet that calculates the bending moment and deflection that a set of arbitrarily-shaped pressure loadings produces at the edge of a semi-infinite slab supported on an elastic foundation.  The present version is 1·02, uploaded in January 2017.

Click here to download Return to index Return to top of page


Loaded cable

This spreadsheet calculates the shapes and tensions in a loaded cable running between two fixed points.  The cable can be loaded with a single point load, not necessarily vertical, which can either be attached to a fixed location along the cable’s length or can have a frictionless sliding connection to the cable (such as a running roller).  The cable’s end points do not need to be at the same level.  The present version is 3·06, uploaded in September 2015.

Click here to download Return to index Return to top of page


Horizontal lifeline cable

This spreadsheet calculates the deflection and tension in a horizontal cable that is serving as a lifeline.  The cable can be investigated as a static system that is subjected to a “known” (ie code specified) vertical load.  Alternatively (or additionally) it can be investigated dynamically where a falling person of known weight falls from a known height, with his fall arrested by the energy takeup in the cable and his harness.  As of version 2.00 the dynamic analysis can include energy absorbers.  The present version is 2·02, uploaded in January 2017.

Click here to download Return to index Return to top of page


Dynamics of two-degree-of-freedom system

This spreadsheet performs a rigorous analysis of the dynamics of a linear two-degree-of-freedom structural dynamics problem.  It calculates the natural frequencies, and the harmonic response under a set of harmonic loadings.  It can also perform a time-history analysis for the system under the combined effects of arbitrary forces and arbitrary foundation movements.  The present version is 3·01, uploaded in July 2014.

Click here to download Return to index Return to top of page


“Dynamic buckling” of Euler column under short-duration loading

This spreadsheet models the lateral response of a sinusoidally-imperfect Euler column under the action of an axial compression load that is applied for a short (but not instantaneous) duration.  It takes an extremely simplified approach to this complex problem, relying on some very bold assumptions.  The present version is 1·02, uploaded in January 2017.

Click here to download Return to index Return to top of page


Analysis of reinforced concrete cross-section

This spreadsheet performs a “plane sections remain plane” analysis of a reinforced concrete cross-section under the combined actions of an axial force and biaxial bending moments.  The outline of the concrete cross-section can be completely arbitrary (defined as any polygon).  The stress-strain relationships for both the concrete behaviour and the steel behaviour can also be completely arbitrary (defined by a piecewise-linear relationship).  Prestressing is accommodated, slightly indirectly.  The present version is 4·01, uploaded in January 2017.

Click here to download Return to index Return to top of page


Buckling analysis of a stiffened cylinder

This spreadsheet performs a radial buckling check on a circular cylinder that is stiffened with ring stiffeners.  The loading causing the buckling is radially-directed external pressure along with the associated axial loading, plus (optionally) an additional axial compression force.  The check is carried out as per the requirements specified in the book “Buckling of steel shells — European design recommendations”, prepared by the European Convention for Constructional Steelwork (ECCS).  More specifically, the spreadsheet checks against the rules given in chapter 17 of the fifth edition of the book (published 2008).  The present version is 1·01, uploaded in January 2017.

Click here to download Return to index Return to top of page


Dynamic analysis of machinery foundation

This spreadsheet performs a dynamic analysis of a machinery foundation, using the method described in the book “Design of Structures and Foundations for Vibrating Machines” by S.Arya, M.O’Neill & G.Pincus.  The foundation is assumed to be a rigid concrete pad, possibly with some additional concrete blocks rigidly attached to it.  This is bearing on the ground, perhaps embedded slightly within it.  The foundation is supporting a vibrating machine which is imposing a harmonic loading upon it.  The present version is 4·00, uploaded in October 2017.

The download package also includes a note identifying some possible errors in chapter 6 of the book “Foundations for Machines: Analysis and Design” by S.Prakash and V.Puri.

Click here to download Return to index Return to top of page


Car parking analysis for a residential development

This spreadsheet performs a Monte‑Carlo simulation analysis into the adequacy of the on‑site car parking provided as part of a residential real estate development.  Such developments often provide sufficient car parking only for “average” car ownership levels.  Simulation analysis investigates the consequences of statistical fluctuations around any provided level, producing exceedance probabilities for various measures of inadequacy.  The present version is 1·03, uploaded in August 2017.

Click here to download Return to index Return to top of page


Useful features in Excel

This spreadsheet describes and demonstrates some of the lesser-known capabilities of Excel, particularly ones that might be useful in developing spreadsheets for engineering calculations.  Obviously the terms lesser-known, useful and engineering will be interpreted differently by different people:  hopefully my interpretations will not be vastly different from yours.  The present version is 2·00, uploaded in May 2015.

Click here to download Return to index Return to top of page


Multiple regression

This spreadsheet performs multiple regression on a set of data.  In so doing, it provides more comprehensive results than does Excel’s in-built LINEST function.  The spreadsheet also incorporates a method for the detection of outliers, but this capability should be used cautiously and sparingly.  The present version is 2·00, uploaded in February 2015.

Click here to download Return to index Return to top of page


Holiday cost sharing

This spreadsheet has been developed as an aid in maintaining the “accounts” for a group of people travelling together.  In such groups expenses tend to be paid at random by group members, and at the end of the holiday (or whenever it is felt necessary) someone has to work out who owes whom what to “balance” the accounts.  The balancing task is made more complicated if different expenditure types have to be shared in different ways, such as expenses for alcoholic drinks not being charged to a teetotaller.  The task is made even more complicated if multiple currencies are involved.  Both of these complications are accommodated by this spreadsheet.  The present version is 3·00, uploaded in February 2013.

(These days all of this can probably be achieved much easier using a 99¢ SmartPhone App, but what the heck.)

Click here to download Return to index Return to top of page