Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Filling Blanks with Go To-Special (and local help rant)
- About Newton Excel Bach
- Cubic Splines
- XLDennis, the MSDN Library, and VBA rant
- Writing Arrays to the worksheet - VBA function
- Worksheetfunction.Transpose - changed behaviour in Excel 2013 and 2016
- Daily Download 5: Frame Analysis
- Downloads
Recent Comments
Tag Archives: Strand7
ConBeamU 4.13
The continuous beam analysis spreadsheet, ConBeamU, is now up to version 4.13 with some minor bug-fixes, and the addition of a non-linear option for the BeamAct functions. See ConBeamU for more details of the functions available in the spreadsheet. Download … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged BeamAct functions, continuous beams, Excel, non-linear analysis, Strand7, UDF, VBA
7 Comments
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
10 Comments
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
8 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