Author Archives: dougaj4

Making Finite Element Analysis go faster – Update and PyPardiso

The previous post on this topic looked at the performance of alternative Scipy sparse equation solvers. This post updates those results with the current Scipy version (1.7.1), with very different results. It also compares the Scipy solver performance with the … Continue reading

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

Upgrade to Python 3.10?

Python 3.10 was released on October 4th, rapidly followed by a new release of pyxll (5.3.0), but the Anaconda site does not seem to have it yet, so is it time to upgrade or not. A search on that question … Continue reading

Posted in Excel, Link to Python, PyXLL | Tagged , , | Leave a comment

Steeleye Span Live

Two recent additions to You Tube with live performances from the early days of Steeleye Span: This has been a fun little restoration project. My friend and music journalist Simon Jones handed me an old VHS tape recently. On it … Continue reading

Posted in Bach | Tagged , , | Leave a comment

ConbeamU update

I recently discovered that the continuous beam function from the ConbeamU spreadsheet was giving incorrect results for cantilevers at the left hand end, if the cantilever had more than one segment and no point loads. The corrected version (Rel 4.16) … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , , , | Leave a comment

Fast Search Reminder

A recent comment at Opening and searching pdf files from Excel reminded of the linked spreadsheet, which allows pdf files to be opened at a specified page from Excel, and also fast searches of the local hard drive: PdfLink.zip (free download … Continue reading

Posted in Computing - general, Excel, VBA | Tagged , , , , , | 2 Comments