Author Archives: dougaj4

Plotting Charts With Gaps …

Posted on 31/03/2018 by dougaj4

“How do you get VB6 to initialize doubles with +infinity, -infinity and NaN”… and various sorts of Not a Number. Back in 2012 (When is an xy chart not an xy chart) I concluded that it was not possible to … Continue reading →

Posted in Arrays, Charts, Charts, Excel, UDFs, VBA | Tagged , , , | 7 Comments

More circle fitting options with Scipy

Posted on 17/03/2018 by dougaj4

A comment on the first post on this topic found that the method used did not work well for short arcs of large radius circles.  An example of the problem can be seen in the screen shots below: The function … Continue reading →

Posted in Coordinate Geometry, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , | Leave a comment

Seven -Up

Posted on 06/03/2018 by dougaj4

A very nice version of John Renbourn’s “Seven Up” recently discovered on You Tube:   … which led me to another piece by the same artist: … and a live version of Sweet Potato by Renbourn himself.  

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

Year 10 Report

Posted on 04/03/2018 by dougaj4

Last years’ statistics for this blog are now uploaded to Onedrive, and since this is now 10 years since the blog started, I have also included statistics since the start. The link to each post is preserved in the spreadsheet, … Continue reading →

Posted in Bach, Excel, Newton | Tagged , , | 1 Comment

Elegant proofs – more Pythagoras

Posted on 01/03/2018 by dougaj4

Browsing the Plus Magazine site recently, I was struck the proof of Pythagoras’ Theorem shown in the animation below: Not just because it is an elegant proof, but also because of the author, the 20th President of the United States, … Continue reading →

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