Author Archives: dougaj4

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

Bridges Over the Tiber -2

Posted on 07/02/2013 by dougaj4

See the previous post for location map. Following the construction of the Ponte Sisto in 1473 no more new bridges were built over the Tiber in Rome until 1885, then six were built (or at least started) in six years, seven if … Continue reading →

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

Bridges over the Tiber – 1

Posted on 04/02/2013 by dougaj4

The tourist map of Rome shows 17 bridges over the River Tiber in the central district, dating from 140 BC to 1981.  For those in Rome it makes a pleasant day’s stroll to visit each one, but for those who can’t … Continue reading →

Posted in Arch structures, Historic Bridges, Newton | Tagged , , | 2 Comments

3DFrame v1.01

Posted on 03/02/2013 by dougaj4

The 3D frame analysis spreadsheet has been updated to v1.01, with a correction to the calculation of node reactions.  The previous version gave incorrect results for any restrained node at end 2 of any beam. Please download the new version … Continue reading →

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

Goal Seek Macro for Multiple Sheets

Posted on 30/01/2013 by dougaj4

Following a comment on the Using Goal Seek on Multiple Cells post, I have modified the macro so that the goal-seek ranges can be on a different sheet to the named input ranges.  The new file can be downloaded from: GSeek.zip. … Continue reading →

Posted in Excel, VBA | Tagged , , , | 4 Comments