Category Archives: UDFs

Multiple Match Function

Posted on 11/02/2009 by dougaj4

The Excel function MATCH() will find the position of the first occurrence of a specified number or string in a range of data, but what if you want to find the first row in a table that contains two or … Continue reading →

Posted in Excel, UDFs, VBA | 5 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

Repeating a set of data

Posted on 21/01/2009 by dougaj4

The Microsoft Excel Blog has a discussion on ways of repeating a set of data, for instance making three copies of every row of a range of data.  I have written a simple UDF to do this job, and also extract … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | 1 Comment

Significant Figures

Posted on 28/12/2008 by dougaj4

Excel does not provide any built in functions to round values to a specified number of significant figures.  The UDF below, recently posted at the Eng-Tips forum, will do the job: Public Function sigfig(my_num, digits) As Double Dim num_places As Integer … Continue reading →

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