Category Archives: VBA

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

Transfer of arrays to/from Python with Pyxll – Part 2; Speed

Posted on 22/03/2014 by dougaj4

Following the previous post, which looked at the way different data types worked when transferring data between Excel and Python, this post looks at ways t0 get the best performance. As a benchmark I have used a short routine that: … Continue reading →

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

Transfer of arrays to/from Python with Pyxll – Part1; Data Types

Posted on 16/03/2014 by dougaj4

This post will look at options for transferring arrays between Excel and Python using Pyxll, including data types, and problems associated with transferring mixed data types.  In the following post I will look at the relative performance of the various … Continue reading →

Posted in Arrays, Excel, Link to Python, VBA | Tagged , , , , | 2 Comments