Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Daily Download 5: Frame Analysis
- The angle between two vectors, Python version
- Daily Download 4: Continuous Beam Analysis
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Downloads
- Installing Python, Scipy and Pyxll
Recent Comments
Category Archives: Frame Analysis
Beam geometric non-linear effects
A quick and convenient way to allow for the effect of deformations on the behaviour of beams and columns under axial load is to adjust the beam stiffness matrix, so that the calculated deflections are in equilibrium with the applied … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged Euler buckling, Excel, Frame Analysis, Non-linear geometry, Second order effects, UDF, VBA
5 Comments
Frame Analysis Resources
I recently discovered: Matrix Structural Analysis, 2nd Edition, by McGuire, Gallagher, and Ziemian. which is available for free download: Description The aims of the first edition of Matrix Structural Analysis were to place proper emphasis on the methods of matrix … Continue reading
Posted in Finite Element Analysis, Frame Analysis, Newton
Tagged Frame Analysis, free download, MASTAN2
1 Comment
Section Properties with MeshPY, including torsion and warping
I recently discovered robbie van leeuwen’s structural engineering blog, which has an open-source set of Python routines for calculation of section properties, including torsion and warping constants. The program uses the MeshPY Library for generating the finite element meshes required … Continue reading
Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Strand7, UDFs, VBA, xlwings
Tagged Excel, MatPlotlib, MeshPY, Python, section properties, Torsion, UDF, VBA, Warping
11 Comments
Stepping through 3DFrame
Following a recent comment this post looks at the code for setting up the stiffness matrix for a 3D frame, and how to step through any selected part of the code. The general procedure for setting up a 3D stiffness matrix, … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged 3DFrame, Debugging UDFs, Debuging VBA, Excel, UDF, VBA
Leave a comment
Using the Frame Analysis Spreadsheets
Following some recent questions in the comments, here are some answers: How can nodal moments be created? The current versions only allow for forces to be applied to beams, but any point load or moment applied at the start or … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
Tagged Beam end springs, Excel, Frame Analysis, node restraints, VBA
2 Comments