Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
Recent Comments
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
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 buckling, Excel, Rings and Arches, VBA
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
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 ACI 318, AS 3600, BS 5400, BS 8110, Concrete, EC 2, Reinforced Concrete, Section Analysis, Ultimate capacity
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 Chart, defined names, Excel, Lissajous Figures, plot function
7 Comments