Category Archives: Excel

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

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

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

Getting near matches from a list with Python

To return a list of near matches from a long list of strings would be quite difficult in VBA (unless I’m missing something), but in Python it is very simple.  Here is the code for this operation, using pyxll to … Continue reading

Posted in Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , | Leave a comment

Dancing Pendulums Revisited

I have previously posted on Dynamically Defined Dancing Pendulums, using the Strand7 FEA program to generate the motion of a series of pendulums of varying length.  I have now updated that video using the latest Beta version of the program (Rel … Continue reading

Posted in Animation, Finite Element Analysis, Frame Analysis, Newton, Strand7 | Tagged , , , , , | Leave a comment