Author Archives: dougaj4

Free and Simple Tools for Editing Videos

Posted on 08/04/2022 by dougaj4

I recently needed to extract 15 minutes from a 45 minute long video, in 5 separate clips. I discovered that there are free tools to do this simply and efficiently, although they are not widely advertised. Here’s how: By default, … Continue reading →

Posted in Bach, Computing - general, Newton | Tagged , , , | 2 Comments

Python functools – cache and lru_cache

Posted on 01/04/2022 by dougaj4

Update 3rd April 2022: Following the comment from Larry Schuster I have modified the code so that the factorial0 function actually uses cache as intended, rather than lru_cache. I also added code to clear the cache after each timer run, … Continue reading →

Posted in Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , , , | 3 Comments

More Matplotlib problems

Posted on 23/03/2022 by dougaj4

Following an upgrade to some Python libraries, I found that problems with plotting from Matplotlib causing Python to crash were recurring (previously reported here). When called from Excel with pyxll this was also causing instant crashes of Excel. I eventually … Continue reading →

Posted in Excel, Link to Python, PyXLL | Tagged , , , , , | 3 Comments

Transatlantic Sessions and Sarah Jarosz

Posted on 17/03/2022 by dougaj4

Transatlantic Sessions (Wikipedia tells me) is the collective title for a series of musical productions by Glasgow-based Pelicula Films Ltd, funded by- and produced for BBC Scotland, BBC Four and RTÉ of Ireland. The productions comprise collaborative live performances by … Continue reading →

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

VBA procedures for the Numerical Analysis of Tabular Functions

Posted on 12/03/2022 by dougaj4

Long time on-line friend Alfred Vachris has recently been converting Fortran code developed through his working career into VBA: I had the opportunity to work at Grumman while going to Graduate School and they gave me a part-time job as … Continue reading →

Posted in Coordinate Geometry, Curve fitting, Excel, Fortran, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 1 Comment