Author Archives: dougaj4

Frame Analysis with Excel 1 – Single beam

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

Apple Numbers 09

A review of the new Apple spreadsheet, with an emphasis on engineering applications, from the “Engineering for the Real World” blog. I don’t think I’ll be changing any time soon, but for Mac users familiar with Apple Script it looks … Continue reading →

Posted in Computing - general | Leave a comment

Lotus Day

As well as being Australia Day, January 26th is also the anniversary of the first release of Lotus 123 (for my younger readers, “Lotus” is what we used to call spreadsheets, before they became “Excel”). Lotus 123 is now 26, … Continue reading →

Posted in Computing - general | Leave a comment

Repeating a set of data

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

More from Davey Graham

I finaly found an uninterupted recording of the “She Moves Through the Fair” variations, rejoicing in the title of: She Moved Thru’ the Bizarre/ Blue Raga Wikipedia has this to say about a Jimmy Page piece called White Summer: “Alleged … Continue reading →

Posted in Bach | Tagged , , | 1 Comment