Category Archives: VBA

LatPilePY 1.03

Posted on 27/01/2012 by dougaj4

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 , , , , , | 5 Comments

LatPilePY 1.02

Posted on 23/01/2012 by dougaj4

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 , , , , , , | 3 Comments

Comparing floating point numbers

Posted on 07/01/2012 by dougaj4

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 , , , , , | 4 Comments

Combining arrays

Posted on 05/01/2012 by dougaj4

Part of the Macaulay spreasheet presented in recent posts required the formation of a list of points along a beam where the functions needed to be evaluated.  These are: The support points, the changes of cross section, and the output … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , | 7 Comments

Continuous Beams with Shear Deflections

Posted on 31/12/2011 by dougaj4

The Macaulay Spreadsheet has now been modified to optionally include shear deflections, as well as a new option to output support reactions, and fixes to minor bugs. The revised spreadsheet (including full open source code) can be downloaded from: Macaulay.zip … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , | 10 Comments