Author Archives: dougaj4

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

More from Anne Briggs

Posted on 02/02/2024 by dougaj4

A (comparatively) recent YouTube of Anne Briggs from her brief return to public performances in 1990-91: Anne Briggs – The Jim Lloyd Sessions, 1990-91 Anne Briggs made two appearances on Jim Lloyd’s ‘Folk on Two’ during her brief 1990-91 return … Continue reading →

Posted in Bach | Tagged , , , | Leave a comment

Close to it all ..

Posted on 26/01/2024 by dougaj4

The death of Melanie Safka was reported yesterday. She was best known for her work in the late 1960’s and 1970’s, but she continued performing throughout her life. Here is a small selection from her live performances over the years. MELANIE … Continue reading →

Posted in Bach | Tagged , , , , , | 2 Comments

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