Author Archives: dougaj4

Cleaning Data – Sort functions and shortcuts

Back in 2020 I posted here on New sort functions and sorting to groups, looking at using the sort functions to clean data. Revisiting that post I found that the link to the sample spreadsheet was broken, and that is now … Continue reading →

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

Maeve Gilchrist – Beeswing

Maeve Gilchrist is a Scottish harpist who plays a wide variety of musical styles. Here she is with her version of Richard Thompson’s song Beeswing:

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

Lists and Arrays in Excel

I recently learned from MyOnlineTraingHub that Microsoft recently released a new feature allowing lists, arrays, and nested arrays to be stored in single cells. This feature is currently only available on the Beta Channel for Microsoft 365 Insiders, but it … Continue reading →

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

AS 3600 public comment draft and py_RC Design

A draft of the latest update to AS 3600 (the Australian code for concrete structures) was recently published for public comment (now closed). There are many significant changes to design procedures, and I have updated the py_RC Design spreadsheet to … Continue reading →

Posted in Concrete, Excel, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , , , , , | Leave a comment

Brainteaser and Python sets

The ABC Radio web site has a regular Friday brain teaser: If you want to solve the problem yourself, read no further because a spoiler follows! Investigation of the solution to this problem led me to looking at the use … Continue reading →

Posted in Excel, Link to Python, PyXLL, UDFs | Tagged , , , , | Leave a comment