Author Archives: dougaj4

Two forks in the Celtic path

Posted on 14/01/2018 by dougaj4

Re-visiting the Steeleye Span version of Tam Lin lead me to two very different musical groups that I had not heard of before: Anaïs Mitchell is an American singer-songwriter and musician, here performing another version of Tam Lin with Jefferson Hamer: … Continue reading →

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

Evaluating text with units and finding the neutral axis

Posted on 07/01/2018 by dougaj4

A few weeks ago a comment asked for guidance on finding the moment capacity of a reinforced concrete section.  This post will look at finding the depth of the neutral axis (NA) in a rectangular section, with a single layer of … Continue reading →

Posted in Beam Bending, Concrete, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , | 7 Comments

On not using Hungarian Notation, and VBA shortcuts

Posted on 01/01/2018 by dougaj4

In June this year Michael Alexander at Bacon Bits had a post on using Hungarian Notation (or not).  It contained the following quote from Stackoverflow, which for me sums up excellently a good reason for not using it: “vUsing adjHungarian nNotation vMakes … Continue reading →

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

The Countif bug (and how to avoid it)

Posted on 22/12/2017 by dougaj4

The Countif function counts the number of cells in a range that match some criterion.  If we enter 1,2,3 in cells A1:A3 and enter =COUNTIF($A$1:$A$3,A1) somewhere else, it will return 1: But if we enter three text strings with 16 … Continue reading →

Posted in Computing - general, Excel | Tagged , , , , , | 2 Comments

Excel Uservoice and Python for Excel

Posted on 18/12/2017 by dougaj4

The Excel Uservoice site is a forum for users to post suggestions for improvements to Excel.  A suggestion to add native Python support to Excel, as a replacement to VBA, has had by far the most votes since the start, and … Continue reading →

Posted in Computing - general, Excel, Link to Python, VBA | Tagged , , , , | 1 Comment