Monthly Archives: February 2013

What is VBA good for? …

Posted on 25/02/2013 by dougaj4

… is the name of a Stackoverflow thread that sends a steady trickle of visitors here (thanks to a link posted by Charles Williams of FastExcel).  On a similar theme, Smurf on Spreadsheets has a post entitled “What’s so good … Continue reading →

Posted in Computing - general, Excel, VBA | Tagged , , , | 16 Comments

Bridges Over the Tiber -3

Posted on 24/02/2013 by dougaj4

See Bridges Over the Tiber -1 for location map. The final installment of Bridges Over the Tiber brings us to the six bridges built in the 20 th Century, which can be grouped in three pairs: two copies of the ancient … Continue reading →

Posted in Arch structures, Historic Bridges, Newton | Tagged , , , | Leave a comment

Using Frame4 for truss analysis

Posted on 21/02/2013 by dougaj4

The Frame4 spreadsheet is set up to allow the analysias of rigid-jointed 2D frames, but it is simple to use it for 2D truss analysis; simply either provide a moment release at each end of every member, or define every member … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | Tagged , , , | 2 Comments

5 Year Report

Posted on 18/02/2013 by dougaj4

As in previous years, I have downloaded the statistics for this blog for the previous year, and pasted them into a worksheet. The link to each post is preserved in the spreadsheet, so it makes a convenient index to what … Continue reading →

Posted in Bach, Excel, Newton | Tagged | 3 Comments

Function to make a list of functions …

Posted on 11/02/2013 by dougaj4

… and other procedures. I wanted to make a list of all the VBA procedures in a workbook, and discovered that Excel doesn’t have a built-in way of doing that.  People have written code to work their way around that of course, … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 3 Comments