Category Archives: Arrays

Working with FEM data and using the dictionary object

Posted on 26/09/2010 by dougaj4

This post features an Excel User Defined Function (UDF) to count the number of different element types (beams, plates, bricks and links) and the number of node restraints at each end of listed beams from a finite element model.  The … Continue reading →

Posted in Arrays, Excel, Finite Element Analysis, Newton, UDFs, VBA | Tagged , , , , , | 5 Comments

SplineBeam update

Posted on 20/06/2010 by dougaj4

Previous SplineBeam post I have modified the SplineBeam spreadsheet to allow input of a single span (simply supported or with end constraints), and to optionally allow input of the position of intermediate nodes, rather than dividing each span into equal segment lengths.  This … Continue reading →

Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , | 1 Comment

Compiled AlgLib Matrix Functions for Excel

Posted on 27/05/2010 by dougaj4

This post describes a series of matrix functions compiled from the AlgLib library code (covered in previous posts) as a dll that can be called from Excel VBA, and used as User Defined Functions (UDFs).  A spreadsheet containing the necessary VBA … Continue reading →

Posted in Arrays, Excel, Link to dll, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 18 Comments

Installing AlgLib with Excel VBA

Posted on 20/05/2010 by dougaj4

In a previous post I linked to the AlgLib site which has an extensive range of mathematical routines available in VBA, c/c++ and pascal.  I have recently been experimenting with these (in reponse to a thread at the Eng-Tips forum), and will … Continue reading →

Posted in Arrays, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , | 13 Comments

Calling a function as a variable

Posted on 08/04/2010 by dougaj4

The functions described in recent posts provide iterative solutions to polynomial equations, but the same method can be used for any equations that can be evaluated numerically and have a single variable.  The question then is, how can we call a … Continue reading →

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