Tag Archives: UDF

Cubic Spline Update

Posted on 16/12/2009 by dougaj4

The previous post in this series presented a User Defined Function (UDF) to fit  a cubic spline to a series of points defined by XY coordinates.  Each segment of the resulting spline is defined by a separate cubic curve, which may be … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 1 Comment

Reinforced Concrete Moment-Curvature – 2; Shrinkage and Creep

Posted on 08/12/2009 by dougaj4

The previous post in this series provided an Excel User Defined Function (UDF) to find  the short term curvature of a reinforced concrete section subject to combined bending and axial load.  In this post UDFs will be presented to determine the strain … Continue reading →

Posted in Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , | 4 Comments

Reinforced Concrete Section Analysis – with prestress

Posted on 25/10/2009 by dougaj4

The simplified reinforced concrete section analysis spreadsheet presented here has been revised to allow the input of a pre-tension stress to either or both layers of reinforcement.  The spreadsheet (including full open source code) can be downloaded from RC Design Functions5. Note … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , , | 3 Comments

Three UDFs

Posted on 05/10/2009 by dougaj4

This post is in response to recent discussions at Daily-Dose-of-Excel where many and various worksheet formulas have been suggested to carry out tasks that are (it seems to me) better done with a simple User Defined Function (UDF): Adding Every … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , | 8 Comments

LatPile – Analysis of Lateral Loads on Piles

Posted on 26/09/2009 by dougaj4

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