Tag Archives: Excel

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

Importing selected rows from a text file

Posted on 29/07/2011 by dougaj4

I was recently asked if the routine in the Text-in2 spreadsheet to import and split data from text files could be modified to only import rows that met specified criteria.  A similar end result can be achieved by importing the whole … Continue reading →

Posted in Excel, VBA | Tagged , , | 8 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