Tag Archives: UDFs

Scipy linear algebra functions in Excel

Posted on May 30, 2023 by dougaj4

The file pyLinAlgfuncs3.zip has open source Python code allowing the Scipy linear algebra functions to be called from Excel using the pyxll add-in. It also includes all the Python code to perform LU decomposition, as discussed in the previous post., … Continue reading →

Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | Leave a comment

py_Numpy update and using Numba

Posted on May 11, 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 April 8, 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 April 2, 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 , , , , , , , , , , , , | 2 Comments

ULS Design Functions 2.16

Posted on February 25, 2023 by dougaj4

The ULS Design Spreadsheet has now been updated to Version 2.16, which can be downloaded from: ULS Design Functions The main new feature is the option to design for prestress loads applied to circular tanks. Due to axi-symmetric effects, when … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | 1 Comment