Category Archives: PyXLL

py_Numpy update and using Numba

Posted on 11/05/2023 by dougaj4

The py_Numpy spreadsheet presented at Calling Numpy polynomial functions from Excel has had a minor upgrade to the py_Polyfit function, which was previously returning an error message if the optional “full” argument was set to False. The new version can be … Continue reading →

Posted in Curve fitting, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | Leave a comment

More long numbers with Python

Posted on 08/04/2023 by dougaj4

In A not so easy problem I looked at using Python with Excel (via pyxll) to work with very long integers, using the MPMath package. For high precision calculations involving decimal values MPMath is required, but for simple operations entirely … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, PyXLL, UDFs | Tagged , , , , , | 1 Comment

ULS Design Functions – Python version

Posted on 02/04/2023 by dougaj4

I have now converted my ULS Design Functions spreadsheet (last presented here) to Python. The new spreadsheet and open source Python code can be downloaded from: py_ULS Design Functions The spreadsheet has the same functionality as the VBA version, providing … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , , , , , , , , | 3 Comments

A not so easy problem

Posted on 12/03/2023 by dougaj4

A seemingly simple problem was posted in my Quora feed: or to put it more mathematically, what three positive integers satisfy the equation: It turns out the answer is not so simple. A full and detailed derivation can be found … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, PyXLL, UDFs | Tagged , , , , | 1 Comment

More on combined shear and bending design to AS 3600

Posted on 15/12/2022 by dougaj4

Further to the last post on this subject I have been looking at procedures to speed up design for shear to AS 3600 when the “refined” analysis procedure is used. The issues that need to be addressed are: I have … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , | 4 Comments