Author Archives: dougaj4

Removing Add-ins

Posted on 05/06/2022 by dougaj4

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 … Continue reading →

Posted in Computing - general, Excel, Link to dll, Link to Python, VBA | Tagged , , , , , , | Leave a comment

Australian election results

Posted on 01/06/2022 by dougaj4

Australia now has a new government. Here’s what Billy Bragg thinks about it:

Posted in Bach | Tagged , , | Leave a comment

Getting Excel Solver working

Posted on 21/05/2022 by dougaj4

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 … Continue reading →

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

Listing Python modules and getting help docs from Excel

Posted on 12/05/2022 by dougaj4

Python functions include detailed help documentation but to access this you need the full path to the function, including the names of all code modules and submodules. This post looks at how this information can be found using Excel with … Continue reading →

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

Pint, MPmath and implied units, working with Excel

Posted on 30/04/2022 by dougaj4

Spreadsheets linking to the Python Pint and MPmath libraries have been presented here before at: Units and solvers with Pint and Sympy mpmath for Excel I have now updated the spreadsheet to work with pyxll, and with some new functions and … Continue reading →

Posted in Concrete, Excel, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , , , , | 2 Comments