Category Archives: Arrays

Plotting Charts With Gaps …

Posted on 31/03/2018 by dougaj4

“How do you get VB6 to initialize doubles with +infinity, -infinity and NaN”… and various sorts of Not a Number. Back in 2012 (When is an xy chart not an xy chart) I concluded that it was not possible to … Continue reading →

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

Cubic splines with jagged data

Posted on 07/02/2018 by dougaj4

A cubic spline provides a good approximation to a smooth curve, and alternative versions are available for free download (see Daily Download 22: Splines and Curves, Update to AL-Spline-Matrix, and xlwSciPy 1.09 – update for xlwings 0.10 and Scipy 0.18.1), but if … Continue reading →

Posted in Arrays, Beam Bending, Concrete, Curve fitting, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 2 Comments

Brent’s Method; Update and Examples

Posted on 06/12/2017 by dougaj4

Brent’s Method is a refinement of Newton’s Method for the numerical solution of any equation with one variable.  The User Defined Function (UDF) QuadBrent was described in:  The Inverse Quadratic Method 3 – Brent’s Method Following a recent question, I have … Continue reading →

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

Tables and VBA

Posted on 25/10/2017 by dougaj4

I don’t use Excel Tables much, and not at all from VBA (where they are known as ListObjects), but that should probably change, so here are four links with comprehensive help on using Tables from VBA: The Spreadsheet Guru- VBA … Continue reading →

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

Setting up UDF Applications

Posted on 09/09/2017 by dougaj4

Following a recent comment, this post looks at setting up a user defined function (UDF) on a blank worksheet, using the ConBeamU function as an example. To use a UDF, the VBA code for the function must either be included … Continue reading →

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Newton, UDFs, VBA | Tagged , , , , | 2 Comments