Author Archives: dougaj4

Copy non-blank rows to another sheet

Posted on 26/07/2013 by dougaj4

A thread at Eng-Tips asked for a way to display the data from Sheet2 on Sheet1, but only the rows that were not blank in Column A. There are probably ways to do it without VBA, but it seems to me … Continue reading →

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

Just discovered – Data Explorer

Posted on 26/07/2013 by dougaj4

Browsing, following up Jeff Weir’s recent comments, led me to a Bacon Bits post about a new add-in from Microsoft called Data Explorer, for importing, transforming and merging data from a wide variety of sources. Follow the Bacon Bits link … Continue reading →

Posted in Excel | Tagged , | 1 Comment

Using RC Design Functions 4 – Umom and new MaxAx function

Posted on 21/07/2013 by dougaj4

Previous post in this series. Download latest version of RC Design Functions6. Previous posts in this series have looked at elastic design functions.  We now move on to functions for ultimate limit state (ULS) analysis of reinforced concrete sections: UMom: … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , , , , | 6 Comments

Concrete ULS spreadsheet update-2

Posted on 17/07/2013 by dougaj4

The concrete ULS design spreadsheet last posted at: Concrete ULS spreadsheet update has been updated to fix a problem encountered with non-symmetrical reinforcement using the Eurocode 2 rectangular stress block. Download from ULS Design Functions. Typical input and output interaction diagram are … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 11 Comments

Rain, Steam and Speed

Posted on 14/07/2013 by dougaj4

Joseph Mallord William Turner and Isambard Kingdom Brunel were the leading British practitioners in their respective fields in the 19th Century.  Their works came together in Turner’s painting “Rain, Steam and Speed”, which depicts Brunel’s Maidenhead Railway Bridge over the … Continue reading →

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