Category Archives: Newton

The iccanobiF Sequence

Coincidentally, following the previous post, New Scientist’s regular brain teaser featured the iccanobiF Sequence, which is just like the Fibonacci Sequence, except that after adding the two previous numbers the digits of the results are reversed. Obviously the sequences are … Continue reading

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

Python functools and the Fibonacci Sequence

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

Random numbers, palindromes and Numpy update

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 Data Classes

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

py_RC Design 2

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