Author Archives: dougaj4

Random numbers, palindromes and Numpy update

Posted on 09/06/2025 by dougaj4

This post looks at some of the options for generating random numbers in Excel and Python. The code and example spreadsheets can be downloaded from: Updated Numpy files at: py_SciPy.zipCode added to the Pandigital files at: Pandigitals.zip The py_SciPy download … Continue reading →

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

Python Match Case Statement

Posted on 06/06/2025 by dougaj4

The Python match case statement was introduced in Python 3.10. It provides similar functionality to the VBA Select Case statement, but also has additional features. For detailed background with examples see: geekforgeeks – Python Match Case Statement The example below … Continue reading →

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

Python Data Classes

Posted on 18/05/2025 by dougaj4

I have recently been catching up with new Python features, starting with Data Classes which were introduced in Python version 3.7. For information and code examples I have referred to: Data Classes in Python 3.7+ (Guide) at Real Python The … Continue reading →

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

Ashley Hutchings 80th Birthday Bash

Posted on 18/05/2025 by dougaj4

Ashley Hutchings 80th Birthday Bash – Who Knows Where The Time Goes? Encore #2. Kellie While – lead vocal. Richard Thompson – lead guitar. Plus the ensemble. Birmingham Town Hall – 18.04.2025. The lead singer, Kellie While, has appeared here … Continue reading →

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

py_RC Design 2

Posted on 12/05/2025 by dougaj4

Following the previous post, the py_RC Design spreadsheet has been updated with improved versions of the py_UMomp and py_UMomBiax functions. The revised version can be downloaded from: py_RC Design.zip The py_UMomp function is based on the Umom function, with the … Continue reading →

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