### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- The angle between two vectors, Python version
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Taming Symbols in Excel
- Section Properties of Defined Shapes - Spreadsheet

### Recent Comments

Lambda and VBA | New… on Two New Functions; Let and… dougaj4 on Eval and Let examples dougaj4 on Eval and Let examples TB on Eval and Let examples dougaj4 on Eval and Let examples pgalvan@sigmaingenie… on Eval and Let examples dougaj4 on Eval and Let examples Craig on Eval and Let examples Craig on Eval and Let examples dougaj4 on Downloads Eval and Let example… on Evaluating text – u… Eval and Let example… on Evaluating text with units and… Eval and Let example… on Two New Functions; Let and… rhochoa81gmailcom on Downloads Ebony Buckle, New Sc… on George Gently, Matty Groves, a…

# Tag Archives: Frame 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

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

## Using the Frame Analysis Spreadsheets

Following some recent questions in the comments, here are some answers: How can nodal moments be created? The current versions only allow for forces to be applied to beams, but any point load or moment applied at the start or … Continue reading

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
Tagged Beam end springs, Excel, Frame Analysis, node restraints, VBA
2 Comments

## Installing Frame4 and 3DFrame

Following a recent comment I have added a VBA only version to the download files of the frame analysis spreadsheets: 3DFrame.zip Frame4.zip The VBA versions should work on any version of Excel from 2007, with macros enabled, without any further installation. The … Continue reading

Posted in AlgLib, Excel, Frame Analysis, Link to dll, Newton, VBA
Tagged 3D frame analysis, 3DFrame, Excel, Frame Analysis, Frame4, link to dll, VBA
Leave a comment