Author Archives: dougaj4

Sydney Opera House and Peter Rice

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

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

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

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

Two new blogs

Two new Excel/computer related blogs that I have found recently are: Useful Gyaan (Sharing Stuff to Make life @ work easier) and MS EXCEL UNPLUGGED (which looks like a good resource on using pivot tables) In the near future I will be … Continue reading

Posted in Arrays, Excel, VBA | Tagged , , , | Leave a comment