Author Archives: dougaj4

Concrete ULS spreadsheet update

Posted on 10/07/2013 by dougaj4

The ULS Design Functions spreadsheet has been updated with the addition of provision for the Eurocode 2 rectangular stress block.  The new spreadsheet can be downloaded from:  ULS Design Functions.zip (including full open-source code). For more details see: ULS Analysis … Continue reading →

Posted in Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 10 Comments

Sydney Opera House and Peter Rice

Posted on 05/07/2013 by dougaj4

This year is the 40th anniversary of the opening of the Sydney Opera House, and to mark the occasion the ABC and the Sydney Opera House Trust have put together an interactive web site documenting the history of the structure: … Continue reading →

Posted in Bach, Newton | Tagged , | Leave a comment

More from Renbourn and Friends

Posted on 30/06/2013 by dougaj4

For all its faults, Youtube does have some extraordinary material, such as this Danish documentary on the music scene in London’s Soho in 1967. It starts with a very atypical 30’s style duet from Martin Carthy and Dave Swarbrick, followed … Continue reading →

Posted in Bach | Tagged , , , , , | 2 Comments

John Renbourn

Posted on 26/06/2013 by dougaj4

John Renbourn has had the occasional mention here for his work with Bert Jansch and The Pentangle, but to my mind he is really at his best when playing solo, so here is a collection of Youtube clips which exemplify his unique … Continue reading →

Posted in Bach | Tagged | Leave a comment

Using Index() as an array function

Posted on 23/06/2013 by dougaj4

As promised, this post looks at using the Excel built in Index() function to operate on arrays; it also provides a VBA user defined function (UDF), VBIndex, which simplifies working with arrays within VBA, and also provides improved functionality when … Continue reading →

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