A Statistical Analysis Program for Generating Material Allowables

  • Developed and approved by the Composite Materials Handbook-17 (CMH-17) Statistics Working Group
  • Follows the latest statistical analysis guidelines documented in the 2012 Rev G of CMH-17
  • Incorporates single point analysis (STAT17) and pooling analysis (ASAP) techniques
  • Friendly Microsoft Excel user interface allows for standard and customizable A- and B-basis allowable calculations
  • PC-based single-user license


  • No limit on batches or batch size
  • Data read from files or manual input
  • Diagnostic tests at individual conditions
  • Output file contains input and results
  • Double precision math






After you have purchased and downloaded the software, use the instructions below to properly set up and install it.


  1. After purchasing you should receive a serial number by email from Tracee Friess of Wichita State University. If you do not receiva serial number, Email Tracee Friess to request one.
  2. Copy the serial number. You will need to paste it during installation of the software.
  3. Open the CMH17_STATS_Setup.exe file to install the software.
  4.  When prompted, paste your assigned serial number.
  5. Install the program directly onto the C: drive by creating a new folder under C:. Do not put it under Program Files.
  6. After installation, double-click the program to run it. (You should have  a shortcut on your desktop).
  7. If there is a security warning in yellow at the top of your spreadsheet, click on it and enable Macros.
  8. Run the program by clicking on the COMPUTE BASIS VALUES button on the CMH17 MAIN worksheet
  9. The program will generate a text file with the processor i.d. for your computer
  10.  E-mail the above mentioned text file to
  11. A license file will be generated and e-mailed to you.
  12.  Save the license file into the same directory that contains the program
  13.  Open the CMH17 STATS DP 2011 v1.1xlsm program
  14. The destination directory is set to the same directory as the  CMH17 STATS DP 2011 v1.1xlsm program. If you prefer a different directory, click on the SELECT DESTINATION DIRECTORY button and choose the desired directory. You may not key-in/type the path for the directory. You must have “write” privileges to the chosen directory.
  15. You may input the data in the INPUT DATA sheet and run the analysis now by clicking on the COMPUTE BASIS VALUES button on the CMH17 MAIN worksheet.

If you should encounter any problems during installation/execution of the program, please e-mail Dr. Raju with a description of the problem/error. The data for which the error was encountered would be helpful if e-mailed along with the problem description.

Please Note: CMH17 STATS is an Excel-based program and is compatible with Microsoft Windows v2007 and higher.

For purchasing and download questions, contact Tracee Friess by email or call (316) 978-5597.
For technical support after download, contact Raju Keshavanarayana by email or call (316) 978-5939.