Category Archives: Excel

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

Rotating Hypercubes

Posted on 25/06/2011 by dougaj4

The discussion of dancing pendulums in javascript at SSSF led onto Rotating Hypercubes, which resulted in this javascript animation by forum regular mollwollfumble: 4D Rotations (click to view in a new window, right click to download javascript file) See the SSSF thread for discussion on … Continue reading →

Posted in Animation, Maths, Newton | Tagged , , , | 5 Comments