Author Archives: dougaj4

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

Tanh-Sinh Quadrature via F2PY – Part 3

Posted on 06/02/2016 by dougaj4

For the last of the current series on combining Fortran, Python and Excel with F2PY and ExcelPython I have updated the xlSciPy spreadsheet to include two other variants of the Tanh-Sinh function: Quad_TSi integrates a non-periodic function over a semi-infinite … Continue reading →

Posted in Excel, Fortran, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , , | Leave a comment