Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Cubic Splines
- Filling Blanks with Go To-Special (and local help rant)
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Frame Analysis with Excel – 7; Shear deflections and support displacements
- RCInteract and RC Design Functions 7.03
- Writing Arrays to the worksheet - VBA function
Recent Comments
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 Coordinate Geometry, Geometric Tools
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 COM624, Excel, Laterally loaded pile, LPile, UDF, VBA
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 COM624, download, laterally loaded piles
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
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 Cubic, Excel, Newton-Raphson Method, Polynomial, Quartic, UDA, VBA
3 Comments