Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Filling Blanks with Go To-Special (and local help rant)
- Cubic Splines
- XLDennis, the MSDN Library, and VBA rant
- Writing Arrays to the worksheet - VBA function
- Daily Download 5: Frame Analysis
- Worksheetfunction.Transpose - changed behaviour in Excel 2013 and 2016
- Downloads
Recent Comments
Tag Archives: Strand7
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
The Dome of Santa Maria del Fiore – Stress Analysis 1
It’s time to get back to the analysis of the stresses and strains in the dome of the Cathedral of Santa Maria del Fiore in Florence. Since the last installment I have purchased “Brunelleschi’s Cupola” by Giovanni and Michele Fanelli, which is … Continue reading
Posted in Dome Structures, Finite Element Analysis, Newton
Tagged 3D Finite element analysis, Cathedral, Dome, FEA, Florence, staged analysis, Strand7
1 Comment
Strand7 API GetNode functions
As promised in this post, I have written and documented Excel User Defined Functions (UDFs) to interface with all the Strand7 API functions that return node attributes or results. These 22 functions allow node attributes and results to be read directly … Continue reading
Posted in Excel, Finite Element Analysis, Newton, Strand7, UDFs, VBA
Tagged API, Excel, Node Functions, Strand7, UDF, VBA
5 Comments