Category Archives: NumPy and SciPy

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

LU Decomposition with Python and Scipy

This post was prompted by a question at the Eng-Tips forum: LU Decomposition which asked why Mathcad was generating LU matrices different to those calculated from the basic theory. The short answer was that there is more than one way … Continue reading

Posted in Excel, Finite Element Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , | 1 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 on combined shear and bending design to AS 3600

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

Latex Maths Text in Excel

There have been many posts here looking at alternative ways of working with functions entered as text on a spreadsheet, and working with units, most recently here. One drawback with this approach is that text in an Excel cell must … Continue reading

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