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
“Through the use of StressCheck® the A-10 Aircraft Structural Integrity Program’s (ASIP) Analysis Group is able to model more accurately the physics of fatigue crack propagation in critical aircraft structure. Through this tool we are able to model, analyze and predict failure of aircraft structure and then develop crucial inspection and maintenance planes to ensure the safety and sustainability of our nations warplanes. Without the analysis capability provided to us through StressCheck® we would not be able to provide accurate assessments of the A-10 structure to top USAF leadership.”
SWRI Research EngineerSouthwest Research Institute