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
- Downloads
- Daily Download 5: Frame Analysis
- Writing Arrays to the worksheet - VBA function
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Deflections and Moments in Rectangular Plates
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Category Archives: Geotechnical Engineering
Lateral pile analyis with PY curves …
… and non-linear pile properties. In previous posts I have presented Excel User Defined Functions (UDFs) to analyse a laterally loaded pile, generate soil PY Curves based on the recommendations in the COM624 Manual, and determine the flexural stiffness of cracked … Continue reading
Posted in Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged COM624, Excel, Laterally loaded pile, Non-linear concrete, UDF, VBA
17 Comments
Beam on Elastic Foundations Analysis
A previous post on laterally loaded piles used a finite difference analysis to analyse the deflections and forces in a vertical pile subject to a lateral load at the top. An alternative approach to the same problem is presented in “Programming the Finite … Continue reading
Posted in Excel, Finite Element Analysis, Geotechnical Engineering, Newton, UDFs, VBA
Tagged Beam on elastic foundations, Excel, laterally loaded piles, UDF, VBA
6 Comments
P-Y Curve function
The pile lateral load analysis program presented in a previous post used linear elastic spring supports to model the restraint provided by the soil. Soil stress/strain behaviour is of course highly non-linear, and this post presents an Excel User Defined Function … Continue reading
Posted in Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged COM624, Excel, laterally loaded piles, Soil PY curves, UDF, VBA
21 Comments
Update to Publications
I have (at long last) updated my list of publications (all downloadable). Click on the link below to visit the site, or download direct from the list here. My Publications Here is the current list: Predicting the Deflection … Continue reading
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