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
- Cubic Splines
- Downloads
- The history of the theory of beam bending - Part 1
- Filling Blanks with Go To-Special (and local help rant)
- Writing Arrays to the worksheet - VBA function
- XLDennis, the MSDN Library, and VBA rant
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Category Archives: Finite Element Analysis
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
The Dome of Santa Maria del Fiore – Dimensions
This post is a continuation from The Dome of Santa Maria del Fiore in Florence Different sources give a wide variety of different dimensions for the dome, but there seems to be reasonable agreement that the “across flats” diameter of the … Continue reading
Posted in Dome Structures, Excel, Finite Element Analysis, Newton, Strand7, UDFs, VBA
Tagged DigitGraph, Dome, Excel, FEA, Florence Cathedral, IP2, S& API Tools, UDF, VBA
2 Comments
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
VBA code generation on the spreadsheet
A previous post looked at using VBA to generate more VBA code. This post looks at automatic code generation on the spreadsheet, which may be transferred into the a VBA project using the techniques discussed in the earlier post, or simply … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Newton, UDFs, VBA
Tagged API, code generation, Excel, Strand7, UDF, VBA
Leave a comment