Author Archives: dougaj4

Pale Blue Dot

Posted on 24/05/2024 by dougaj4

34 years ago Carl Sagan presented an image of the Earth taken from outer space, known as the pale blue dot. An event very different from a 13 year old boy singing a song he had written himself, but the … Continue reading →

Posted in Climate, Newton | Tagged , | Leave a comment

Rory Phillips – The Truth

Posted on 13/05/2024 by dougaj4

“‘The Truth’ is a passionate call to action on climate change from 13 year old Rory Phillips. “I wanted to say something with this song. The lyrics are subtle, not in your face; but the message is clear. We need … Continue reading →

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

Creating sequential lists in Excel

Posted on 08/05/2024 by dougaj4

I recently discovered that Excel has a new SEQUENCE function that will return a sequence of increasing numbers in a column, row, or 2D range. Use of the new function is shown in the screenshot below, with some old and … Continue reading →

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

Let, Lambda, and py_Eval

Posted on 21/04/2024 by dougaj4

I have covered the new Excel Let and Lambda functions before at: Two New Functions; Let and Lambda Eval and Let examples Lambda and VBA The Lambda function is now available to all Microsoft 365 subscribers, so I have now looked at … Continue reading →

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

SLS Concrete design with Python

Posted on 13/04/2024 by dougaj4

I am in the process of converting the SLS design related functions in the RC Design Functions spreadsheet to Python code. The current version can be downloaded from: py_RC Elastic.zip For details of the pyxll app required to conect the … Continue reading →

Posted in Concrete, Excel, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , , , | 2 Comments