Tag Archives: UDFs

Scipy linear algebra functions in Excel

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

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

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

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

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