Author Archives: dougaj4

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

Larkin Poe

Posted on 11/03/2022 by dougaj4

Larkin Poe is an American roots rock band originally from north Georgia, currently based in Nashville, Tennessee,[1] and fronted by sisters Rebecca Lovell (born January 30, 1991) and Megan Lovell (born May 12, 1989). Featuring strong southern harmonies, heavy electric guitar riffs, and slide guitar, they are … Continue reading →

Posted in Bach | Tagged | Leave a comment