Installation and Setup
Installation - Each User. Installation - Multi-user. Language Translations. Personalize Your Templates.Systems2win Training.
Quick Start Initial Training. New User Training. Training Matrix. Systems2win Leadership. Training Classes.Lean Training
Lean Training and Coaching. Lean Principles. Muda 8 Wastes. Goal - Lean Flow. Roadmap - Lean Journey. Value Stream Mapping. Standard Work. Hansei Lean Thinking. Lean Dictionary. Online Lean Training. Lean Leadership.Microsoft Office Training
Excel Training. Excel Drawings (without Visio). Excel Charts. Word Training. PDF Training. Document Storage and Naming.Support
Support.aka Quality Functional Deployment Matrix
QFD House of Quality template with all the power and familiarity of Microsoft Excel
into observable, measurable Functional Requirements for a deliverable product or service
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
is that it can be huge or tiny; easily scaling to the size you need
Sample House of Quality QFD Example
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 Videos for your
These videos are helpful to watch together when you launch your team
Training & Demo Videos
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
(that come with this QFD template)
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 getting started using your
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
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.
How to get started using your
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.
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 — which gives you sample data that is extremely helpful for learning how to use your new tool, but is the wrong place to do your real work)
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:
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.
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'
Your personalizations
get found and transferred
each time you upgrade
How to use your
In the Systems2win menu in the Excel Ribbon bar...
When you select '4 Phase QFD Wizard', it automatically...
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
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
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%
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:
Typical customer's current level of satisfaction with our offering
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
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
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:
Complete the bottom section: Performance Analysis
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
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 Training
to move, add, or remove rows or columns
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
To Add a Row between existing rows in the main section
Never add or delete rows or columns in the main section
Excel training video
Add, Copy, or Move rows
To Remove a Row between existing rows in the main section
Never add or delete rows or columns in the main section
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
(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)
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
To Remove a Column between existing columns in the main section
Never add or delete rows or columns in the main section
This will also delete the data from the columns on the far right that get hidden, and will reprotect your sheet.
The purpose of Phase 2 is to evaluate and choose between alternative product designs to meet the Performance Requirements chosen in Phase 1.
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 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
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.
This will auto-generate a new sheet that is formatted for Phase 3 QFD:
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
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.
Illustration courtesy of Strategic Quality
Learn more about FMEA.
Suggested Reading and Resources for
Tip: The FMEA Control Plan can often serve as the 4th phase of QFD
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
Contents
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
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:
质量屋 质量功能部署矩阵
Download Free Trial
If your organization has
not yet provided a license,
download your free trial now
Training and Coaching
Consider Training and Coaching to support your teams to succeed
Training to get you started.
Tools you won't outgrow.
Schedule a Conference
Schedule a conference
to discuss your challenges
with an experienced lean advisor