Category Archives: Arrays

ConbeamU Update; defined support deflections

Posted on 03/04/2015 by dougaj4

As promised in a recent post, I have updated the ConBeamU spreadsheet to allow defined deflections to be specified at any support. The new spreadsheet (including full open-source code), can be downloaded from ConBeamU.zip In addition to the support deflections the … Continue reading →

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

Slicing Arrays with VBA

Posted on 20/02/2015 by dougaj4

A recent comment asked about the most efficient way to write part of an array to the spreadsheet from VBA. This post looks at three alternative methods which have advantages in different circumstances (thanks to Lori Miller for reminding me … Continue reading →

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

Working with array functions

Posted on 10/12/2014 by dougaj4

Regular visitors will know that I make frequent use of User Defined Functions that return an array of data, and need to be entered as an array function. This has the advantages that the functions are very flexible in the … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | Leave a comment

Extracting numbers from text and regular expressions

Posted on 30/11/2014 by dougaj4

Daily Dose of Excel recently had a post on extracting a number from a specified position in a text string, using mega-in-sheet-formulas like: This reminded me of a post from earlier this year, which provided a User Defined Function (UDF) … Continue reading →

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

Solving polynomials – update

Posted on 14/08/2014 by dougaj4

The polynomial spreadsheet (details here) provides functions to solve polynomial equations of any order; using an “exact” method for up to quartic, and an iterative procedure for higher orders.  The input for the functions requires the equation coefficients to be … Continue reading →

Posted in Arrays, Excel, Maths, UDFs, VBA | Tagged , , , , , | 1 Comment