Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- XLDennis, the MSDN Library, and VBA rant
- Latex Maths Text in Excel
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Filling Blanks with Go To-Special (and local help rant)
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Retrieving unique values from a range or array ...
- The angle between two vectors, Python version
- Contour plots with Excel and Matplotlib
- About Newton Excel Bach
Recent Comments
Category Archives: Frame Analysis
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
Non-linear Frame Analysis – Scipy solvers
The frame analysis spreadsheet presented in the previous post has been updated to use the solvers included in the Scipy package. There is now an option to use either the Cholesky solver, or an iterative sparse solver. The main advantages of … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to dll, Link to Python, Newton, NumPy and SciPy, Strand7, UDFs, VBA
Tagged Cholesky factorisation, ctypes, Excel, FEA, Fortran, Frame Analysis, link to dll, Non-linear concrete, Programming the Finite Element Method, Python, SciPy, sparse solvers, VBA, xlwings
1 Comment
Non-linear Frame Analysis
Another example using Fortran code published in Programming the Finite Element Method (5th ed. John Wiley & Sons, I.M. Smith, D.V. Griffiths and L. Margetts (2014)), this post provides a spreadsheet based frame analysis program including non-linear bending behaviour and … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to dll, Link to Python, Newton, NumPy and SciPy, Strand7, UDFs, VBA
Tagged ctypes, Excel, FEA, Fortran, Frame Analysis, link to dll, Non-linear concrete, Programming the Finite Element Method, Python, VBA, xlwings
5 Comments
ConbeamU 4.10
The ConbeamU spreadsheet has been updated to Version 4.10, to fix a problem with incorrect default parameters being used if the support stiffness columns had empty cells. The revised spreadsheet (including open-source code) can be downloaded from: ConbeamU.zip Applications in the … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged ConBeamU, continuous beam analysis, Excel, Fixed End Moments, moving load, Restrained End Moments, Strand7, UDF, VBA
24 Comments
Retaining wall analysis – FEA and hand calculations
I have used the PlateMC spreadsheet described in the previous post to compare the results of a finite element analysis of a retaining wall with a similar analysis using the commercial package Strand7, and a simple hand calculation using Coulomb … Continue reading
Posted in Excel, Finite Element Analysis, Fortran, Frame Analysis, Geotechnical Engineering, Link to dll, Link to Python, Newton, NumPy and SciPy, Strand7, UDFs, VBA
Tagged Coulomb, ctypes, Excel, FEA, Fortran, Ka, link to dll, plane strain, Programming the Finite Element Method, Python, soil-structure interaction, staged analysis, VBA, xlwings
Leave a comment