Recent Comments
Tag Archives: Excel
The Conjugate Beam Method
The Conjugate Beam Method is a variation of the Moment-Area Method that allows beam slopes and deflections to be calculated purely from the calculation of shear forces and bending moments of the beam with (in some cases) modified support conditions. Both methods were … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton
Tagged Beam deflections, Conjugate Beam Method, Excel, Mohr
6 Comments
3D Frame analyses with spring releases – 2
The latest version of the 3DFrame spreadsheet (previously presented here) includes provision for spring end releases, allowing for either rotational or translational springs in any direction. These springs are now incorporated in the model by adjustment of the beam properties, … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged 3D frame analysis, Excel, moment release, spring end release, Strand7, VBA
Leave a comment
Transferring and converting strings in Excel and Python
The load table for the 3D Frame spreadsheet has a column listing the global axis for each load as text (X, Y, or Z). In the VBA version the table is converted to a variant array, and the axes are handled … Continue reading
Posted in Excel, Link to Python, Newton, NumPy and SciPy, VBA
Tagged Excel, map, Numpy, ord, Python, String functions, upper, VBA, xlwings
Leave a comment
3D Frames, axes and stiffness matrices
In the course of adding provision for spring end releases to the 3DFrame spreadsheet, I have also tidied up the code for generating the structure stiffness matrix, and added some documentation to the spreadsheet. The revised spreadsheet (version 2.02) can … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged 3D frame analysis, 3D stiffness matrix, Excel, global axes, local axes, moment release, spring end release, Strand7, VBA
10 Comments
More on Lookups
Following my recent post on nearest lookups, I came across a post from Charles Williams on the opposite problem; how to do an exact VLookup on a large amount of data without taking all day, but still retaining the ability to return … Continue reading
