Recent Comments
Tag Archives: PyXLL
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 Excel, linear algebra, LUsolve, Python, PyXLL, SciPy
2 Comments
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 Excel, Numba, Numpy, PyXLL, py_Numpy, py_Polyfit, UDFs
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
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
Downloads update
A list of files available for free download can be found under the Downloads link at the top of the page: The list has now been updated and there are now 189 files available for download, most with open source … Continue reading
Posted in Computing - general, Excel
Tagged Download list, Files for download, open source code, Python, PyXLL, VBA, xlwings
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 