Category Archives: UDFs

Dividing shapes into layers

Posted on 10/05/2014 by dougaj4

For reasons that will become apparent in a later post, I need to rotate irregular polygons, defined by the coordinates of each corner, by a specified angle, and then split the resulting shape into horizontal trapezoidal layers. I have written … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, UDFs, VBA | Tagged , , , , , | 8 Comments

More Sort Functions

Posted on 23/04/2014 by dougaj4

I have recently added three new sorting User Defined Functions (UDFs) to the SortFunc-py spreadsheet, and added a new option to the SortV function.  The new file may be downloaded from SortFunc.zip, including full open source code. The first new function … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , | 2 Comments

ConBeamU Update

Posted on 17/04/2014 by dougaj4

Recently a comment pointed out that if the ConBeam, or ConBeamU, user defined functions were used with a single span then the “Out” argument was ignored, so it was not possible to return support reactions.  This has now been fixed … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , | 18 Comments

Extracting numbers with regular expressions

Posted on 12/04/2014 by dougaj4

Shortly after I wrote about extracting numbers from text strings, Winston Snyder at dataprose.org wrote a detailed article about using “regular expressions” to separate text from numbers in any string.  I have adapted his routine for the same purpose as … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | 19 Comments

Dynamic sorting with Excel, VBA, and Python

Posted on 31/03/2014 by dougaj4

A spreadsheet with User Defined Functions (UDFs) to dynamically sort a range of data has previously been presented here and here. I have now modified the Python version of the UDF for improved functionality, added a second Python function, and … Continue reading →

Posted in Excel, Link to Python, NumPy and SciPy, UDFs, VBA | Tagged , , , , , | 1 Comment