Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Writing Arrays to the worksheet - VBA function
- Cubic Splines
- About Newton Excel Bach
- Filling Blanks with Go To-Special (and local help rant)
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Linking Excel to C - 2
Recent Comments
Category Archives: Beam Bending
Using RC Design Functions – 1
Download RC Design Functions (includes full open source code) and EStress Examples.xlsx This series of posts will cover ways of using the many functions contained in the RC Design Functions spreadsheet, starting with some general comments on using the User … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Examples, Excel, RC Design Functions, Reinforced Concrete, UDF, VBA
13 Comments
3DFrame – 3D Frame analysis for Excel
I have now extended the Frame4 spreadsheet to deal with 3D frames. As well as making the necessary changes to the input ranges and stiffness matrix generation routines I have revised the Sparse solver routine, added a new compiled solver, and … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7, VBA
Tagged 3D frame analysis, Excel, sparse solver, Spreadsheet frame analysis, VBA
21 Comments
Defining beam orientation in 3D
The principal axes of a beam (or any 2D closed shape) are defined as the axes along which an applied load will not cause any deflection in the transverse direction. In mathematical terms, if the beam cross-section is defined in the … Continue reading
Extending Frame4 with on sheet formulas
Still on Frame4, Julien asked if provision could be made for application of local loads, i.e. loads perpendicular to sloping members, rather than just horizontal or vertical. This will actually be incorporated in the spreadsheet “real soon now”, but it … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
Tagged Excel, Frame Analysis, Frame4 spreadsheet, local loads, VBA
3 Comments
Frame4 Version 3.05; with support displacements
Hot on the heels of Version 3.04 comes Version 3.05. A few days ago Julien asked if the Frame4 allowed for specified support deflections, to which I replied it would be added in the future. Searching Google on the topic I … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, VBA
Tagged C# matrix functions, Excel, Frame Analysis, link to dll, VBA
7 Comments