Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Contour plots with Excel and Matplotlib
- Cubic Splines
- Brent's Method; Update and Examples
Recent Comments
mindOnion on Drawing a Buckyball in Ex… dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd… metroxx on Composite Beam Spreadsheet Upd…
Tag Archives: FEA
Secondary moments in prestressed beams with FEA
Secondary (or hyperstatic) bending moments occur in prestressed beams that are continuous over internal supports, or have other redundant support conditions. Any eccentric prestress force will cause a beam to deflect, and if these deflections are restrained at internal supports, … Continue reading
Deflections and Moments in Rectangular Plates
Following a question here I have compared tabulated coefficients for deflections and bending moments in a rectangular plate with results of a Strand7 analysis using 8 noded plate/shell elements. The results are summarised below, and in a spreadsheet which also … Continue reading
Posted in Beam Bending, Curve fitting, Excel, Finite Element Analysis, Newton
Tagged Excel, FEA, Linest, Moody, Pilkey, plate bending, plate deflections, Plate stresses, Roark, Strand7, Timoshenko
5 Comments
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