Skip to main content

Excel Templates, Training, and Systems

House of Quality template

aka Quality Functional Deployment Matrix

QFD House of Quality template with all the power and familiarity of Microsoft Excel

Purposes of QFD Quality Functional Deployment

  1. To translate potentially vague customer desires

    into observable, measurable Functional Requirements for a deliverable product or service

  2. To provide a guiding structure

    for a cross-functional product development team to rapidly design and deploy new products and services in a fraction of the time required by traditional methods

The first thing that most people notice about the

Systems2win QFD template

is that it can be huge or tiny; easily scaling to the size you need

QFD template

Sample House of Quality QFD Example

This QFD Excel template

for quality function deployment

is easily scaled to analyze up to 50 customer demands, 50 performance measures, 4 customer segments, and 5 competitors on a single chart.

In the rare event that you need more than that, you can use multiple sheets (perhaps for different customer segments) to analyze unlimited customer demands and performance measures for unlimited customer segments and competitors.


Training

Training Videos for your

House of Quality Excel template

These videos are helpful to watch together when you launch your team

House of Quality

Training & Demo Videos

 

QFD videos

 

This QFD template

comes with helpful online training and videos

to get your design team started

and to take your customer-centric designs to new levels

to systematically crush your (less competent) competitors

 

Additional training
relevant to this template

See the Sample sheet in your House of Quality template

Video Help

House of Quality Video 1:
Introduction to QFD
& Cause and Effect Matrix

 

QFD Training Video 2:
Correlations

 

QFD Training Video 3:
Calculations and Analysis

 

QFD Training Video 4:
The 4 Phases of QFD


before

Before getting started using your

House of Quality template

Are you sure this deserves QFD analysis?

The bottom line question answered by QFD analysis is:

"Which Performance Measures will the design team select to improve?"

For smaller companies and/or less complex offerings...

your Measurement Selection Matrix (MeasuresSelect.xlsx)

and Cause and Effect Matrix templates (CauseEffect.xlsx)

can often be used to arrive at a similar answer to the same question with a lot less effort and money

You should only bring out your "big gun" House of Quality template

for multi-million dollar product or service offerings

that are used by diverse types of customers

perhaps competing against diverse (fierce) competitors

Measurement Selection Matrix

Cause and Effect Matrix template

Launch your team

Launch your team

using the same methods and templates that you use to launch any team for any type of process improvement.

Before taking on an advanced six sigma tool like this House of Quality template,

every team member should complete the foundational New User Training to learn the basic features that are common to every one of your 150+ Systems2win templates for process improvement.


testimonial quote

start

How to get started using your

House of Quality QFD template

Find and open your template

Find and open your House of Quality QFD template

(QFD.xlsx)

in the same way that you find and open your other 150+ Systems2win templates.

Excel Ribbon bar > Systems2win menu

If you don't yet own a license, you can download your free trial now.

This is one of the only Systems2win templates that requires you to enable macros.

Save your working document

following the usual document storage and naming conventions established by your leaders

Open a Blank Sheet

When you're ready to start doing your own real work...

click the button to 'Open a Blank Sheet'

Excel Ribbon > Systems2win tab > Open a Blank Sheet

This blank sheet is where you will do your real work

(not on the Sample sheet)

Systems2win menu > Open a BlankSheet

Rename your new sheet.

Personalize your drop down lists

Even if your leaders have already personalized the DV sheet in your master template so that you are starting with typical drop down lists for YOUR company,

you still might want to edit some of those drop down lists for your unique QFD.

User-defined Scales

Many (most?) teams will simply use the default rating scales that come pre-defined with your QFD template.

If, however, you choose to personalize any of your rating scales, then be sure to change both:

  1. The drop down lists on the DV sheet, and
  2. The text boxes in the lower right section of your QFD template

to provide visibility of your rating scales to users of your printed House of Quality Matrix

Rather than editing an existing text box, you might replace it with a User Help Text Box, so that the Personalization Upgrade Utility will automatically find and transfer your personalizations each time that you upgrade.

QFD rating scales

Personalize your master template

If you find that your teams are making the same changes to your template every time that they start a new QFD project,

then your leaders can personalize your master template in ways that your personalizations will be automatically found and transferred to your new upgraded master template every time that you upgrade.

(In the same ways that you can personalize every one of your Systems2win templates, that all have consistent, standardized features for faster learning, and less wasted time)

Easily personalized

Because it is written using Microsoft Excel, your qfd template can be easily personalized with custom formulas and individualized approaches to all four phases of QFD.

Like every Systems2win Excel template, the House of Quality template is editable and customizable, and comes with extensive online training, so that your Six Sigma team members can devote their valuable time to actually performing QFD analysis and problem solving.

rather than 'inventing a deployment template'

Personal art

Your personalizations
get found and transferred
each time you upgrade


phases

How to use your

House of Quality template for all 4 phases of QFD

QFD ribbon menu

In the Systems2win menu in the Excel Ribbon bar...

When you select '4 Phase QFD Wizard', it automatically...

QFD 4 phases

phase1

House of Quality Template

QFD Phase 1) Performance Requirements

The first phase of QFD
(which is often the only phase deployed by a design team)

provides a system for translating potentially vague customer desires into prioritized, observable, measurable functional requirements for design specifications for a deliverable product or service.

Start by gathering Voice of the Customer Data

Critical To Quality template

VOC Kano template

Your Systems2win templates include an entire suite of tools that your team will find useful for

Learn more about your Voice of the Customer templates

Translate Voice of the Customer

Translate the Voice of the Customer into "engineering speak" functional requirements

using your Voice of the Customer Translation template (VOC-Kano.xlsx)

Transcribe your Voice of the Customer data

Transcribe your data from your Voice of the Customer Translation template to your QFD Phase 1 worksheet.

Demanded Qualities

This is the Voice of the Voice of the Customer translated into Demanded Qualities

Enter your Demanded Qualities into the header cells for each row in the primary section of your QFD template.

Do not use word wrap; so that your charts will stay aligned with your rows.

Performance Measures

These are your functional requirements, translated into Performance Measures

Enter your Performance Measures into the header cells for each column in the primary section of your QFD template.

Desired Direction of Measure

Use the drop down list to clarify for each Performance Measure:

▲ Higher number is better
▼ Lower number is better
O Target is best

resize

Resize

House of Quality buttons in the Systems2win menu

To resize your House of Quality template, simply select 'Change # Rows and Columns'

in your Systems2win menu in the Excel ribbon bar

Yes, it will even resize the roof of the house for your desired number of columns!!!

To move, add, or remove rows or columns, see Advanced Training.

Complete the left wing: Importance for Typical Customer

Note: It is important to complete the left wing section of your QFD first,

because some bottom wing calculations require a non-blank value for Composite Importance

Description of Typical Customer

Use the text box to clarify how your team defines your "typical customer".

Tip: In addition to your typical customer, you can also optionally analyze additional customer segments in the Competitive Analysis section (in the right wing of your House of Quality template)

Importance

This is the Importance to your most common Typical Customer

that your team described in the text box on your QFD.

Use the drop down list

to choose a numeric value for each Demanded Quality.

Like every Systems2win template,

all drop down lists are defined on the DV sheet.

You can define any scale,
(as long as higher numbers are better)
but most teams use the default scale:

0 Not at all important (should probably delete)
to 5 Extremely Important

Importance %

This auto-calculates, so that the sum always equals 100%

QFD dropdowns

Many of the cells in your QFD template
use drop down lists to to easily choose values
from the lists that you define on your DV sheet

Customer Satisfaction

The Customer Satisfaction Rating System that you define on the DV sheet, will be used in the drop down lists for both:

  1. Customer Evaluation of Our Offering

    Typical customer's current level of satisfaction with our offering

  2. Target Level of Satisfaction

    Design Team's decision for the level of customer satisfaction to design the product to meet

Again... you can define any scale that you want,
(as long as higher numbers are better)
but most teams use the default scale of:

0 Disappointed
to 5 Extremely Satisfied

Be sure that your scale numbers and descriptions match the numbers and descriptions that you used in your customer survey.

Or if you did customer interviews, make sure that they match the scale numbers and descriptions that you defined when your team prepared for those interviews using your Operational Definitions template (Op_Def.xlsx).

Ratio of Improvement

"How much do we need to improve?"

Ratio of Improvement = Target Level of Satisfaction / Customer Evaluation of Our Offering

Sales Points

Usually leave blank

Some companies allow Sales to skew the weighting factors for no more than 3 rows:

1.5 = Demanded Qualities that will differentiate this product from the competition.

1.2 = Important selling point

Composite Importance

Composite Importance = Importance * Ratio of Improvement * Sales Points

Composite Importance %

This auto-calculates, so that the sum always equals 100%

Complete the center section: Relationships

Relationship Correlation

In the center of your House of Quality template,

use the drop down list for each cell to choose the level of correlation between each Demanded Quality (row) and Performance Measure (column).

Your team can define any scale,
(as long as higher numbers are higher correlation)
but most teams use the default scale:

Blank = Not yet determined (your team hasn't yet decided)
. (period) = No correlation (your team has concluded that there is no correlation)
1 = Low correlation
3 = Medium correlation
9 = High correlation

House of Quality relationships

Weighted Total Importance

Weighted Total Importance = The sum of the column's Relationship Correlation Ratings x Composite Importance ratings (rounded up to the nearest whole number).

Tip: If Composite Importance is blank, that row will not be included in this calculation!!!

% Total Importance

This auto-calculates, so that the sum always equals 100%

Complete the roof: Correlations

Roof Correlation symbols

When you select any cell in the roof of the House of Quality, it will instantly highlight the two correlated columns.

And from the drop down list, you can define how these two Performance Measures reinforce or conflict with each other.

▲▲ Strong Reinforcement
▲ Reinforcement
(blank) No Correlation
▼ Trade-off Conflict
▼▼ Strong Conflict

House of Quality template

Tip: Yes, your team can replace these drop down choices on the DV sheet, but why? These are pretty visual and intuitive symbols, aren't they?

Optional right wing: Customer Types and Competitors

You can hide unused columns, or unhide columns

for optional analysis of how your different types of customers perceive your product as compared to your competitors.

Use the simple drop down lists to change the charts to show your different:

  1. Customer Types
  2. Competitors
House of Quality competitor charts

Complete the bottom section: Performance Analysis

QFD bottom section

Optional Data

You can have unlimited rows and columns of optional data,

and you have all the power of familiar Microsoft Excel to add your own optional formulas, analyses, and/or charts.

Measured Performance

Use this section to validate

that scientifically observed results for each Performance Measure produce results that match up with customer ratings of our offering vs. competitors.

If they don't match,

then maybe tests aren't measuring what the customer really wants.

Desired Targets

To choose which targets are worthy of engineering resources,

take into consideration the weight of importance, Kano Analysis, difficulty, and current capability as compared to competitors

Kano Analysis

See Kano Analysis training
for your Voice of the Customer Translation template.

(blank) The customer is indifferent to this feature
▼ Dissatisfier
▲ Satisfier
♥ Delighter

Kano Analysis

Difficulty

Difficulty to get from the current level of performance to your desired level of performance.

Your team can define any scale that you want,
(as long as higher numbers are more difficult)
but most teams use the default scale of:

0 Almost no effort required, to
5 Huge, time-consuming, expensive project

Capability

Current capability to deliver your chosen level of target performance.

The higher the number, the more capable you are to deliver.

There are several popular scales for Capability.

Perhaps use simple 0-5 scale.

Perhaps use Cp index. (ratio of specification to manufacturing sigma)

Perhaps use Cpk index. (process sigma to nearest spec / 3)

Selected to Improve

The very bottom row of your House of Quality Template is where your team makes it's final decisions.

All of this work... all of this analysis...

comes down to this one row of bottom-line decisions:

"Where will we focus our attention?"

Drop down choices for these bottom line decisions:

X = Selected to improve
(conditional formatting will highlight the X in bold red)

. (period) = No special effort planned for this column of Performance Measure

(blank) = The team has not yet decided


advanced

Advanced Training

to move, add, or remove rows or columns

House of Quality buttons in the Systems2win menu

It is important to understand that when you use the feature to

'Change Number of Rows & Columns'...

in the Systems2win menu in the Excel ribbon bar

it hides rows and columns; it does not delete them.

There are always 50 rows and 50 columns in the main section.

To avoid messing things up...

it is very important to never insert or delete rows or columns in the main section of your QFD workbook.

You must instead follow these special instructions... (below)

To Move a Row in the main section

  1. Unprotect the sheet
  2. Use Shift Down and Move to move entire rows
  3. Reprotect the sheet

To Add a Row between existing rows in the main section

Never add or delete rows or columns in the main section

  1. To increase the number of rows, use Systems2win menu > Change # Rows and Columns
  2. Unprotect the sheet
  3. Select blank row(s), then use Shift Down and Move to move entire rows where you want them
  4. Reprotect the sheet

To Remove a Row between existing rows in the main section

Never add or delete rows or columns in the main section

  1. Unprotect the sheet
  2. Select the row(s) you want to remove, then use Shift Down and Move to move entire rows
    to the bottom of the main section
  3. To reduce the number of rows, use Systems2win menu > Change # Rows and Columns

    This will also delete the data from the bottom rows that get hidden, and will reprotect your sheet.

To Move a Column in the main section

Do not move an entire column

  1. Back up your workbook (just in case)
  2. Select all of the cells in the column beneath the red roof

    (starting with the thin gold line just below the red roof,
    and ending with the thin gold line at the very bottom, just below the 'Selected To Improve' row)

  3. Copy (Ctrl+C)
  4. Select the cell in the thin gold line just below the roof for the column where you want to paste
  5. Paste (Ctrl+V)

Tips:

You might need to 'play the shuffle game'... temporarily copying to a blank column.

You can copy & paste more than one column at a time, as long as you don't try to paste within any portion of the same highlighted area from which you just copied.

To Add a Column between existing columns in the main section

Never add or delete rows or columns in the main section

  1. To increase the number of columns, use Systems2win menu > Change # Rows and Columns
  2. Use the special instructions (above) to move columns where you want them

To Remove a Column between existing columns in the main section

Never add or delete rows or columns in the main section

  1. Use the special instructions (above) to move your unwanted columns to the right end of the main section
  2. To reduce the number of columns, use Systems2win menu > Change # Rows and Columns

    This will also delete the data from the columns on the far right that get hidden, and will reprotect your sheet.


phase2

House of Quality Template

QFD Phase 2) Product or Service Design

The purpose of Phase 2 is to evaluate and choose between alternative product designs to meet the Performance Requirements chosen in Phase 1.

House of Quality buttons in the Systems2win menu

When you have completed your Phase 1 worksheet,

click the button in the Systems2win menu

for '4 Phase QFD Wizard', and select Phase 2.

This will auto-generate a new sheet that is formatted for Phase 2 QFD:

Decision PICK Matrix template

Decision Making

Phase 2 is when your team might also use your decision making templates

Most popularly, you might use your Decision PICK Matrix template

perhaps with the special rating scale of a Pugh Matrix


phase3

QFD Phase 3) Process Design

The purpose of Phase 3 is to define the Critical to Satisfaction parameters needed to physically produce and/or deliver the product or service in ways that reliably meet or exceed the design specifications.

When you have completed your Phase 2 worksheet,

click the button in the Systems2win menu

for '4 Phase QFD Wizard', and select Phase 3.

QFD 4 phases

This will auto-generate a new sheet that is formatted for Phase 3 QFD:

Time to reflect

Tip: In this phase, you will want to allow extra time for Hansei

to think, ponder, and reflect,

perhaps using some of your other tools for process improvement


control

QFD Phase 4) Process Control and Quality Control

The purpose of the fourth phase of QFD is to define process and quality controls for each step of the process.

When you have completed your Phase 3 worksheet,

click the button in the Systems2win menu

for '4 Phase QFD Wizard', and select Phase 4.

This will auto-generate a new sheet that is formatted for Phase 4 QFD:

 

Tips

Every company has very different measures for Phase 4 QFD process controls.

You can use everything you know about familiar Microsoft Excel to personalize your template for your unique column headers.

Some teams choose to use their Control Plan template to serve as the 4th phase of QFD.

 

Relationship between QFD and FMEA

Illustration courtesy of Strategic Quality

Learn more about FMEA.


Reading

Suggested Reading and Resources for

QFD House of Quality

One way to support the free training provided on this site is to purchase your books here

To see the links to suggested readings, you might need to change your Ad Blocker to allow ads on this page

Tip: The FMEA Control Plan can often serve as the 4th phase of QFD

More Suggested Reading


This House of Quality Excel template comes with many other useful DFSS Tools, Voice of the Customer Tools, and DMAIC Tools

to empower every team member to improve every process

 

 

 
 

 

 

 

Training and Videos

Your Systems2win templates come with Training & Videos to get the most from your process improvement tools

 

 

 

 

 

 

New User Training

Your Systems2win templates come with free New User Training
to quickly learn features that are common to all 150+ templates

 

 

 

 

Questions?

One huge benefit of owning your Systems2win templates is Support when you need it

 

 

 

 

 

Languages

Your QFD template
is available in
multiple languages

Spanish:
Casa de la calidad
matriz de despliegue funcional de calidad

French:
Maison de qualité
déploiement fonctionnel
de qualité

Portuguese:
Casa de Qualidade Implementação Funcional
de Qualidade

German:
Funktionale Qualitätsoptimierung

Chinese:
质量屋 质量功能部署矩阵