Category Archives: Excel

Lists and Arrays in Excel

Posted on 27/09/2026 by dougaj4

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

Posted on 11/09/2026 by dougaj4

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

Posted on 30/08/2026 by dougaj4

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

py_RC Design with 3D Cache

Posted on 12/07/2026 by dougaj4

Following my recent post on passing 3D arrays from Python to Excel I have now added a py_UmomC function to the py_RC Design spreadsheet. The new spreadsheet and Python code, along with related code, can be downloaded from: py_RC Design.zip … Continue reading →

Posted in Arrays, Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , , , | 2 Comments

VBA polynomial functions update

Posted on 29/06/2026 by dougaj4

Following several comments at an old post I have made updates to the Polynomial spreadsheet. The new files can be downloaded from: Polynomial.zip The changes are: New functions returning real roots only: Updated SolvePoly and SolvePolyR: SolvePoly with an array … Continue reading →

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