Two recordings of live concerts recently found on You Tube:
Sandy Denny singing Blackwaterside (BBC In Concert – Paris Theatre 16/3/72) :
The Pentangle, three songs recorded in Australia in August 1972:
Recent Comments
Two new old live recordings
Posted in Bach
Tagged Blackwaterside, Light Flight, live recordings, Pentangle, Reflection, Sandy Denny, Solomon's Seal
Leave a comment
Installing PyPardiso and speed of Scipy spsolve
I recently upgraded to Python 3.10, and because of some problems with my previous installation I decided to do a complete new installation using pip, which required installation of all the libraries needed for my various programs.
For my linear algebra functions based on the Scipy library I have also installed PyPardiso which provides substantially better performance than the Scipy functions for solving large sparse systems. As reported here I previously found I had to search for a non-standard conda library for the installation, but this time the latest documentation recommended installation with pip: pypardiso 0.4.1
Since PyPardiso calls the Intel MKL library, I installed this first, so my installation procedure was:
- Install the MKL library: pip install mkl
- Install PyPardiso: pip install pypardiso
Code for using the PyPardiso spsparse function (or optionally the equivalent Scipy.sparse function) can be found at: Installing PyPardiso.
Checking the performance of the equivalent functions, the pyPardiso spsolve function was found to be much faster than the Scipy equivalent, as previously reported at: Making Finite Element Analysis go faster – Update and PyPardiso.
The Scipy sparse.spsolve function was found to have reverted to the slower times reported at: Making Finite Element Analysis go faster … The change in performance is (probably) related to installation of the scikit-umfpack library, which I had not installed at the time of the tests, but even after umfpack is properly installed, the pyPardiso function is much faster than any option with the Scipy function.
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, PyPardiso, Python, PyXLL, SciPy, sparse matrices, sparse solvers
4 Comments
Removing Add-ins
Recently I had problems with an Excel Add-in that was still trying to run, and generating error messages, even after being removed from the add-in list and uninstalled.
After much searching and trying suggested methods that didn’t work, I finally found a method that did work at:
https://stackoverflow.com/questions/1946551/excel-add-in-doesnt-get-the-hint/1946607#1946607
Here are the steps:
- First, remove the addIn from Excel. After removing it, don’t reopen Excel yet
- Go to registry: Start -> Run -> regedit -> HKEY_CURRENT_USER\Software\Microsoft\Office\version\Excel\Options. Delete the registry of the addIn you want to remove. The data column will give you the hint.
- This is the key, remember to restart the computer to reset Excel. If you open Excel before the restart, it will register the AddIn in your registry again and you will need to start all over again
answered Feb 21, 2021 at 3:33
The original question was raised in 2009!
Posted in Computing - general, Excel, Link to dll, Link to Python, VBA
Tagged Add-in problems, Excel, Link to Python, Regedit, Remove add-ins, VBA, Windows registry
Leave a comment
Australian election results
Australia now has a new government. Here’s what Billy Bragg thinks about it:
Getting Excel Solver working
Recently I found that for unknown reasons the Excel Solver add-in was not working. Opening the add-ins list from the Devloper tab showed that it had become deactivated (also accessible from File-Options-Add-ins):
Clicking the Solver check box returned a message that the Solver file cold not be accessed. Several similar problems were reported on Stackoverflow and elsewhere, but none of the suggested solutions worked for me, and a lengthy session with Microsoft support, ending up with reinstalling Office, also had no effect.
I finally discovered that when the Excel add-ins are accessed through File-Options-Addins the dialog box has a list of “inactive add-ins”, then a list of “Disabled Application Add-ins”, which listed the Solver add-in. I was able to remove Solver from the list (leaving it empty), after which it could be enabled in the usual way.
I don’t recall when or how Solver became disabled, but for anyone with a similar problem, checking the disabled add-ins list may provide a simple fix.
Posted in Computing - general, Excel
Tagged Excel, Office 365, Solver add-in, Solver disabled
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 