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
“Accurate and reliable stresses and Stress Intensity Factors are required for determination of static and residual strength and for crack growth analyses in analysis tools such as AFGROW. For some geometries, industry solutions are either insufficient or nonexistent. The geometry, applied forces, and crack shapes and dimensions must be modeled reasonably well to obtain useful engineering data. The p-version finite element software StressCheck® (ESRD, Inc., St. Louis, Missouri, USA) is used to demonstrate how accurate finite element solutions can lead to good quality engineering analysis.”