Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- Downloads
- The history of the theory of beam bending - Part 1
- Writing Arrays to the worksheet - VBA function
- Filling Blanks with Go To-Special (and local help rant)
- Retrieving unique values from a range or array ...
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Category Archives: Finite Element Analysis
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
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
3DFrame with spring releases
Following the previous post I have added similar functionality to the 3DFrame spreadsheet. The new file can be downloaded from: 3DFrame.zip As before, see Installing C# dll files, reminder for details of installing the supplied dll files, which provide much better … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, VBA
Tagged 3D frame analysis, Excel. VBA, moment release, spring end release, Strand7
8 Comments
Frame analysis with spring releases; 2D
I have updated the Frame4 spreadsheet to allow a rotational spring stiffness to be specified for members with a rotational end release. The new file can be downloaded from: Frame4.zip See Installing C# dll files, reminder for details of installing the … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7, VBA
Tagged Excel. VBA, Frame Analysis, moment release, spring hinges, Strand7
1 Comment
Non-linear frame analysis; moment curvature and self-weight
The Python/Fortran/Excel frame analysis program (previous version here) now has several new features added to the 2D-solver routines: The beam bending behaviour may now be specified with moment-curvature tables, rather than the linear-plastic behaviour required in the previous version. Beam … Continue reading
Posted in Arch structures, Beam Bending, Concrete, Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to dll, Link to Python, NumPy and SciPy, Strand7, VBA
Tagged Excel, FEA, Fortran, Frame Analysis, link to dll, moment curvature, Non-linear concrete, Non-linear geometry, Programming the Finite Element Method, Python, SciPy, sparse solvers, VBA, xlwings
1 Comment