Author Archives: dougaj4

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

Footsteps of The Incredible String Band

Posted on 25/10/2015 by dougaj4

I just thought I would ask Google who there is playing music these days developing the tradition of the Incredible String Band, and after wading through long lists of 40 year old albums I eventually found: Trembling Bells Sweet Death Polka … Continue reading →

Posted in Bach | Tagged , | Leave a comment

Solving non-linear equations with two or more unknowns – 5

Posted on 20/10/2015 by dougaj4

This will be the last of the series on solving non-linear equations (for now).  Up until now all the examples have had two unknown values, and two target values.  This can be extended by making three changes to the code: … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , , , , , , , | 3 Comments