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.

Categories: Fracture Mechanics Module, Linear Elasticity Solver, MeshSim Advanced Module, StressCheck Core, StressCheck Powered Apps, StressCheck Professional. Tags: Damage Tolerance, Design Study, Fracture Extraction, Fracture Mechanics, Parametric Modeling, Points Extraction, Results, Simulation Apps, StressCheck API.

Scroll to View This Resource (Login May Be Required)

You need to login to view this content. Please . Not a Member? Join Us

Testimonials

“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 Engineer
Southwest Research Institute