Author Archives: dougaj4

Plotting Carlyle’s Circle with Matplotlib in Excel

Posted on 25/07/2025 by dougaj4

Recently I happened to read of Carlyle’s Circle, which is a circle that has two intersection points with a parabola on the X axis. See the Wikipedia article for more details: https://en.wikipedia.org/wiki/Carlyle_circle This post looks at the options for plotting … Continue reading →

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

Upgrading plotly (to 6.9.1)

Posted on 19/07/2025 by dougaj4

Today I found that some of my plotly functions were not working, and re-loading the pyxll files returned the message “could not import PySide6.Qtgui pyside6”. Searching for this problem I found: After upgrading PySide6 gives error No module named ‘PySide6.QtWidgets’ … Continue reading →

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

3DFrame-py rel. 0.50

Posted on 14/07/2025 by dougaj4

Following the recent post on the Python lru_cache function (Python functools and the Fibonacci Sequence) I have had a look at using lru_cache in the 3DFrame-py spreadsheet. So far using lru_cache in this code has provided little to no speed improvement, … Continue reading →

Posted in Beam Bending, Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs | Tagged , , , , , , , | Leave a comment

Some new (to me) music

Posted on 11/07/2025 by dougaj4

Hugh Laurie started his career as straight man to Stephen Fry in comedy shows featuring sketches such as: Since then he has had great success as both a comedian and a straight actor, but until recently I had no idea … Continue reading →

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

The iccanobiF Sequence

Posted on 09/07/2025 by dougaj4

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