Category Archives: VBA

The angle between two vectors, in 2D or 3D

Posted on 12/01/2013 by dougaj4

Finding the angle between two lines in 2D is easy, just find the angle of each line with the x-axis from the slope of the line and take the difference.  In 3D it is not so obvious, but it can … Continue reading →

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

Tanh-Sinh Quadrature V4.0

Posted on 03/01/2013 by dougaj4

Since last September Graeme Dennes has continued work on his Tanh-Sinh Quadrature spreadsheet, and has recently released Version 4.0, which can be downloaded from: Tanh-Sinh. As usual, the download includes full open-source code and extensive documentation. The new version includes routines … Continue reading →

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , | 6 Comments

Extending Frame4 with on sheet formulas

Posted on 11/12/2012 by dougaj4

Still on Frame4, Julien asked if provision could be made for application of local loads, i.e. loads perpendicular to sloping members, rather than just horizontal or vertical.  This will actually be incorporated in the spreadsheet “real soon now”, but it … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | Tagged , , , , | 3 Comments

Frame4 Version 3.05; with support displacements

Posted on 06/12/2012 by dougaj4

Hot on the heels of Version 3.04 comes Version 3.05. A few days ago Julien asked if the Frame4 allowed for specified support deflections, to which I replied it would be added in the future.  Searching Google on the topic I … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, VBA | Tagged , , , , | 7 Comments

Frame4 Version 3.04

Posted on 05/12/2012 by dougaj4

In preparation for adding 3D functionality to the Frame4 spreadsheet I have rearranged the load input sheet, and in doing so I noticed that the fixed end reaction calculation was incorrect for cases where loads were applied to one member over … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, VBA | Tagged , , , , | 1 Comment