Author Archives: dougaj4

Scipy solver update

Posted on 31/05/2024 by dougaj4

The py_SolveFS function calls the Scipy optimize.root function to solve multi-variable equations. Examples are found on the py_Solvers spreadsheet, see Scipy Functions with Excel and pyxll 4 – Solvers 2. One problem with using this function is that the input data … Continue reading →

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

Regular Expressions in Excel

Posted on 25/05/2024 by dougaj4

I recently discovered that Microsoft are working on Excel functions to work with Regular Expressions. A beta version is currently available to those on the “insider” program, but this functionality has long been available through VBA, and can also be … Continue reading →

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

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