Tag Archives: Excel

Python functools and the Fibonacci Sequence

Posted on 19/06/2025 by dougaj4

The Python functools module has been around since 2006, so it’s not exactly new, but it is something I don’t currently use, but with potential to be useful. This link: Functools module in Python provides details and examples of all … Continue reading →

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

Why use the walrus?

Posted on 11/06/2025 by dougaj4

Continuing posts on new Python features, this one looks at the new walrus operator, which was introduced in Python 3.8. For a detailed description see Python Walrus Operator in Python 3.8. This post looks at an example using pyxll to … Continue reading →

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

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

py_RC Design

Posted on 03/05/2025 by dougaj4

The py_RC Design spreadsheet provides Python versions of the reinforced concrete design functions in the RC Design Functions spreadsheet. The current version can be downloaded from: py_RC Design.zip See also: SLS Concrete design with Python for additional SLS design related functions. … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , , , , | 1 Comment