Recent Comments
Author Archives: dougaj4
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.03
The LatPilePY spreadsheet has been updated with detailed corrections to the function for generating PY curves. The updated version can be downloaded from LatPilePY.zip. See LatPilePY 1.02 for more details of the spreadsheet content and background.
Posted in Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged COM624, Excel, laterally loaded piles, LatPilePY, UDF, VBA
5 Comments
The Hawkesbury River Bridge at North Richmond, NSW
The bridge over the Hawkesbury River near North Richmond, North-West of Sydney, is one of the first reinforced concrete structures in Australia. At the time of its construction it was the largest reinforced concrete bridge in the country, and it … Continue reading
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
The Family Tree
A great song with an excellent video from Sydney based band The Former Love (formerly The former Love Pirates): (Click on Vimeo to visit site, or click play, then full screen button: Family Tree by The Former Love from Kerinne … Continue reading
Newton Excel Bach, not (just) an Excel Blog 