I have covered the new Excel Let and Lambda functions before at: Two New Functions; Let and Lambda Eval and Let examples Lambda and VBA The Lambda function is now available to all Microsoft 365...
https://newtonexcelbach.com/2024/04/21/let-lambda-and-py_eval/
I am in the process of converting the SLS design related functions in the RC Design Functions spreadsheet to Python code. The current version can be downloaded from: py_RC Elastic.zip For details...
https://newtonexcelbach.com/2024/04/13/sls-concrete-design-with-python/
The RC Design Functions spreadsheet has now been updated to Version 9.06, and is available for free download from: RC Design Functions9.zip The new version fixes a problem with the MomcurveTS fun...
https://newtonexcelbach.com/2024/03/30/rc-design-functions-9-06-momcurve-functions-update/
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 ...
… 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, ...
https://newtonexcelbach.com/2024/03/10/solving-the-4-point-lift-problem/
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 ...
https://newtonexcelbach.com/2024/02/24/extracting-and-counting-factors-with-python-and-numba/
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 Upda...
https://newtonexcelbach.com/2024/02/11/uls-concrete-design-with-python/
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 Ll...
https://newtonexcelbach.com/2024/02/02/more-from-anne-briggs/
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...
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 current...
https://newtonexcelbach.com/2024/01/14/new-groupby-and-pivotby-functions/