SIX-SIGMA FOR QFD(ASSIGNMENT)

profileChandu469
HouseofQuality3.xls
Home>Engineering homework help>Mechanical Engineering homework help>SIX-SIGMA FOR QFD(ASSIGNMENT)

House of Quality 1

Title: House of Quality
Author: P11016
Date: 1/18/11
Notes: Second Attempt Using Different Template
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
┼ ┼┼ ▼ ▬ ┼
┼┼ ▼ ▬ ┼ ┼ ▬
▼ ▼ ▬ ┼ ▬ ▬
▬ ▬ ▬ ▬ ┼ ┼
┼┼ ▬ ┼┼ ▬ ▬ ▬
┼┼ ┼ ▼ ▬ ▼ ┼┼ ┼┼ ▼ ┼┼ ▬
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) x ▲ ▲ ▼ ▼ ▼ ▲ ▲ ▲ ▲ x x ▲ ▼ ▼ x ▼ x 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 Weight 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") 0 1 2 3 4 5
1 9 8.6 9.0 Identifies All Classrooms/Offices Θ Θ ▲ ▲ Ο Ο ▲ 2 3 4 4 4 4 0.98
2 9 8.6 9.0 Identifies All Bathrooms Θ Θ ▲ ▲ Ο Ο ▲ 2 3 4 4 4 4 0.94
3 9 8.6 9.0 Identifies all exits/entrances Θ Θ ▲ ▲ Ο Ο ▲ 2 3 4 4 4 4 0.9
4 9 8.6 9.0 Identifies all stairwells/elevators Θ Θ ▲ ▲ Ο Ο ▲ 2 3 4 4 4 4 0.86
5 9 2.9 3.0 Identifies all Lounges Θ Θ ▲ ▲ Ο Ο ▲ 2 3 4 4 4 4 0.82
6 9 8.6 9.0 Helps get out of room once in Ο Θ Θ Ο ▲ Ο Ο ▲ Ο Θ 5 2 3 3 3 4 0.78
7 9 1.0 1.0 Gives Directions in feet or meters Ο Θ 1 5 5 5 5 5 0.74
8 9 8.6 9.0 Easy to use Θ Ο ▲ ▲ ▲ Ο Ο ▲ Ο Ο Θ 4 3 3 3 3 3 0.7
9 9 8.6 9.0 Portable Θ ▲ Θ Ο ▲ 3 4 4 4 4 4 0.66
10 9 2.9 3.0 Low Power Consumption Θ Ο 5 2 3 2 2 3 0.62
11 9 8.6 9.0 Accurate Directions Ο ▲ Ο Θ Θ Ο Θ ▲ Θ 2 3 4 4 4 5 0.58
12 9 1.0 1.0 Interfaces with other groups Ο ▲ Θ Θ Ο Θ 0 3 3 3 3 3 0.54
13 9 2.9 3.0 Durable Ο Θ Θ Θ 1 2 2 2 3 4 0.5
14 9 8.6 9.0 Device reacts within a couple feet of location Θ Ο Θ Θ Θ Ο ▲ 2 3 3 3 5 3 0.46
15 9 8.6 9.0 Needs hands Free Mode Ο Θ Θ Ο 0 1 3 2 3 3 0.42
16 9 1.0 1.0 System retains Proper Orientation Θ ▲ Θ 5 3 3 4 3 5 0.38
17 9 2.9 3.0 Inexpensive to own ▲ Ο Θ Θ 1 3 4 2 2 4 0.34
18 0.0 0.0 0.3
19 0.0 0.0 0.26
20 0.0 0.0 0.22
21 0.0 0.0 0.18
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% 99.90% min 8 hours 250 ms 3"x2" $500
Difficulty (0=Easy to Accomplish, 10=Extremely Difficult) 3 2 6 8 4 2 8 7 1 3 2 1 3 6 4 2 6 2 3
Max Relationship Value in Column 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
Weight / Importance 471.4 448.6 217.1 180.0 105.7 182.9 52.4 234.3 222.9 111.4 8.6 8.6 60.0 51.4 191.4 146.7 94.3 42.9 285.7 0.0 0.0 0.0 0.0 0.0 0.0
Relative Weight 15.1 14.4 7.0 5.8 3.4 5.9 1.7 7.5 7.2 3.6 0.3 0.3 1.9 1.7 6.1 4.7 3.0 1.4 9.2 0.0 0.0 0.0 0.0 0.0 0.0 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.4285714286 471.4285714286 448.5714285714 448.5714285714 217.1428571429 217.1428571429 180 180 105.7142857143 105.7142857143 182.8571428571 182.8571428571 52.380952381 52.380952381 234.2857142857 234.2857142857 222.8571428571 222.8571428571 111.4285714286 111.4285714286 8.5714285714 8.5714285714 8.5714285714 8.5714285714 60 60 51.4285714286 51.4285714286 191.4285714286 191.4285714286 146.6666666667 146.6666666667 94.2857142857 94.2857142857 42.8571428571 42.8571428571 285.7142857143 285.7142857143 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 1
Current Technology (Dog)
IR
RFID
RFID and IR
Two RFID Tags
RFID and Compass

Data Validation Sources

Min, Max, or Target Options Relationship Between Requirements Options Correlation Options
▼ Θ ┼┼
▲ Ο ┼
x ▲ ▬
▼

House of Quality 2

Title:
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 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 Error Measurement between ID locations 180
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 Continuous uptime without crash 60
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
Numeric Values for Relationship Matrix Calculations
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
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 3

Title:
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.

House of Quality 4

Title:
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/