Author Archives: dougaj4

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

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