Category Archives: UDFs

Download Problems

Posted on 19/03/2024 by dougaj4

Update 24th March 2024: The certificate problem has now been fixed, and most download links should now work without a problem. Note that any file with VBA code (which is almost all of them) will have the VBA blocked with … Continue reading →

Posted in Computing - general, Excel, Link to dll, Link to Python, Python Pandas, PyXLL, UDFs, VBA | Tagged , | 1 Comment

Solving the 4 point lift problem …

Posted on 10/03/2024 by dougaj4

… with Excel, Python and pyxll. The problem involves the lifting of a precast concrete panel (or any other long thin object) with lifting points at four sections along the length of the panel, and with the load connected to … Continue reading →

Posted in Concrete, Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs | Tagged , , , , , , , | Leave a comment

Extracting and counting factors with Python and Numba

Posted on 24/02/2024 by dougaj4

This post features code using the pyxll add-in to call Python code from Excel. See pyxll for more details and downlod. A recent issue of New Scientist had a series of puzzles finishing with: how many integers between 1 and … Continue reading →

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

ULS Concrete design with Python

Posted on 11/02/2024 by dougaj4

The py_UMom and py_ULS Design Functions have now been updated and can be downloaded from: py_UMom.zip py_ULS Design Functions More details of the two spreadsheets can be found at Python Code Updates – py_UMom and ULS Design Functions – Python version. The … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , , , , | Leave a comment

Scipy Functions with Excel and pyxll 9 – Special, distance, space and constants functions and FFT

Posted on 08/01/2024 by dougaj4

In the final post in this series I will look at linking Excel to the Scipy special, distance, space and constants functions and also the Fast-Fourier Transform (FFT) functions. The py_Special-Dist and py_FFT spreadsheet, with associated Python code in PythonSpaceFuncs3.py … Continue reading →

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