Author Archives: dougaj4

XY Chart problems – 1

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

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

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 …

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

Posted in Bach | Tagged , , | Leave a comment

New sort functions and sorting to groups

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