
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.
Related Resources
Looking for Resources?
Recent News & Events
Quick Links
Testimonials
-
“Small errors in modeling can lead to substantial errors in joint performance prediction. To alleviate this problem, the CAI used the handbook functionality of ESRD Inc.’s (St. Louis, Mo.) trademarked StressCheck® P-version finite element software to develop reusable models of typical joints.”
Dr. John Russell
Composites World Magazine