Tag Archives: UDF

Evaluate integrals to a specified tolerance

Posted on 10/03/2009 by dougaj4

A previous post presented a user defined function (UDF) to perform a numerical integration of a function specified as a text string.  The UDF allowed the number of subdivisions of the integration range to be specified, but the number of subdivisions required to … Continue reading →

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

Splitters!

Posted on 07/03/2009 by dougaj4

A recent post on the Tek-Tips VBA forum reminded me that VBA has a split function, which will split a string into sub-strings at any specified character (such as a space).  D’oh I thought, why did I waste my time writing … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , | Leave a comment

Importing tab delimited files and clearing large ranges

Posted on 01/03/2009 by dougaj4

Wray Sisk commented on Importing text files with VBA – 3, asking if it could be modified to read tab delimited files. It could be, and has been; download here: Text-in2.ZIP It turned out to be a simple task; just … Continue reading →

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

Frame Analysis with Excel 2 – Single inclined beam

Posted on 04/02/2009 by dougaj4

This post continues from – Frame Analysis with Excel 1 – Single beam Download Beam2.zip The stiffness matrix shown in the previous post was for a single beam with loads applied either perpendicular to the beam, or along the longitudinal beam axis, … Continue reading →

Posted in Excel, Frame Analysis, Newton, UDFs | Tagged , , , | 11 Comments

Frame Analysis with Excel 1 – Single beam

Posted on 31/01/2009 by dougaj4

Download Beam1.zip This is the first of a series of posts in which I will develop a structural frame analysis program operating within Excel.  The first few stages will be mostly spreadsheet based, with later stages using VBA routines to … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, Uncategorized | Tagged , , , | 14 Comments