Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 4: Continuous Beam Analysis
- Latex Maths Text in Excel
- Writing Arrays to the worksheet - VBA function
Recent Comments
Category Archives: Frame Analysis
Route Map …
… so we know where we are going. I’ll be starting several, to some extent interlinked, new themes in this blog over the coming weeks. Firstly VBA Classes. Regular readers may have noticed that my VBA code tends to be … Continue reading
Posted in AlgLib, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Maths, Newton, VBA
Tagged Addin Express, AlgLib, Drawing in Excel, Reinforced Concrete, Strand7, VBA classes
4 Comments
Buckling of columns with varying cross section
Following a post in the Eng-Tips Forum about finding the buckling load of a stepped strut I have modified the Frame4 spreadsheet to carry out a buckling analysis of any straight member subject to axial load, including stepped or tapered cross … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, VBA
Tagged column buckling, Euler buckling, Excel, Frame Analysis, stepped column, tapered column, VBA, Vianello
27 Comments
SplineBeam update
Previous SplineBeam post I have modified the SplineBeam spreadsheet to allow input of a single span (simply supported or with end constraints), and to optionally allow input of the position of intermediate nodes, rather than dividing each span into equal segment lengths. This … Continue reading
Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam, Cubic spline, Excel, UDF, VBA
1 Comment
Frame4.xls – Update2
It was recently pointed out to me that the Frame4 spreadsheet was giving an overflow error with a fairly small analysis. The problem turned out to be that the analysis did not have any restraint specified in the X direction, … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
Tagged Excel, Finite Element Analysis, Frame Analysis, VBA
12 Comments
Continuous beam with specified end conditions …
… and/or support displacements. The previous post in this series derived cubic splines with specified end conditions; either a specified curvature or a specified end slope. I have adapted the splinebeam function to allow input of specified end conditions (either a … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Maths, Newton, UDFs, VBA
Tagged bending moments, continuous beam analysis, Cubic spline, deflections, Excel, shear forces, UDF, VBA
1 Comment