Category Archives: Arrays

Non-linear Frame Analysis – Scipy solvers

Posted on 11/09/2016 by dougaj4

The frame analysis spreadsheet presented in the previous post has been updated to use the solvers included in the Scipy package.  There is now an option to use either the Cholesky solver, or an iterative sparse solver.  The main advantages of … Continue reading →

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

RC Design Functions update

Posted on 21/05/2016 by dougaj4

Following a comment here I have updated my RC Design Functions spreadsheet, which is available for free download (including full open-source code) from: RC Design Functions7.zip The main new features in the latest version are: The existing optional “depth” argument has … Continue reading →

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

Worksheetfunction.Transpose – changed behaviour in Excel 2013 and 2016

Posted on 01/01/2016 by dougaj4

It is (fairly) well known that when using Worksheetfunction.Transpose on an array in VBA the array must be no more than 65,536 (2^16) rows long, or it will return an error. Recently when using Excel 2016 (32 bit) I thought … Continue reading →

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

Time to Lookup

Posted on 27/04/2015 by dougaj4

At Daily Dose of Excel Jeff Weir has been looking at alternative methods of applying the VLookup function and ways of getting precise timing of the different formulations. Based on his posts there I have written two Lookup User Defined … Continue reading →

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

Re-sizing Array Functions

Posted on 14/04/2015 by dougaj4

The recent updates to the ConBeamU spreadsheet contained two new functions for entering and re-sizing array functions, and since they will be useful on any spreadsheet containing array functions (which here means almost all of them) I thought they deserved … Continue reading →

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