Author Archives: dougaj4

Excel Dynamic Arrays

Posted on 08/12/2019 by dougaj4

Previews of dynamic arrays in Excel have been available for some time through the “Insider” programme.  They are now being published to general subscribers through Office 365 monthly updates: Further information is given at: Easier array formulas and Dynamic array … Continue reading →

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

Clive James and Pete Atkin

Posted on 30/11/2019 by dougaj4

Following The Barrow Poets, more poetic music from the early 70’s: Clive James finally succumbed to a long illness this week.  He was mainly known for his humorous work on TV and in writing, but he was also a prolific … Continue reading →

Posted in Bach | Tagged , , | Leave a comment

Biaxial bending update

Posted on 21/11/2019 by dougaj4

The reinforced concrete biaxial bending spreadsheet has now been updated: Stress block and capacity reduction factors updated for AS 3600-2018 ACI factors for US customary units used when stress is entered in ksi or psi units Example data updated The … Continue reading →

Posted in Beam Bending, Concrete, Newton | Tagged , , , , , , , , | 35 Comments

International Keyboard Shortcut Day

Posted on 07/11/2019 by dougaj4

Daily Dose of Excel is increasingly inaccurately named these days, but it still contains a wealth of information, and we get a new post on special occasions, such as: International Keyboard Shortcut Day Have a look for all the keyboard … Continue reading →

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

Two Assasinations

Posted on 29/10/2019 by dougaj4

In 1975 John Fahey released an LP including the track “The Assassination of Stefan Grossman”: Stefan Grossman responded in the only way possible, with the assassination of John Fahey: Why John Fahey chose to assassinate Stefan Grossman in the first … Continue reading →

Posted in Bach | Tagged , , | Leave a comment