Category Archives: UDFs

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

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