Category Archives: Arrays

Daily Download 13: The ALGLIB maths library and Excel

Posted on 30/09/2012 by dougaj4

Today we move onto maths related downloads, starting with the ALGLIB maths library, which has featured here quite frequently: Original post with link to site: ALGLIB Installing AlgLib with Excel VBA Download files: http://interactiveds.com.au/software/AL-Matrix-xlsb.zip   http://interactiveds.com.au/software/AL-Matrix-xls.zip Linking AlgLib C++ to Excel … Continue reading →

Posted in AlgLib, Arrays, Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , | 7 Comments

When is an XY chart not an XY chart …?

Posted on 05/09/2012 by dougaj4

… and whan is a blank cell not a blank cell? To answer the first one, create a simple XY chart, with a single data range of 7 rows, with a blank row in the middle.  This should display as two … Continue reading →

Posted in Arrays, Charts, Charts, Excel, UDFs, VBA | Tagged , , , , , | 18 Comments

Extracting selected data with array functions.

Posted on 16/06/2012 by dougaj4

This post is in response to a query at the Eng-tips forum asking how to extract selected data from a range, so that the three best scores for each individual could be extracted from a two column Excel table listing multiple individuals, … Continue reading →

Posted in Arrays, Excel | Tagged , | 5 Comments

Using UDFs – Continuous Beam Example

Posted on 03/05/2012 by dougaj4

Recently (well a month ago) a comment was left at Continuous Beams with Shear Deflections asking for a tutorial on how to use the ConBeam User Defined Function (UDF).  In this post I will give detailed instructions for the ConBeam function, but similar … Continue reading →

Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , | Leave a comment

Modifying spreadsheet data with VBA – the quick way

Posted on 25/04/2012 by dougaj4

A question recently came up (here) asking how to speed up the process of scanning a large range of data on one sheet, and wherever a cell had a value of zero, deleting the data in the same cell address … Continue reading →

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