Category Archives: UDFs

Intersections, interpolations, and rotations

Posted on 10/08/2008 by dougaj4

Amongst the many and varied functions provided by Excel (or as far as I know any other spreadsheet) there are none that provide a one step process for linear interpolation, finding the intersection points of lines, or conversion between polar … Continue reading →

Posted in Coordinate Geometry, Excel, UDFs, VBA | Tagged , , , , , , | 37 Comments

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