Author Archives: dougaj4

Numerical Integration; Tanh-Sinh Quadrature v. 4.3

Posted on 29/12/2014 by dougaj4

A new version (4.3) of the numerical integration spreadsheet by Graeme Dennes is now available for download from Tanh_Sinh Quadrature. The Tanh-Sinh Quadrature Version 4.3 workbook now provides a feature for the integration of integrands contained in independent (external) UDFs. … Continue reading →

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , , | 6 Comments

More from Martin Simpson

Posted on 23/12/2014 by dougaj4

“Never any Good” A beautiful song by Martin Simpson about his father, who he clearly did not see in the way the title might suggest: Martin Simpson – Never Any Good Lyrics You were never any good with money. You … Continue reading →

Posted in Bach | Tagged , | Leave a comment

Three spoonfuls of Martin Simpson

Posted on 21/12/2014 by dougaj4

According to Wikipedia, “Martin Simpson is regarded by many as one of the most skilled folk guitarists currently playing on the British and American folk scene”, with which my only disagreement would be that to characterise his music purely as … Continue reading →

Posted in Bach | Tagged , | Leave a comment

Numpy and Scipy for Excel

Posted on 14/12/2014 by dougaj4

The Python Numpy and Scipy libraries contain a huge number of maths and science related functions.  Most of these are not directly available from Excel, but using the free ExcelPython package it is fairly easy to make the link, vastly increasing … Continue reading →

Posted in Excel, Link to Python, Maths, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | 11 Comments

Working with array functions

Posted on 10/12/2014 by dougaj4

Regular visitors will know that I make frequent use of User Defined Functions that return an array of data, and need to be entered as an array function. This has the advantages that the functions are very flexible in the … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | Leave a comment