Author Archives: dougaj4

Two sources of perpetual motion

The buttered cat phenomenon: The pulling-yourself-up-by-your-boot-straps technique:

Posted in Bach | Tagged , , | Leave a comment

Plotting Charts With Gaps …

“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

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

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

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