Advanced Statistical Methods and Tools for Product Design
FMEA WORKSHEET FEATURES
- FMEA worksheet size limited by number of allowable rows in Microsoft Excel
- Items from open Triptych worksheets (QFD, AHP, Pugh, TOPSIS, and SDI) can be imported into an FMEA worksheet
- Standard industry definitions used for Severity (S), Occurrence (O), and Detectability (D) scores on a 1-10 scale
- Dropdown fields for selecting S, O, and D scores based on number score (1-10), brief or expanded definitions
- Auto calculation of Risk Priority Number (RPN = S x O x D)
- Auto calculation of Criticality score (Criticality = S x O)
- Three-level sorting on any combination of fields
- Selectable Show/Hide options for any field
- User defined color-coding of RPN and Criticality scores
- Merge/Unmerge option for common text on adjacent rows in a field
- User editable field labels and properties
- Manage information visibility
- Context-sensitive help and right-click popup
- All work is stored in a standard Excel worksheet
Using FMEA Worksheet in Product Development
FMEA is used throughout the development process to identify potential causes of design failures. Important areas addressed include:
- What can go Wrong?
- What is the Impact?
- What are the Chances of it occurring?
- How would we Find Out?
- How can we Improve the design?
