Recent Comments
Tag Archives: PyXLL
py_RC Elastic 1.04 and fatigue to AS 3600
The py_RC Elastic spreadsheet (last discussed here) has been updated with a new function py_Fatigue3600, providing design for fatigue to the latest AS 3600 concrete structures code. The new spreadsheet and associated Python code can be downloaded from: py_RC Elastic.zip … Continue reading
Posted in Concrete, Excel, Link to Python, Newton, PyXLL, UDFs
Tagged AS 3600, AS 5100.5, Design for Fatigue, Excel, Python, PyXLL, py_Fatigue, py_Fatigue3600, py_RC Design Functions, Reinforced Concrete, UDFs
1 Comment
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
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 Excel, Fibonacci Sequence, iccanobiF Sequence, Python, PyXLL, UDF's
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 