Category Archives: Excel

RC Design Functions 9.0

Posted on 10/08/2022 by dougaj4

The RC Design Functions 9.0 spreadsheet is now available for free download from: RC Design Functions9.zip The main change is update of shear capacity calculations for the latest versions of the Australian codes; AS 3600 and AS 5100. Shear data … Continue reading →

Posted in Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | Leave a comment

Microsoft blocking VBA in downloaded files (or do they?)

Posted on 12/07/2022 by dougaj4

Microsoft announced earlier this year that they would be automatically blocking macros in downloaded Office files (as a security measure), then recently they said they wouldn’t, then yesterday they said they would, but not right now. For more details, plus … Continue reading →

Posted in Computing - general, Excel, UDFs, VBA | Tagged , , | 1 Comment

Installing PyPardiso and speed of Scipy spsolve

Posted on 12/06/2022 by dougaj4

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

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | 4 Comments

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

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