Category Archives: UDFs

Evaluate Function – update

Posted on 05/07/2008 by dougaj4

Previous post The evaluate function described in the previous post has been used in writing a UDF that will evaluate the integral of any suitable function over a specified range. The revised worksheet can be downloaded from: Eval.zip

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

Importing text files with VBA – 3

Posted on 27/06/2008 by dougaj4

The text import file has been modified to split large files into one or more ranges. The maximum number of rows for each range is specified, together with a sufficient number of valid range names, which may be on the … Continue reading →

Posted in Excel, UDFs | Tagged , , , , , | 20 Comments

Reinforced Concrete Section Analysis – 4

Posted on 21/06/2008 by dougaj4

Previous post The spreadsheet presented in the previous post in this series uses the basic equation given below to find the location of the neutral axis: For a cross section with any applied axial load at eccentricity e, measured from … Continue reading →

Posted in Beam Bending, Excel, Newton, UDFs, Uncategorized | Tagged , , , , | 1 Comment

Importing text files with VBA – 2

Posted on 15/06/2008 by dougaj4

Previous post The text file import routines and functions presented in the previous post have been modified with the following additions: Lines of text can be split into separate cells, at any designated character (e.g. a coma or a space) … Continue reading →

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

Reinforced Concrete Section Analysis – 3

Posted on 30/05/2008 by dougaj4

Previous post -1 Previous post -2 The theory presented in the previous 2 posts in this series has been incorporated into an Excel UDF, allowing concrete and reinforcement stresses and strains to be evaluated quickly and easily for reinforced and … Continue reading →

Posted in Beam Bending, Excel, Newton, UDFs | Tagged , , , , , , , , | 8 Comments