217Plus Handbook Process Grading Factor Spreadsheet

This Microsoft Excel® Workbook is intended to be a supplement for owners of the Reliability Information Analysis Center (RIAC) "Handbook of 217Plus™ Reliability Prediction Models." It automates the grading and scoring of those questions related to the seven 217Plus™ system level model process factors (Parts, Design, Manufacturing, System Management, Induced, No Defect and Wearout), plus the Reliability Growth process factor. As such, the user should be familiar with the manual process of creating a system reliability prediction using the 217Plus™ methodology prior to using this spreadsheet. Tab 1, "Min Req'd Questions," represents the minimum subset of questions that must be answered in order to produce a valid Process Grade PI-Factor for each of the failure cause areas. This tab reflects the same minimum number of questions that are programmed into the 217Plus™ software tool. The results of this minimum analysis are presented at the bottom of Tab 1.

If the user desires to answer additional questions based on their knowledge of their organization's processes, he/she can subsequently answer those questions on Tabs 2 through 9 of the Workbook (the answers already provided on Tab 1 are automatically linked to Tabs 2 through 9). The results of this additional analysis are presented on the "FULL RESULTS" tab. Grading and scoring is accomplished by answering each question based on the criteria defined for that question, i.e., a yes or no answer, or a quantitative answer based on the guidelines provided. Scoring is accomplished automatically using the weights and grading only for those questions that have been answered. Questions not answered are not scored, and their weights are not included in the final scoring and determination of the individual and overall system Process Grade Factors. Discussion related to process grade scoring and weighting is included in Sections 2.4.1 and 2.4.2 of the Handbook.

Click on the image to view the screen image.