Category Archives: Excel

Solving higher order polynomials

Posted on 13/01/2011 by dougaj4

The Quartic spreadsheet presented here previously (most recently here) uses algebraic techniques to provide an “exact” solution to polynomial equations of up to fouth order.  For polynomials of higher order there is no general algebraic solution, and numerical methods are … Continue reading →

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

LatPile update

Posted on 11/01/2011 by dougaj4

I have just posted an update to the LatpilePY spreadsheet, fixing a bug in the way in which it read the first row of data from input PY curves, which was resulting in the program failing to run if there were … Continue reading →

Posted in Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , , | 2 Comments

Elegant Solutions – completing the square

Posted on 08/01/2011 by dougaj4

When I was at school (many years ago), if I recall correctly, we were told of the “completing the square” method of solving quadratic equations, but I never really appreciated the elegance of this method because it was treated as … Continue reading →

Posted in Excel, Maths, Newton | Tagged , , , , | 1 Comment

Buckling of rings and arches

Posted on 01/01/2011 by dougaj4

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

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