Category Archives: Excel

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

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

Excel 2007 performance – Microsoft looking for feedback

Posted on 08/01/2009 by dougaj4

The latest post on the Microsoft Excel Blog is asking for comment on slow performance of Excel 2007, specifically related to VBA: Microsoft Excel Blog I encourage everyone to respond!

Posted in Excel, VBA | Tagged , , , | 1 Comment

Drawing in Excel 8 – scaling and trimming

Posted on 05/01/2009 by dougaj4

Previous Post – Drawing in Excel 7 Download PlotXY-xls.zip (XL 2003 and earlier) Download PlotXY-xlsb.zip (XL 2007) The previous post presented VBA routines to plot drawings in Excel from a series of coordinates, a list of connected points, and a … Continue reading →

Posted in Drawing, Excel, VBA | Tagged , , , , | 3 Comments