SIX-SIGMA FOR QFD(ASSIGNMENT)
Assume you want to open a new business:
What features of your product/service will be most attractive to your customer? Use the
QFD
tool.
> House of Quality 1 / ▬ 1 ▬ imize
1 2 3 6 8 9 11 x ▲ ▲ ▼ ▼ ▼ ▲ ▲ ▲ ▲ x x ▲ ▼ ▼ x ▼ x x Weight 0 1 2 3 4 5 Θ Θ ▲ ▲ Ο Ο ▲ 2 3 4 4 4 4 8
Θ Θ ▲ ▲ Ο Ο ▲ 2 3 4 4 4 4 Θ Θ ▲ ▲ Ο Ο ▲ 2 3 4 4 4 4 0.9 Θ Θ ▲ ▲ Ο Ο ▲ 2 3 4 4 4 4 Θ Θ ▲ ▲ Ο Ο ▲ 2 3 4 4 4 4 Ο Θ Θ Ο ▲ Ο Ο ▲ Ο Θ 5 2 3 3 3 4 8
1.0 Ο Θ 1 5 5 5 5 5 Θ Ο ▲ ▲ ▲ Ο Ο ▲ Ο Ο Θ 4 3 3 3 3 3 0.7 Θ ▲ Θ Ο ▲ 3 4 4 4 4 4 Θ Ο 5 2 3 2 2 3 Ο ▲ Ο Θ Θ Ο Θ ▲ Θ 2 3 4 4 4 5 8
Ο ▲ Θ Θ Ο Θ 0 3 3 3 3 3 Ο Θ Θ Θ 1 2 2 2 3 4 0.5 Θ Ο Θ Θ Θ Ο ▲ 2 3 3 3 5 3 Ο Θ Θ Ο 0 1 3 2 3 3 Θ ▲ Θ 5 3 3 4 3 5 8
▲ Ο Θ Θ 1 3 4 2 2 4 0.0 0.3 8
99.90% 3 2 6 8 4 2 8 7 1 3 2 1 3 6 4 2 6 2 3 9 9 9 9 9 9 9 9 9 9 9 9 9 3 9 9 9 9 9 0.0 0.0 0.0 0.0 0.0 0.0 .0
8.6 8.6 .0
0.0 0.0 0.0 0.0 0.0 0.0 0.3 0.3 1.7 3.0 1.4 0.0 0.0 0.0 0.0 0.0 0.0 285714286
217.1428571429 180 180 105.7142857143 182.8571428571 52.380952381 234.2857142857 222.8571428571 111.4285714286 8.5714285714 8.5714285714 8.5714285714 8.5714285714 60 60 51.4285714286 191.4285714286 146.6666666667 94.2857142857 42.8571428571 285.7142857143 0 0 0 0 0 0 0 0 0 0 0 0 House of Quality 1 Current Technology (Dog) Legend ┼ Positive Correlation x Objective Is To Hit Target Error Measurement between ID locations 180 Continuous uptime without crash 60 Numeric Values for Relationship Matrix Calculations 20 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Note: the cells in the above row are setup the way that they are because you cannot enter an array formula in a merged cell. Title: 20 0.0 0.0 0.0 0 0 18 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Title: http://www.qfdonline.com/about/terms-of-use/ http://www.qfdonline.com/templates/comments/ http://www.qfdonline.com/templates/comments/ http://www.qfdonline.com/about/terms-of-use/ http://www.qfdonline.com/templates/template-sponsorship/ http://www.qfdonline.com/templates/ http://www.qfdonline.com/templates/ http://www.qfdonline.com/templates/template-sponsorship/
2
House of Quality
1
Title:
Author:
P1
1
0
6
Date:
1/1
8
11
Notes:
Second Attempt Using Different Template
Legend
Θ
Strong Relationship
9
┼
▬
Ο
Moderate Relationship
3
┼ ▬ ▬
┼┼
▲
Weak Relationship
┼┼
┼┼
Strong
Positive Correlation
▬
┼ Positive Correlation
┼┼ ┼┼
▬
Negative Correlation
▼
▼
Strong Negative Correlation
┼┼ ▼ ▼ ┼┼
▼
Objective Is To Minimize
┼ ▼ ┼ ┼
▲
Objective Is To Ma
x
▬ ┼┼ ┼┼ ┼┼
x
Objective Is To Hit Target
┼ ┼┼ ▼ ▬ ┼
┼┼ ▼ ▬ ┼ ┼ ▬
▼ ▼ ▬ ┼ ▬ ▬
▬ ▬ ▬ ▬ ┼ ┼
┼┼ ▬ ┼┼ ▬ ▬ ▬
┼┼ ┼ ▼ ▬ ▼ ┼┼ ┼┼ ▼ ┼┼ ▬
Column #
4
5
7
10
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Direction of Improvement:
Minimize (▼), Maximize (▲), or Target (x)Competitive Analysis
(0=Worst, 5=Best)
Row #
Max Relationship Value in Row
Relative
Weight
Weight / Importance
Quality Characteristics
(a.k.a. “Functional Requirements” or “Hows”)
Device Contains Complete Nodal Map of Building 9
Number of Identifiable Locations
Read Range
Error Measurement between ID locations
Mean Learning Time
Battery Lifetime
Navigation Endpoint Precision
Location ID Repeatability
Repeatability of Directions
Correct I/O pins for interface
Use same microcontroller as interface team
Continuous uptime without crash
Latency from navigation to UI update
PCB Size
Validate Input
Prototype with reasonable cost
Switch from English to Metric Units
Relative Compass Bearing
Current Technology (Dog)
IR
RFID
RFID and IR
Two RFID Tags
RFID and Compass
Chart Axis Values
Demanded Quality
(a.k.a. “Customer Requirements” or “Whats”)
1 9
8.6
9.0
Identifies All Classrooms/Offices
0.9
2 9 8.6 9.0
Identifies All Bathrooms
0.94
3 9 8.6 9.0
Identifies all exits/entrances
4 9 8.6 9.0
Identifies all stairwells/elevators
0.86
5 9
2.9
3.0
Identifies all Lounges
0.82
6 9 8.6 9.0
Helps get out of room once in
0.7
7 9
1.0
Gives Directions in feet or meters
0.74
8 9 8.6 9.0
Easy to use
9 9 8.6 9.0
Portable
0.66
10 9 2.9 3.0
Low Power Consumption
0.62
11 9 8.6 9.0
Accurate Directions
0.5
12 9 1.0 1.0
Interfaces with other groups
0.54
13 9 2.9 3.0
Durable
14 9 8.6 9.0
Device reacts within a couple feet of location
0.46
15 9 8.6 9.0
Needs hands Free Mode
0.42
16 9 1.0 1.0
System retains Proper Orientation
0.3
17 9 2.9 3.0
Inexpensive to own
0.34
18
0.0
19 0.0 0.0
0.26
20 0.0 0.0
0.22
21 0.0 0.0
0.1
22 0.0 0.0
0.14
23 0.0 0.0 0.1
24 0.0 0.0
0.06
25 0.0 0.0
0.02
Target or Limit Value
65536 locations
3 meters
0%
20 minutes
6 ounces
8 hours
1 meter
99.90%
min 8 hours
250 ms
3″x2″
$500
Difficulty
(0=Easy to Accomplish, 10=Extremely Difficult)
Max Relationship Value in Column
Weight / Importance
47
1.4
448.6
217.1
180
105.7
182.9
52.4
234.3
222.9
111.4
60
51.4
191.4
146.7
94.3
42.9
285.7
Relative Weight
15.1
14.4
7.0
5.8
3.4
5.9
1.7
7.5
7.2
3.6
1.9
6.1
4.7
9.2
Powered by QFD Online (http://www.QFDOnline.com)
Numeric Values for Relationship Matrix Calculations
1 8.6 9 9 1 0 0 0 0 1 3 0 0 0 0 0 0 3 0 0 1 0 0 0 0 0 0
2 8.6 9 9 1 0 0 0 0 1 3 0 0 0 0 0 0 3 0 0 1 0 0 0 0 0 0
3 8.6 9 9 1 0 0 0 0 1 3 0 0 0 0 0 0 3 0 0 1 0 0 0 0 0 0
4 8.6 9 9 1 0 0 0 0 1 3 0 0 0 0 0 0 3 0 0 1 0 0 0 0 0 0
5 2.9 9 9 1 0 0 0 0 1 3 0 0 0 0 0 0 3 0 0 1 0 0 0 0 0 0
6 8.6 3 9 9 3 0 0 1 3 3 0 0 0 1 3 0 0 0 0 9 0 0 0 0 0 0
7 1.0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 9 0 0 0 0 0 0 0
8 8.6 0 0 0 0 9 3 0 1 1 1 0 0 3 3 1 3 0 3 9 0 0 0 0 0 0
9 8.6 0 0 0 0 0 9 1 0 0 0 0 0 0 0 9 0 3 0 1 0 0 0 0 0 0
10 2.9 0 0 0 0 0 0 9 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0
11 8.6 3 1 3 9 0 0 0 9 3 9 0 0 0 0 0 0 1 0 9 0 0 0 0 0 0
12 1.0 0 0 0 0 0 3 1 0 0 0 9 9 0 0 3 9 0 0 0 0 0 0 0 0 0
13 2.9 0 0 0 0 0 0 0 3 9 9 0 0 9 0 0 0 0 0 0 0 0 0 0 0 0
14 8.6 9 3 9 9 0 0 0 9 3 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0
15 8.6 0 0 0 0 3 9 0 0 0 0 0 0 0 0 9 0 3 0 0 0 0 0 0 0 0
16 1.0 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 9 0 0 0 0 0 0
17 2.9 0 1 0 0 0 0 3 0 0 0 0 0 0 0 9 0 9 0 0 0 0 0 0 0 0
18 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
19 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
20 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
21 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
22 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
23 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
24 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
25 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
471.4
471.4285714286
44
8.5714285714
448.5714285714
217.1428571429
105.7142857143
182.8571428571
52.380952381
234.2857142857
222.8571428571
111.4285714286
51.4285714286
191.4285714286
146.6666666667
94.2857142857
42.8571428571
285.7142857143
Note: the cells in the above row are setup the way that they are because you cannot enter an array formula in a merged cell.
Thus, the red cells contain the array formula and the cell beside the red cell displays the vale.
IR
RFID
RFID and IR
Two RFID Tags
RFID and CompassData Validation Sources
Min, Max, or Target Options
Relationship Between Requirements Options
Correlation Options
▼ Θ ┼┼
▲ Ο ┼
x ▲ ▬
▼
House of Quality 2
Title:
Author:
Date:
Notes:
Θ Strong Relationship 9
Ο Moderate Relationship 3
▲ Weak Relationship 1
┼┼
Strong Positive Correlation
▬ Negative Correlation
▼ Strong Negative Correlation
▼ Objective Is To Minimize
▲
Objective Is To Maximize
Powered by QFD Online (http://www.QFDOnline.com)
Column # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Direction of Improvement:
Minimize (▼), Maximize (▲), or Target (x)
Row # Max Relationship Value in Row Relative Weight Weight / Importance Quality Characteristics
(a.k.a. “Functional Requirements” or “Hows”)
Demanded Quality
(a.k.a. “Customer Requirements” or “Whats”)
1 0.0 15.1 471.4 Device Contains Complete Nodal Map of Building 9 471.4285714286
2 0.0 14.4 448.6 Number of Identifiable Locations 448.5714285714
3 0.0 7.0 217.1 Read Range 217.1428571429
4 0.0 5.8
180.0
5 0.0 3.4 105.7 Mean Learning Time 105.7142857143
6 0.0 5.9 182.9 Weight 182.8571428571
7 0.0 1.7 52.4 Battery Lifetime 52.380952381
8 0.0 7.5 234.3 Navigation Endpoint Precision 234.2857142857
9 0.0 7.2 222.9 Location ID Repeatability 222.8571428571
10 0.0 3.6 111.4 Repeatability of Directions 111.4285714286
11 0.0 0.3 8.6 Correct I/O pins for interface 8.5714285714
12 0.0 0.3 8.6 Use same microcontroller as interface team 8.5714285714
13 0.0 1.9
60.0
14 0.0 1.7 51.4 Latency from navigation to UI update 51.4285714286
15 0.0 6.1 191.4 PCB Size 191.4285714286
16 0.0 4.7 146.7 Validate Input 146.6666666667
17 0.0 3.0 94.3 Prototype with reasonable cost 94.2857142857
18 0.0 1.4 42.9 Switch from English to Metric Units 42.8571428571
19 0.0 9.2 285.7 Relative Compass Bearing 285.7142857143
20 0.0 0.0 0.0 0 0
21 0.0 0.0 0.0 0 0
22 0.0 0.0 0.0 0 0
23 0.0 0.0 0.0 0 0
24 0.0 0.0 0.0 0 0
25 0.0 0.0 0.0 0 0
Target or Limit Value
Difficulty
(0=Easy to Accomplish, 10=Extremely Difficult)
Max Relationship Value in Column 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Weight / Importance 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Relative Weight 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
1 15.1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2 14.4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 7.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4 5.8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5 3.4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6 5.9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7 1.7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8 7.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9 7.2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 3.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
11 0.3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
12 0.3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
13 1.9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
14 1.7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
15 6.1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16 4.7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
17 3.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
18 1.4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
19 9.2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
21 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
22 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
23 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
24 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
25 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Thus, the red cells contain the array formula and the cell beside the red cell displays the vale.
House of Quality 3
Author:
Date:
Notes:
Legend
Θ Strong Relationship 9
Ο Moderate Relationship 3
▲ Weak Relationship 1
┼┼ Strong Positive Correlation
┼ Positive Correlation
▬ Negative Correlation
▼ Strong Negative Correlation
▼ Objective Is To Minimize
▲ Objective Is To Maximize
x Objective Is To Hit Target
Powered by QFD Online (http://www.QFDOnline.com)
Column # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Direction of Improvement:
Minimize (▼), Maximize (▲), or Target (x)
Row # Max Relationship Value in Row Relative Weight Weight / Importance Quality Characteristics
(a.k.a. “Functional Requirements” or “Hows”)
Demanded Quality
(a.k.a. “Customer Requirements” or “Whats”)
1 0.0 0.0 0.0 0 471.4285714286
2 0.0 0.0 0.0 0 448.5714285714
3 0.0 0.0 0.0 0 217.1428571429
4 0.0 0.0 0.0 0 180
5 0.0 0.0 0.0 0 105.7142857143
6 0.0 0.0 0.0 0 182.8571428571
7 0.0 0.0 0.0 0 52.380952381
8 0.0 0.0 0.0 0 234.2857142857
9 0.0 0.0 0.0 0 222.8571428571
10 0.0 0.0 0.0 0 111.4285714286
11 0.0 0.0 0.0 0 8.5714285714
12 0.0 0.0 0.0 0 8.5714285714
13 0.0 0.0 0.0 0 60
14 0.0 0.0 0.0 0 51.4285714286
15 0.0 0.0 0.0 0 191.4285714286
16 0.0 0.0 0.0 0 146.6666666667
17 0.0 0.0 0.0 0 94.2857142857
18 0.0 0.0 0.0 0 42.8571428571
19 0.0 0.0 0.0 0 285.7142857143
21 0.0 0.0 0.0 0 0
22 0.0 0.0 0.0 0 0
23 0.0 0.0 0.0 0 0
24 0.0 0.0 0.0 0 0
25 0.0 0.0 0.0 0 0
Target or Limit Value
Difficulty
(0=Easy to Accomplish, 10=Extremely Difficult)
Max Relationship Value in Column 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Weight / Importance 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Relative Weight 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Numeric Values for Relationship Matrix Calculations
1 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
11 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
12 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
13 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
14 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
15 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
17 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
19 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
20 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
21 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
22 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
23 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
24 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
25 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Note: the cells in the above row are setup the way that they are because you cannot enter an array formula in a merged cell.
Thus, the red cells contain the array formula and the cell beside the red cell displays the vale.
House of Quality 4
Author:
Date:
Notes:
Legend
Θ Strong Relationship 9
Ο Moderate Relationship 3
▲ Weak Relationship 1
┼┼ Strong Positive Correlation
┼ Positive Correlation
▬ Negative Correlation
▼ Strong Negative Correlation
▼ Objective Is To Minimize
▲ Objective Is To Maximize
x Objective Is To Hit Target
Powered by QFD Online (http://www.QFDOnline.com)
Column # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Direction of Improvement:
Minimize (▼), Maximize (▲), or Target (x)
Row # Max Relationship Value in Row Relative Weight Weight / Importance Quality Characteristics
(a.k.a. “Functional Requirements” or “Hows”)
Demanded Quality
(a.k.a. “Customer Requirements” or “Whats”)
1 0.0 0.0 0.0 0 471.4285714286
2 0.0 0.0 0.0 0 448.5714285714
3 0.0 0.0 0.0 0 217.1428571429
4 0.0 0.0 0.0 0 180
5 0.0 0.0 0.0 0 105.7142857143
6 0.0 0.0 0.0 0 182.8571428571
7 0.0 0.0 0.0 0 52.380952381
8 0.0 0.0 0.0 0 234.2857142857
9 0.0 0.0 0.0 0 222.8571428571
10 0.0 0.0 0.0 0 111.4285714286
11 0.0 0.0 0.0 0 8.5714285714
12 0.0 0.0 0.0 0 8.5714285714
13 0.0 0.0 0.0 0 60
14 0.0 0.0 0.0 0 51.4285714286
15 0.0 0.0 0.0 0 191.4285714286
16 0.0 0.0 0.0 0 146.6666666667
17 0.0 0.0 0.0 0 94.2857142857
18 0.0 0.0 0.0 0 42.8571428571
19 0.0 0.0 0.0 0 285.7142857143
20 0.0 0.0 0.0 0 0
21 0.0 0.0 0.0 0 0
22 0.0 0.0 0.0 0 0
23 0.0 0.0 0.0 0 0
24 0.0 0.0 0.0 0 0
25 0.0 0.0 0.0 0 0
Target or Limit Value
Difficulty
(0=Easy to Accomplish, 10=Extremely Difficult)
Max Relationship Value in Column 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Weight / Importance 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Relative Weight 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Numeric Values for Relationship Matrix Calculations
1 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
11 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
12 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
13 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
14 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
15 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
17 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
18 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
19 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
20 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
21 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
22 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
23 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
24 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
25 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Note: the cells in the above row are setup the way that they are because you cannot enter an array formula in a merged cell.
Thus, the red cells contain the array formula and the cell beside the red cell displays the vale.About
Template Sponsors:
Template Name:
Traditional House of Quality (Large)
Version:
1.2.15.0
Release Date:
January 15, 2008
Updated versions of this template (along with other valuable comments and instruction regarding its use) can be obtained at the following location:
http://www.qfdonline.com/templates/
If you have any questions, comments, requests, or suggestions regarding this template, please submit them via the following discussion forum for this template:
http://www.qfdonline.com/templates/comments/
This template was distributed by QFD Online or one of its Template Sponsors.
Resale or redistribution of this template by entities other than QFD Online or its Template Sponsors is strictly prohibited. Inquiries about obtaining redistribution rights to QFD Online’s templates can be submitted through the following URL:
http://www.qfdonline.com/templates/template-sponsorship/
Use of this template constitues acceptance of the terms associated with its use, including an understanding that this template is provided “as is” with no warrantees expressed or implied by QFD Online. For a complete list of the terms associated with the use of this template, please visit:
http://www.qfdonline.com/about/terms-of-use/