Author Archives: dougaj4

Cubic splines with descending x

Posted on 01/03/2016 by dougaj4

In response to a recent comment, I have modified the CSpline2 spreadsheet so that the CSplineA and CHSplineA functions will accept x values list in descending order, as well as ascending.  For more details of the background to the functions, … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | Leave a comment

8 Year Report

Posted on 29/02/2016 by dougaj4

Last years’ statistics for this blog are now uploaded to Onedrive. The link to each post is preserved in the spreadsheet, so it makes a convenient index to what has been posted over the year, and what people are looking at … Continue reading →

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

Spreadsheets all the way down

Posted on 22/02/2016 by dougaj4

If you need another reason to attend Excel Summit South, watch this video, and discover that mobile phones are spreadsheets all the way down.    

Posted in Excel, Maths, Newton | Tagged , , | Leave a comment

Why I’m going to Excel Summit South. (And why you should too).

Posted on 20/02/2016 by dougaj4

I was going to write a reminder about the Excel Summit South, but Jeff Weir beat me to it, and since his version is way more entertaining than mine was going to be, pop over and find out why Jeff … Continue reading →

Posted in Computing - general, Excel, VBA | Tagged , | 2 Comments

Use Matplotlib from Excel with xlwings

Posted on 14/02/2016 by dougaj4

Xlwings is another free and open source package allowing communication between Excel and Python.  It now incorporates ExcelPython, and is included in the Anaconda Python package, so will support my ExcelPython based spreadsheets after installation of xlwings using: conda install … Continue reading →

Posted in Drawing, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, VBA | Tagged , , , , , , | 9 Comments