Home > Excel Business Solutions > Operations and Management > Manufacturing and Engineering > QFD, FMEA and Pugh Templates Share

QFD, FMEA and Pugh Templates

Excel qfd, fmea and pugh templates for manufacturing and engineering


Excel QFD, FMEA and Pugh Templates

Rate this solution:
(3.7/5 from 4 votes)
QFD, FMEA and Pugh Templates screenshot
QFD, FMEA and Pugh Templates for Excel (SnapSheets XL) allows the creation, analysis and modification of six sigma templates for houses of quality - quality function deployment (QFD), failure mode and effects analysis (FMEA), and Pugh matrices in Excel.

The QFD, FMEA and Pugh Excel templates consist of Excel worksheets and charts and can be shared with anyone that has Excel.

The Quality Function Deployment (QFD) solution creates and edits Houses of Quality (HOQ) with rank order requirements using a Pairwise Comparison Matrix (PCM), Pareto and rank order Critical To Quality (CTQ) metrics, and more. QFD template features include:
  • Pair-wise comparison matrix to rank order requirements.
  • Generate House of Quality (HOQ) from previous house.
  • Pareto Critical To Quality (CTQ).
  • Optionally include different rooms in HOQ.
  • Right click functionality to add and remove rows and columns or modify the matrix.
  • Add or remove rows and columns without losing data.

The Failure Mode and Effects Analysis (FMEA) functionality creates and edits FMEA worksheets with Pareto results by RPN, severity or specified methods. FMEA template features include:
  • Grouping of failure modes for ease of use.
  • Multiple causes per failure mode.
  • FMEA severity, occurrence, and detection ratings for quick look up.
  • Hide columns that are not needed for implementation.
  • Quick Pareto generates graph based on RPN.
  • Pareto by RPN, severity, occurrence, detection and more.
  • Quickly add/remove groups, failure modes and causes.

The Pugh Concept Selection and Generation tool is designed to evaluate potential solutions to a problem based upon a set of decision criteria. Resulting Pugh matrices can be used to generate new alternative solutions from existing concepts. Pugh template features include:
  • Create matrix with custom number of criteria and alternatives.
  • Grouping of decision criteria for ease of use.
  • Weighting columns to increase relative importance.
  • Add/remove/insert groups, decision criteria or alternatives.
  • Automatic calculation of the sum, number positive and negative.
  • Pareto analysis of alternatives by Sum.
  • Right click functionality to modify matrix.

QFD, FMEA and Pugh Templates for Excel are compatible with Excel 2000 or higher.

Get It

(Pricing is available on the next page)
(Updated on 2023-12-01)

Related Excel Solutions for QFD, FMEA and Pugh Templates

Six Sigma Metrics Balanced ScorecardRisk Analysis  Advanced GraphsManufacturing and Engineering  Structural Engineering AnalysisManufacturing and Engineering

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.