Tag Archives: UDF

Solving simultaneous equations

Posted on 27/08/2008 by dougaj4

Solving a series of simultaneous equations is a task frequently required in engineering and scientific analysis.  Excel provides the tools to perform this task quickly and easily, but the procedure is not documented in the on-line help (so far as … Continue reading →

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

Reinforced Concrete Section Analysis – 5; Ultimate Limit State

Posted on 19/08/2008 by dougaj4

Previous posts in this series have looked at the analysis of beams where the steel stress is within the elastic range, and the concrete stress is sufficiently low that the assumption of linear elastic behaviour in compression is a reasonable approximation.  … Continue reading →

Posted in Beam Bending, Excel, UDFs | Tagged , , , , , , , | 5 Comments

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