Failure Modes and Effects Analysis seeks to analyze and prevent potential failures in systems, subsystems and parts of any product using “Design” FMEA. It can also be used to detect and prevent failures in the processes used to create a part or deliver a service. FMEA helps create products and services that have Six Sigma quality.
The FMEA tool is part of the QI Macros: an add-in for Microsoft Excel that automates all of the charts, forms and tools required for statistical process control (SPC) and Lean Six Sigma. There are over 80,000 registered users. The QI Macros are used by over 2,700 hospitals and medical centers to hold down costs and increase healthcare quality. The QI Macros consist of four parts:
1. Macros that use existing Excel data to create 21 different charts: line, run, pareto, control charts, and histograms.
2. Fill-in-
3. Statistical analysis tools like ANOVA, f-test, regression, and a sample size calculator.
4. Data manipulation tools like restacking data and the PivotTable Wizard.
Unlike complex statistical tools, the QI Macros tools can be used by anyone from nurses to Lean Six Sigma Black Belts. Users most often say that the QI Macros are:
· Easy to learn. The pull-down menu gives immediate access to all tools.
· Works directly on Excel data. Over 90% of the world’s offices use Excel. With the QI Macros, there is no need to transfer the data out of Excel. Just select and go.
· Affordable at only $139 per copy.
30-day trial copies of the QI Macros for Excel can be downloaded at http://www.qimacros.com/
