Author Archives: dougaj4

Announcing Excel Summit South 2016!

Posted on 28/11/2015 by dougaj4

After 2 years of organising, Charles Williams recently announced: EXTEND YOUR SKILLS This is a unique opportunity to: Learn from six of the world’s leading Excel MVP’s as they discuss the Excel topics most useful to you. Hear industry leading … Continue reading →

Posted in Excel | Tagged , , , , , | 1 Comment

Paper bridge

Posted on 27/11/2015 by dougaj4

Making a model bridge out of paper is pretty easy. Making a full size bridge, strong enough to carry a Range Rover, out of just paper takes a bit of doing: It seems the guy who built the bridge (Steve … Continue reading →

Posted in Arch structures, Newton | Tagged , , , | Leave a comment

Importing Text Files; Unix Format

Posted on 10/11/2015 by dougaj4

Text files generated on Unix systems have a different convention to denote the ends of lines to that used on Dos/Windows systems (see Newline for more details).  This was causing problems with the Text-in2 spreadsheet, with small files being imported with … Continue reading →

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

John Renbourn; Trotto and English Dance

Posted on 04/11/2015 by dougaj4

A YouTube video of a live performance of John Renbourn’s English Dance was removed some time ago.  The video below features a different performance, so I hope it survives: And from the same source, a recording of a full concert … Continue reading →

Posted in Bach | Tagged , , | Leave a comment

The VBA Decimal data type

Posted on 26/10/2015 by dougaj4

This is what the Microsoft on-line help says about using the Decimal data type in VBA “” At least that is what the Microsoft search listed for me, and Google listed nothing from Microsoft related to VBA on the first … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , | 4 Comments