Author Archives: dougaj4

LatPile – Analysis of Lateral Loads on Piles

Posted on 26/09/2009 by dougaj4

This post presents an Excel User Defined Function (UDF) to carry out the analysis of vertical piles subject to horizontal loads, using the same approach as employed in the DOS program COM624. A spreadsheet including the UDF and an on-spreadsheet … Continue reading →

Posted in Beam Bending, Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , | 11 Comments

COM624 download and documentation sites

Posted on 25/09/2009 by dougaj4

COM624 is a freeware DOS based program for the analysis of lateral loads on piles produced by the FHWA in the USA.  The program and documentation are available for free download, but are well hidden, so I’m posting links to … Continue reading →

Posted in Geotechnical Engineering, Newton | Tagged , , | 11 Comments

Fred Watson on the Big Bang

Posted on 21/09/2009 by dougaj4

The multi-talented Fred Watson paid for his studies by playing folk music alongside the likes of Billy Connolly, and now makes a living looking at stars. Here he is talking about Life, The Universe and Everything: Marcus Chown in Conversation … Continue reading →

Posted in Bach, Newton | Tagged , , | Leave a comment

Approximate Solutions of Polynomial Equations

Posted on 14/09/2009 by dougaj4

Following on from the previous post, this post presents a number of methods of solving polynomial equations using approximate iterative methods in Excel.  Similar methods can be used to find solutions to any other equation that can be evaluated numerically. … Continue reading →

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

Evaluating Polynomial Functions

Posted on 10/09/2009 by dougaj4

A polynomial function is a function of the form: a + b*x + c*x^2 + d*x^3 … and the derivative (the slope of the line at point x) of this function is given by: b + 2c*x + 3d*x^2 … … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , , , | 5 Comments