Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Scipy linear algebra functions in Excel
- Latex Maths Text in Excel
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LinEst() on data with gaps
- Section Properties of Defined Shapes - Spreadsheet
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Commenting a block of code in VBA
Recent Comments
Tag Archives: PY curves
Daily Download 7: Lateraly loaded pile analysis
Today’s downloads (the last in the Engineering category) are related to the analysis of piles subject to lateral loads: LatPile – Analysis of Lateral Loads on Piles describes the principles of the analysis. Download file: http://interactiveds.com.au/software/LatPile.zip P-Y Curve function describes function to … Continue reading
Posted in Beam Bending, Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged Beam on elastic foundations, COM624, Excel, laterally loaded piles, PY curves, UDF, VBA
3 Comments
The Switch Function (VBA and UDF)
Switch is a VBA function that operates in a similar way to the Select Case statement. The function arguments are a series of pairs of values, the first of each pair being an expression that can be evaluated as TRUE … Continue reading
Posted in Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged Excel, PY curves, Switch function, UDF, VBA
9 Comments
LatPilePY 1.02
Following some discussion at Eng-Tips and elsewhere I have updated the LatPilePY spreadsheet, previously presented at Lateral pile analysis with PY curves … This spreadsheet provides User Defined Functions (UDFs) to carry out the analysis of vertical piles under lateral loading, … Continue reading
Posted in Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged COM624, Excel, laterally loaded piles, PY curves, soil properties, UDF, VBA
3 Comments