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
“Hearty congratulations to management and staff at ESRD on their 25th anniversary. The quality and capability of their software products are excellent. I hope that ESRD successfully continues for many more years with the fundamental principles of mathematical precision, numerical accuracy, and integrity in computational simulation.”
Dr. William OberkampfAuthor of Verification and Validation in Scientific Computing