Category Archives: Computing – general

New Links

Posted on 29/03/2025 by dougaj4

My Blogroll (bottom of the right-hand column) is badly in need of updating, but the link below has a list of 60 currently active Excel blogs and websites: 60 Best Excel Blogs and Websites in 2025 Those at the top … Continue reading →

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

What to do when download links don’t work

Posted on 19/01/2025 by dougaj4

Many of the download links here in older posts use the format http:// rather than https://, and these links now don’t work in Windows. If you find a non-working download link, here is what you can do:

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

High definition Mandelbrot

Posted on 15/06/2024 by dougaj4

There have been several posts here about generating animations of the Mandelbrot set, most recently at Display Matplotlib animations in Excel, but using standard 64 bit floats you rapidly run out of precision. However, using arbitrary precision arithmetic, and with sufficient … Continue reading →

Posted in Bach, Computing - general, Newton | Tagged , , , | Leave a comment

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

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