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
- XLDennis, the MSDN Library, and VBA rant
- Frame Analysis with Excel - 3, Continuous beam or frame
- Writing Arrays to the worksheet - VBA function
- Filling Blanks with Go To-Special (and local help rant)
- Daily Download 4: Continuous Beam Analysis
Recent Comments
Category Archives: Strand7
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
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
Mohr’s Circle and Plate Stresses and Actions
The functions described in this post can be found in the download file PlateStress.zip, including examples and full open source code. The function MCircle returns the plane stress components (XX, YY and XY stress) for any specified stress field, when rotated through a … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged Excel, Gauss Points, Mohr's Circle, Plate stresses, Strand7, UDF, VBA
1 Comment
Daily Download 6: Working with FEA programs
Today’s downloads are three programs for working with Finite Element Analysis (FEA) programs. The first use the Scripting Dictionary Object to count the number of different element types (beams, plates, bricks and links) and the number of node restraints at … Continue reading
Posted in Excel, Finite Element Analysis, Newton, Strand7, UDFs, VBA
Tagged API, Excel, FEA, Scripting dictionary, Strand7, UDF, VBA
Leave a comment
The Dome of Santa Maria del Fiore – Stress Analysis 2
Following on from the previous post I have uploaded the Strand7 data and results files and an animation of the stresses as the construction proceeds. Strand7 users can just download the files and load them into Strand7 (or those with a slow … Continue reading
Posted in Dome Structures, Finite Element Analysis, Newton, Strand7
Tagged 3D Finite element analysis, Cathedral, Dome, FEA, Florence, staged analysis, Strand7
Leave a comment