Author Archives: dougaj4

2010 in review

The stats helper monkeys at WordPress.com mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health: The Blog-Health-o-Meter™ reads Wow. Crunchy numbers The Louvre Museum has 8.5 million visitors per year. … Continue reading

Posted in Computing - general | Tagged | Leave a comment

Buckling of rings and arches

In 2007 I wrote a paper on buckling of confined steel tunnel liners for the ANZ Geomechanics Conference in Brisbane, and in the course of that I noticed that the calculated buckling load of an unconstrained pipe subject to uniform radial load was significantly … Continue reading

Posted in Arch structures, Beam Bending, Excel, Newton, VBA | Tagged , , , | 15 Comments

Salutary pictures for bridge engineers

Following the Minnesota bridge collapse, Time magazine published photos of the ten worst bridge collapses of the last 100 years: The Worst Bridge Collapses in the Past 100 Years An interesting list, many of which I hadn’t heard of, although … Continue reading

Posted in Historic Bridges, Newton | Tagged , | 2 Comments

ULS design of reinforced concrete, AS, ACI and European codes

The previous post in this series compared the results of current and previous Australian Standards, and the ACI 318 code, for the ultimate bending capacity of a rectangular reinforced concrete section, subject to combined bending and axial load.  I have now extended … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs | Tagged , , , , , , , , | 1 Comment

Charting a Mathematical Function with Defined Names

This post is a compilation of information from Stephen Bullen, Jan Karel Pieterse, and George Lungu.  To quote JKP “When doing mathematics, wouldn’t it be nice if we could type an equation into a cell in Excel and immediately see … Continue reading

Posted in Arrays, Charts, Excel, Maths | Tagged , , , , | 7 Comments