Author Archives: dougaj4

Binary functions, combining text, and finding unique columns

Posted on 30/09/2014 by dougaj4

I recently had an e-mail request asking for a method of finding unique columns in an Excel table consisting of either blank cells or an entry of 1.  An easy way to do this would be to convert the columns to … Continue reading →

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

Pictures of Sicily

Posted on 27/09/2014 by dougaj4

Trapani and Erice Segesta, and Mozia  

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

Another WW1 story

Posted on 18/09/2014 by dougaj4

From the Youtube link: I don’t mean to infringe on copyrights of artists, especially not respected ones like the Incredible String band, but I felt I should publish this track because of the strange tale attached to its origins. A … Continue reading →

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

More on Long Lost

Posted on 16/09/2014 by dougaj4

This weekend was shooting for my daughter’s short film “Long Lost” at Callan Park in Sydney. The film is based on the story of a French soldier, but coincidentally there was an Australian soldier who went through the same ordeal … Continue reading →

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

Run Fortran from Excel with Python and F2Py

Posted on 15/09/2014 by dougaj4

I have previously posted on the use of the Silverfrost Fortran compiler with Excel (e.g. Linking Excel to Fortran).  More recently I have been concentrating on accessing high performance compiled routines via Python and the Python maths and science libraries … Continue reading →

Posted in Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to Python, Maths, Newton | Tagged , , , , , , , , | 6 Comments