Author Archives: dougaj4

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

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

Scipy Functions with Excel and pyxll 8 – Statistics

Posted on 05/01/2024 by dougaj4

This post looks at linking Excel to the Scipy and Pandas statistics functions using pyxll. The py_Stats spreadsheet, with associated Python code in PythonStatsFuncs3.py and pyScipy3.py, are included in the download file: py_SciPy.zip Details of the required pyxll package (including … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, Python Pandas, PyXLL, UDFs | Tagged , , , , , , , , | 1 Comment