Recent Comments
Author Archives: dougaj4
Importing text files with Python and pyxll
VBA code to import text files to Excel was presented at Importing text files with VBA – 2 and following posts. We now look at Python code for a user defined function (UDF) for the same task. The code requires Python … Continue reading
Posted in Computing - general, Excel, Link to Python, PyXLL, UDFs
Tagged Convert string to values, Excel, import text, Numpy, PyXLL, UDFs
Leave a comment
Plotting Carlyle’s Circle with Matplotlib in Excel
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 Carlyle's Circle., Excel, MatPlotlib, Plotting functions, Python, PyXLL, py_EvalU
Leave a comment
3DFrame-py rel. 0.50
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 3D plots, Excel, Frame Analysis, MatPlotlib, Numba, PyPardiso, Python, PyXLL
Leave a comment
Some new (to me) music
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 Bert Jansch, Fry and Laurie, Hugh Laurie, Mary Hopkin, Mr. Dalliard
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 