Tag Archives: VBA

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

Daniel’s XL Toolbox

Posted on 25/11/2009 by dougaj4

I downloaded this yesterday: Daniel’s XL Toolbox “Daniel’s XL Toolbox is a free, open source add-in for Excel® that helps you to analyze and present data.” See the link for a full description. I’ve only had a brief look, but … Continue reading →

Posted in Excel, VBA | Tagged , , , | Leave a comment

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