Category Archives: Finite Element Analysis

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 , , , , , , | 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 , , , , , , , , | 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 , , , , , | 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 , , , , , | Leave a comment

Using the Strand7 API

Strand7 is a general purpose Finite Element Analysis program, which has an Application Programming Interface (API), allowing external programs to interact with Strand7, including reading and writing to data files, running analyses, and reading the results.  The API is a comprehensive … Continue reading

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , | 7 Comments