Author Archives: dougaj4

LinEstGap with non-linear functions

Posted on 14/03/2020 by dougaj4

The LinEstGap user defined function (UDF) allows the built-in Linest function to be used on data with empty cells or hidden rows, returning results that agree with the chart trend-line function, which automatically ignores blank cells and hidden data.  It … Continue reading →

Posted in Arrays, Curve fitting, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , | 4 Comments

DigitGraph Spreadsheet and WebPlot Digitiser

Posted on 03/03/2020 by dougaj4

I have posted here previously a spreadsheet that allows XY data to be extracted from images of graphs, maps or other images of objects in a single plane: How to digitise a scanned image. I have updated the instructions for the … Continue reading →

Posted in Charts, Charts, Computing - general, Curve fitting, Drawing, Excel, UDFs, VBA | Tagged , , , , , | 6 Comments

Katherine Johnson, NASA Legend

Posted on 26/02/2020 by dougaj4

Cartoon by Steve Breen from The San-Diego Union Tribune. More on Katherine Johnson.

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

Microsoft Python Resources

Posted on 24/02/2020 by dougaj4

In addition to the documentation of their software products, Microsoft now have a huge amount of on-line resources of more general content, including: YouTube: Python for Beginners Probably the largest hurdle when learning any new programming language is simply knowing … Continue reading →

Posted in Computing - general, Excel, Link to Python | Tagged , , , | Leave a comment

Paul Kelly and Joni Mitchell

Posted on 08/02/2020 by dougaj4

Leading Australian singer-songwriter Paul Kelly is about to release a powerful new single that tackles Australia’s lack of action on climate change and environmental destruction. Entitled Sleep, Australia, Sleep, Kelly says the song is both “a lament in the form … Continue reading →

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