Tag Archives: VBA

Extracting numbers from text strings

Posted on 07/12/2013 by dougaj4

There is often a need to extract numbers from the start or end of text strings.  It’s not too hard to do with on-sheet formulas, but after having done it a few thousand times I decided it would be worth … Continue reading →

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

Moving Load Spreadsheet – update and how to use

Posted on 03/12/2013 by dougaj4

As noted in the comments on the previous post on this topic, the moving load function (and also the associated continuous beam functions) have been modified to make data entry more flexible; the output results are unchanged.  The modified spreadsheet … Continue reading →

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

Unit aware continuous beam spreadsheet update

Posted on 22/11/2013 by dougaj4

The ConbeamU spreadsheet provides Excel user defined functions (UDFs) for the analysis of continuous and simply supported beams and cantilevers using Macaulay’s method.  It allows complex combinations of any number of partial distributed loads, point loads and moments, with changes … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , , | 1 Comment

Selecting Ranges from a UDF

Posted on 20/11/2013 by dougaj4

In the process of tidying up the ConBeamU spreadsheet (which will be posted here in the next few days) I decided to revise the routine for converting input ranges to arrays.  The input for the continuous beam analysis functions consists … Continue reading →

Posted in Excel, UDFs | Tagged , , , | 3 Comments

Python for VBA users- 6; Using Pysparse with Excel

Posted on 29/10/2013 by dougaj4

Previous Python Post The analysis of structural frames requires the solution of large sparse matrix systems, which rapidly becomes very time consuming using a VBA based solver, especially for 3D analysis.  I have previously presented versions of my frame analysis … Continue reading →

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, VBA | Tagged , , , , , | 1 Comment