Author Archives: dougaj4

XY Chart problems – 1

Posted on June 12, 2020

I have looked at problems with XY charts displaying as Line charts previously at: When is an XY chart not an XY chart …? and Plotting Charts With Gaps … The charts shown below. and also in the next post, can be … Continue reading →

Posted in Charts, Charts, Excel | Tagged , , | 1 Comment

For Bert Jansch – Around the World in 80 Plays

Posted on May 30, 2020

I have been listening to Pierre le Bras on YouTube for some time, where he plays under the name of Old Picker.  Today a link from there led me to For Bert Jansch , hosted by The Bert Jansch Foundation: Musicians … Continue reading →

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

Building dances to an earthquake’s beat

Posted on May 28, 2020

Adam Pascale from the Seismology Research Centre recently shared this animation (click on controls bottom right for High Quality and Full Screen views): … it’s from a building in the Philippines about 130km (hypocentral distance) from a magnitude 6.1 earthquake … Continue reading →

Posted in Animation, Computing - general, Newton | Tagged , | Leave a comment

More from Malinda …

Posted on May 16, 2020

… and some of her mates, from here and there:

Posted in Bach | Tagged , , | Leave a comment

New sort functions and sorting to groups

Posted on May 16, 2020

I first posted a user defined function (UDF) to sort spreadsheet or VBA data back in 2009.  Finally Microsoft have caught up, and Excel 365 subscribers now have two built in sort functions available: =SORT(array,[sort_index],[sort_order],[by_col]) =SORTBY(array, by_array1, [sort_order1], [by_array2, sort_order2],…) … Continue reading →

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