Author Archives: dougaj4

Geometry for Joiners

A question came up on the ABC Self-Service-Science Forum, asking for a solution to find the dimensions of a diagonal brace looking like the diagram below: The solution is not as simple as it might look because the angle of … Continue reading

Posted in Coordinate Geometry, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 1 Comment

Another Post About Everything

We had a post about everything from xkcd before, but this one is a bit more sophisticated.  You can zoom in from this: down to this: and everything in between, at HTwins.net (if you get an ad for a game, click on … Continue reading

Posted in Newton | Tagged , | Leave a comment

All men will be sailors then, until the sea shall free them

The YouTube video of A Sailor’s Life by the Fairport Convention contains the image shown below: I have just discovered that the words are taken from the Leornard Cohen song Suzanne, but of the origin of the image I have … Continue reading

Posted in Bach | Tagged , , , , , | 1 Comment

Writing Arrays to the worksheet – VBA function

Previous posts have looked at the VBA code for efficiently writing a VBA array to the spreadsheet as quickly as possible, most recently here. I have now put this code in a function that can be conveniently called from any … Continue reading

Posted in Arrays, Excel, VBA | Tagged , , , , | 17 Comments

More from the Former Love …

… with video directed by Kerinne Jenkins (Click on Vimeo to visit site, or click play, then full screen button: Dancing in Silence – The Former Love from Kerinne Jenkins on Vimeo.

Posted in Bach, Films | Tagged , , , | 1 Comment