Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Retrieving unique values from a range or array ...
- Latex Maths Text in Excel
- Deflections and Moments in Rectangular Plates
- 3D Matplotlib Plots in Excel
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Cubic Splines
- Contour plots with Excel and Matplotlib
- The Conjugate Beam Method
- Using LinEst() on data with gaps
Recent Comments

Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Installing Adobe Reader non-DC… 
Z on Downloads 
Z on Daily Download 8: Drawing in… py_ConBeamU and Stra… on py_ConBeamU and Strand7 check… 
dougaj4 on Daily Download 8: Drawing in… 
Z on Daily Download 8: Drawing in…
Tag Archives: COM624
LatPile update
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 COM624, Excel, free download, laterally loaded piles, Non-linear concrete, UDF, VBA
2 Comments
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
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
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