Author Archives: dougaj4

Scipy linear algebra functions in Excel

Posted on 30/05/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 , , , , , , | 2 Comments

LU Decomposition with Python and Scipy

Posted on 26/05/2023 by dougaj4

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 , , , , , | 2 Comments

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

Two views on VBA

Posted on 28/04/2023 by dougaj4

First from Microsoft: Microsoft are continuing their quest to make downloading spreadsheets with macros ever more difficult, and now any downloaded spreadsheet has VBA code disabled by default. Unblocking the code (if you know and trust the source of the … Continue reading →

Posted in Excel, VBA | Tagged , , , | 3 Comments

Indexing pdf files – update

Posted on 18/04/2023 by dougaj4

My Windows search function recently once again stopped indexing pdf files, probably associated with an upgrade to Windows 11. Previously this was fixed by downloading the file PDFFilter64Setup.msi from the Adobe site, but that download no longer works, and there … Continue reading →

Posted in Computing - general | Tagged , , , , | Leave a comment