### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Commenting a block of code in VBA
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Drawing in Excel 7 - Creating drawings from coordinates
- Fitting high order polynomials
- The angle between two vectors, Python version
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Downloads by category

### Recent Comments

dougaj4 on Buckling of columns with varyi… Marco Valsecchi on Buckling of columns with varyi… Displaying trend lin… on Using LINEST for non-linear cu… RCInteract and RC De… on RC Design Functions 7.03 Larry Schuster on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu…

# 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
Leave a comment

## 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
4 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

## 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
3 Comments