Category Archives: UDFs

IP.xls updated

Posted on 16/02/2009 by dougaj4

The spreadsheet IP.xls has been updated (previous post) with the addition of a function to find the minimum perpendicular distance from a point (or series of points) to a polyline: Pdist =PDist(Line,Points) Line is a range with at least two rows containing … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | 1 Comment

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