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
“Aerospace materials scientists and structural engineers now have a new state-of-the-art software product called StressCheck®, which provides efficient and reliable analysis tools for composite bonded aircraft structures. A composites research team from the aeronautics industry, known as the Composites Affordability Initiative (CAI), has just completed an extensive study of current capabilities in the area of failure analysis tools for composite bonded joints. This study led the CAI team to unanimously choose StressCheck® as the software tool to replace as well as radically improve existing industry standard software currently used to size bonded joints.”
Air Force Research Laboratory (AFRL)