Category Archives: UDFs

Function roots with the Inverse Quadratic Method

Posted on 31/03/2010 by dougaj4

An earlier post presented various methods for finding the roots of polynomial functions based on the use of linear interpolation.  It is sometimes advantageous to use a quadratic interpolation function, and methods using this approach will be presented in this and following … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , , , | 5 Comments

Tension Stiffening

Posted on 12/03/2010 by dougaj4

Tension Stiffening in reinforced concrete is the increase in stiffness of a cracked member due to the development of tensile stresses in the concrete between the cracks.  The main application of tension stiffening theory in design applications is in the … Continue reading →

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

Stringing more than two words together

Posted on 01/03/2010 by dougaj4

It has always seemed strange to me that the Excel function Concatenate(), which has such a long name, provides no additional functionality over using the & operator. The TextString function is a simple User Defined Function (UDF) which provides the … Continue reading →

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

Reinforced Concrete Moment-Curvature – 4; Development of curvature over time

Posted on 12/02/2010 by dougaj4

The previous post in this series looked at how specified shrinkage and creep strains affect the curvature of a reinforced consrete section subject to a constant load.  In this post I will present a User Defined Function (UDF) that analyses … Continue reading →

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

Hello World (again)

Posted on 02/02/2010 by dougaj4

Over at Daily Dose of Excel Dick has been asking for suggestions for excellent training, to which Jan Karel Pietersen replied that training should be relevant to the task at hand, and that “hello world” examples are useless. John Walkenbach responded … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , , , | 2 Comments