Monthly Archives: September 2009

Geometric Tools

I was recently sent a link to: Geometric Tools Documentation Which has a host of pdf files with detailed instructions on all manner of geometric calculations.  The focus of the site is animation for games programs, but there is plenty … Continue reading

Posted in Coordinate Geometry, Maths, Newton | Tagged , | Leave a comment

LatPile – Analysis of Lateral Loads on Piles

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

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

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

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