Author Archives: dougaj4

Clearing excess formats

Posted on 16/03/2013 by dougaj4

I have recently been getting messages about “too many different cell formats”, particularly when saving  a 2007/10 format file as Excel 97-2003 format.  Some searching revealed that the source of the problem was a bug that caused unused styles to be copied when … Continue reading →

Posted in Excel | Tagged , , | 6 Comments

what Microsoft think VBA is good for …

Posted on 06/03/2013 by dougaj4

The front page of Excel for Developers now has a link entitled VBA, which takes you to: VBA for Excel developers which has a link entitled When to use VBA and why which says: There are three principal reasons to consider VBA … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , | 9 Comments

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