Helpful Hints and Tips: Excel VBA 3D Crack Design Study
Abstract: Helpful Hints and Tips on scripting VBA with the StressCheck COM API to extract 3D SIF’s for a simple lug with an elliptical corner crack in a hole. Once the “Solve” button is clicked on the driver sheet (Driver), StressCheck opens a fully parametric, manually-meshed model and performs a Design Study for a range of crack lengths (A) and crack depths (C). The driver then computes A/C vs. SIF’s along the resulting crack fronts. Feedback of progress and live dynamic extraction of SIF’s to a VBA-generated Excel worksheet (Extractions) are provided.
Looking for Resources?
Recent News & Events
“The p-type element has been used to great advantage in the finite element system ESRD StressCheck®, . This software provides the engineer with the means to conduct solution verification in an extremely straightforward manner by simply increasing the degree of the element, monitoring convergence and using Richardson extrapolation reliably to estimate the error. This can be conducted automatically by the software thereby enabling the engineer to concentrate on the engineering rather than the simulation. StressCheck® has also been used to develop ESRD’s Handbook and Toolbox applications. The first of these provides engineers with a repository of parameterised standard problems of the type found in texts like Roark’s “Formulas for Stress and Strain”, . The second, Toolbox, is a tool that can be used to parameterise a company’s range of components for rapid and reliable analysis by non-expert analysis. Toolbox then is an exemplary of the way in which the democratisation of simulation can be applied.”
Angus Ramsay, PhDEngineering Director, Ramsay Maunder Associates