Structechnique is a provider of low-cost Excel* spreadsheet solutions for civil and structural engineering elements and design related issues. Structural elements include retaining walls, pre-stressed beams, steel and concrete composite bridges and box culverts designed in accordance with relevant Eurocodes. Design issues addressed include buckling, elastic impact, dynamics and tuned mass dampers and differential temperature effects

Grillage models* based on stiffness matrix analysis are available for 4-, 6- and 8-beam normal or skewed 1 to 3-span bridge decks, deck slab, abutment and wing walls. Integral or ‘ladder’ type decks can also be analysed using rotational springs or by omitting supports. Results have been verified by a commercially available structural analysis software program.

Spreadsheets include theoretical formulations and explanations of methodologies and allow access to all cell data and formulae (except stiffness matrices).. A brief summary and a list of contents is given for each spreadsheet and a pdf copy of calculation extracts is also available.

Technical papers published in The Structural Engineer (February 2017, January 2016 and July 2013) are also available to provide background reading to the structural dynamics and buckling spreadsheets.

All spreadsheets and technical papers have been prepared by Andrew Robertson based on 40 years’ experience in the design of highway structures. Design reviews and Highways Agency design checks can also be undertaken by separate contractual agreement (structechnique@gmail.com).

* Requires Excel 2016

Spreadsheet summaries and contents: