Tag Archives: UDF

Dots and Crosses

Posted on 21/08/2011 by dougaj4

The comments from Bill Harvey in the previous post prompted me to have a closer look at the functions available in Excel for working with vectors.  Here is a complete list of them: =SUMPRODUCT() (Equivalent to the vector dot product) This … Continue reading →

Posted in Arrays, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 11 Comments

Section Properties from Coordinates Without VBA

Posted on 07/08/2011 by dougaj4

At the Eng-Tips forum there was a question asking for a calculation of area and centroid values from coordinates without the use of VBA.  In my opinion using VBA is much the easiest and most robust way to do it, … Continue reading →

Posted in Coordinate Geometry, Excel, Newton, UDFs, VBA | Tagged , , , , , | 13 Comments

Debugging VBA – 2

Posted on 11/07/2011 by dougaj4

Following on from the opening post in this series (Debugging VBA) I will now look at the main debugging tools provided in the Visual Basic Editor (VBE): The Immediate Window allows interaction with the code while it is running.  In the … Continue reading →

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

Using LatPilePY

Posted on 09/07/2011 by dougaj4

LatPilePY is a User Defined Function (UDF) used to analyse the deflections and load actions in laterally loaded piles.  It was presented in this post: LatPilePY.  In response to an e-mail request, this post will give step by step instructions for … Continue reading →

Posted in Arrays, Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , , | Leave a comment

Debugging VBA …

Posted on 22/06/2011 by dougaj4

… especially User Defined Functions (UDF’s). This post (and most likely several to follow) was prompted by a recent discussion at Daily Dose of Excel about various alternative debugging techniques.  It reminded me (if I had ever known) of the Debug.Assert … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , | 2 Comments