Category Archives: Newton

Salutary pictures for bridge engineers

Posted on 29/12/2010 by dougaj4

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

Posted on 21/12/2010 by dougaj4

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

Posted on 15/12/2010 by dougaj4

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

More on the Excel Evaluate function

Posted on 14/12/2010 by dougaj4

Previous posts have presented the Eval() User Defined Function, using the Evaluate function in VBA to evaluate mathematical functions displayed as text (Evaluate Function, Evaluate Function – Update).  It was recently pointed out by Jeff Weir that the Evaluate function has its origins … Continue reading →

Posted in Excel, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , | 4 Comments

Interpolation Update

Posted on 07/12/2010 by dougaj4

The interpolation functions in IP2.xls have been given an overhaul: The linear and quadratic interpolations routines have been modified to accept negative values. All the routines have been modified to convert the table range to an array, rather than using a … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 4 Comments