Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
Recent Comments
Author Archives: dougaj4
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
Comparing floating point numbers
Some of the issues raised in this post: https://newtonexcelbach.wordpress.com/2011/12/20/when-does-35-not-equal-35/ arose when writing the functions for the previous post on combining arrays. In particular, when values from the two arrays are “equal” the function should create one entry in the combined … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged Combinearray, EqualT, Excel, floating point comparison, UDF, VBA
4 Comments
Two dystopian futures, in short
Two of my daughter’s short films are now available on the Web: Precious In a dystopian future, two men meet in an underground tunnel for an exchange of stolen goods. Liam lives in the stacks, making small black market deals … Continue reading