Tag Archives: Excel

Displaying range names

Posted on 28/04/2014 by dougaj4

A useful tip, brought to you from Bob Umlas, via Mike Alexander: If you want to display the named ranges in a spreadsheet, one way is to open the Name Manager (from the Formulas ribbon).  Another is to press F3, … Continue reading →

Posted in Excel | Tagged , , | 1 Comment

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