Author Archives: dougaj4

Using conditional formatting with array formulas

Posted on August 17, 2019

A recent Quora question asked “How do I highlight the number closest to an initial number in a row in Excel?“.  The answer by Bill Jelen provides a good example of using conditional formatting with an array formula: In my … Continue reading →

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

64 bit Excel and the Strand7 API

Posted on August 13, 2019

Back in May 2017 I posted a sample spreadsheet using the Strand7 API to allow Excel to read and write Strand7 node data and results.  A comment noted at the time that the spreadsheet was not working with 64 bit … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7 | Tagged , | Leave a comment

64 bit Excel and PtrSafe

Posted on July 31, 2019

Installing my Office 365 subscription on a new computer I discovered it had decided (without asking) to upgrade itself to the 64 bit version, which resulted in some of my spreadsheets not working on the new system.  The main problem … Continue reading →

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

Concrete 2019

Posted on July 8, 2019

The Concrete Institute of Australia’s biennial conference is this year being held in Sydney from 8-11 September, and early-bird registration has now been extended to 15th July, so register now and save! For more details of the conference see: Concrete … Continue reading →

Posted in Concrete, Newton | Tagged , , , | 2 Comments

Installing Adobe Reader non-DC version.

Posted on June 26, 2019

The option to install a non-DC version of Adobe Reader used to be hidden away under a menu on the DC installation screen.  It seems that Adobe would really, really like you to use the DC version, because the other … Continue reading →

Posted in Computing - general | Tagged , , | Leave a comment

Solving the Lagrangian Point equation for the Moon

Posted on June 23, 2019

This post was prompted by a recent question at Fitting high order polynomials, asking for Excel methods to solve the equations for the radius of the Moon’s Lagrangian Point 1. All the methods described in this post have been added to … Continue reading →

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

Malinda sings A Song About Nothing

Posted on June 18, 2019

Malinda Kathleen Reese mostly sings popular songs, after passing the lyrics through Google Translate multiple times. But this is something else:

Posted in Bach | Tagged , , | Leave a comment