Category Archives: Excel

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

New GROUPBY and PIVOTBY functions

Posted on 14/01/2024 by dougaj4

Microsoft recently announced two new functions that provide similar functionality to pivot tables, but will update automatically for any change in the referenced data. These functions are currently rolling out to users enrolled in the beta channel for Windows Excel and Mac Excel. … Continue reading →

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