Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- About Newton Excel Bach
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Using LINEST for non-linear curve fitting
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- Linking Excel to C
- Linking Excel to Fortran - 2
- The angle between two vectors, Python version
- Continuous Beam Spreadsheet - with Units
Recent Comments

Z on Downloads py_xlCBA update | Ne… on Calling PyCBA from Excel 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
khoitsma on Continuous beam animations wit… 
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…
Tag Archives: Laterally loaded pile
LatPilePY 1.04
Following comments from Stephen on LatPile 1.03 I have modified the code so that if the specified Soil Properties range includes lines 8 and 9 (for specified effective depths at the top of each layer), but these lines are blank, the effective … Continue reading
Posted in Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged COM624, Excel, Laterally loaded pile, LatPilePY, UDF, VBA
15 Comments
Using LatPilePY
LatPilePY is a User Defined Function (UDF) used to analyse the deflections and load actions in laterally loaded piles. It was presented in this post: LatPilePY. In response to an e-mail request, this post will give step by step instructions for … Continue reading
Posted in Arrays, Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged Array Function, COM624, Excel, Laterally loaded pile, Non-linear concrete, UDF, VBA
Leave a comment
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
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