Category Archives: VBA

Frame Analysis with Excel – 4, 2D frame analysis

Posted on 15/02/2009 by dougaj4

Continuing from: Frame Analysis with Excel – 3, Continuous beam or frame Download Frame1.zip – the download file includes complete open source code. The continuous beam spreadsheet presented in the previous post has been modified to deal with 2D frames where any … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, Uncategorized, VBA | Tagged , , , | 20 Comments

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 – 3, Continuous beam or frame

Posted on 10/02/2009 by dougaj4

Continuing from Frame Analysis with Excel 2 – Single inclined beam Download Beam3.zip – the download file includes complete open source code. The spreadsheet for a single inclined beam presented in the previous post has been modified to deal with up … Continue reading →

Posted in Excel, Frame Analysis, Newton, VBA | Tagged , , , | 30 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

Drawing in Excel 9 – Perspective Projection

Posted on 13/01/2009 by dougaj4

Previous post  Download PlotXYZ-xlsb.zip (XL 2007) Download PlotXYZ-xls.zip (XL 2003 and earlier) The drawing program presented in the previous post in this series has been modified to plot perspective projections of line drawings defined by 3D coordinates of line end points, … Continue reading →

Posted in Drawing, Excel, VBA | 3 Comments