Author Archives: dougaj4

Two exceptional musicians

On Saturday night we were treated to fine performances from two exceptional young musicians.  The first was Stefan Jackiw, performing with The Australian Chamber Orchestra at Angel Place.  Here he is playing a Beethoven piece in 2009: Then after the … Continue reading

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

Baby Names and Pivot Tables

Baby Boom: An Excel Tutorial on Analyzing Large Data Sets is a comprehensive (and free) tutorial looking at analysing public databases of baby names, using Excel: There are professional data analysts out there who tackle “big data” with complex software, … Continue reading

Posted in Charts, Excel | Tagged , , , , , | Leave a comment

Managing Data Using Excel …

… is a new book by Mark Gardener, published by Pelagic Publishing.* It is subtitled “Organising, summarising and visualising scientific data”.  The publishers say of the book: Microsoft Excel is a powerful tool that can transform the way you use … Continue reading

Posted in Charts, Excel, Newton | Tagged , , | Leave a comment

Avoid si Aibohphobia is di ova …

… which loosely translated means, if you have inherited the rare but debilitating condition known as aibohphobia, or fear of palindromes, then read no further, and don’t even think about clicking on the Vimeo video below. Since today (for those of … Continue reading

Posted in Bach | Tagged , , | 2 Comments

xlSciPy 1.01

The xlSciPy spreadsheet, introduced here, has been updated with many new functions.  The new version, including full open source code (VBA and Python) can be downloaded from: xlSciPy.zip The spreadsheet requires Python to be installed, including NumPy and SciPy.  It … Continue reading

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | Leave a comment