### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Column buckling under multiple loads
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Buckling of columns with varying cross section

### Recent Comments

Column buckling unde… on Using Frame4Buckle with the Al… Column buckling unde… on Buckling of columns with varyi… dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update DonB on Biaxial bending update Perko on Installing Adobe Reader non-DC… Python Traps | Newto… on The meaning of = in Pytho… dougaj4 on P-Y Curve function Zhitong Zhang on P-Y Curve function Matt Cornell on Newton’s Cradle Clive James and Pete… on The Barrow Poets dougaj4 on Excel to Alglib via xlwin… Roulior Halder on Excel to Alglib via xlwin…

# Category Archives: Finite Element Analysis

## Column buckling under multiple loads

Following another buckling discussion at Eng-tips I have modified my Frame4-buckle spreadsheet to allow input of multiple axial loads at any point along the column, along with any number of sections with different section properties. Background on the method used … Continue reading

Posted in AlgLib, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged AlgLib, column buckling, Euler buckling, Excel, Frame Analysis, multiple load buckling, stepped column, tapered column, VBA, Vianello
Leave a comment

## 64 bit Excel and the Strand7 API

Back in May 2017 I posted a sample spreadsheet using the Strand7 API to allow Excel to read and write Strand7 node data and results. A comment noted at the time that the spreadsheet was not working with 64 bit … Continue reading

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7
Tagged 64 bit Excel, Strand7 API
Leave a comment

## 3D Frame with zero stiffness hinges

The previous version of 3DFrame allowed for spring releases at beam ends, but if the release stiffness was entered as zero it was treated as a rigid connection for that freedom. Effectively zero stiffness releases could be modelled by entering … Continue reading

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