Category Archives: Arrays

Function to make a list of functions …

Posted on 11/02/2013 by dougaj4

… and other procedures. I wanted to make a list of all the VBA procedures in a workbook, and discovered that Excel doesn’t have a built-in way of doing that.  People have written code to work their way around that of course, … Continue reading →

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

Using Excel’s shortest functions

Posted on 01/01/2013 by dougaj4

Happy New Year to everyone. I’ve been busy working on a 3D version of my frame analysis program (which will be published in the not too distant future), but as things have been a bit quiet here recently, here are … Continue reading →

Posted in Arrays, Excel | Tagged , , , , | 26 Comments

Compiled Matrix Functions for Excel

Posted on 12/11/2012 by dougaj4

This is a follow on from the previous post, showing how the C# version of the ALGLIB maths library can be accessed from Excel, with very little additional coding.  The download file, Matrixdll-c#.zip includes compiled .dll and .tlb files which can be used … Continue reading →

Posted in AlgLib, Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , , | 4 Comments

Mohr’s Circle and Plate Stresses and Actions

Posted on 27/10/2012 by dougaj4

The functions described in this post can be found in the download file PlateStress.zip, including examples and full open source code. The function MCircle returns the plane stress components (XX, YY and XY stress) for any specified stress field, when rotated through a … Continue reading →

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

Daily Download 33: Miscellaneous

Posted on 21/10/2012 by dougaj4

This is the last of the month and a bit of Daily Downloads, and consists of a bumper bundle of 20 spreadsheets with miscellaneous functions that didn’t fit in elsewhere: Repeating a set of data: for instance making three copies of … Continue reading →

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