Three VBA modules are defined. These modules define functions that can be used to obtain material properties, laminate properties, or laminate load response. They define functions that return results, generally presented as 1D or 2D arrays, which can be used directly in Excel spreadsheets with the appropriate arguments passed as cell selections. The user should look at the VBA code to understand the different functions.
TIP: to enter a formula that returns an array function into an Excel spreadsheet, select the target cell, enter the name of the function with the appropriate arguments, and press “SHIFT+ENTER” simultaneously.