Tag Archives: VBA

Using Frame4 for truss analysis

Posted on 21/02/2013 by dougaj4

The Frame4 spreadsheet is set up to allow the analysias of rigid-jointed 2D frames, but it is simple to use it for 2D truss analysis; simply either provide a moment release at each end of every member, or define every member … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | Tagged , , , | 2 Comments

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

3DFrame v1.01

Posted on 03/02/2013 by dougaj4

The 3D frame analysis spreadsheet has been updated to v1.01, with a correction to the calculation of node reactions.  The previous version gave incorrect results for any restrained node at end 2 of any beam. Please download the new version … Continue reading →

Posted in Excel, Frame Analysis, Newton, VBA | Tagged , , , | 2 Comments

Goal Seek Macro for Multiple Sheets

Posted on 30/01/2013 by dougaj4

Following a comment on the Using Goal Seek on Multiple Cells post, I have modified the macro so that the goal-seek ranges can be on a different sheet to the named input ranges.  The new file can be downloaded from: GSeek.zip. … Continue reading →

Posted in Excel, VBA | Tagged , , , | 4 Comments

Precise Angles and XNumbers

Posted on 28/01/2013 by dougaj4

Further to comments by Georg under: The angle between two vectors, in 2D or 3D I have added four alternative ways of calculating the angle between two 3D vectors to the VectorFunc spreadsheet.  The new version can be downloaded from: http://interactiveds.com.au/software/VectorFunc.xlsb. … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment