can anyone help with prod design & develop?

profilesnae.6
2.xlsx
Home>Engineering homework help>Mechanical Engineering homework help>can anyone help with prod design & develop?

House of Quality 1

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
┼┼ ▬
▬
▬ ▬
┼┼ ▬ ▬
┼┼ ┼┼
┼┼ ┼┼ ┼┼
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) ▼ ▼ ▼ ▼ ▼ ▼ ▼ ▼ ▼ ▲ ▼ ▼ ▲ ▲ ▲ ▼ ▼ ▲ ▲ 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") Product weight Length Width Thickness Edge radii of case or protruding surfaces Range of free motion when not in use Average operation time Average time of focused concentration Peak noise level Average noise level Average result, ease ofe use test Average pocket insertion time Average pocket removal time Average comfort test results Strength of critical functional components Flexibility Total Key Capacity Maximum key length Clearance between moving parts Average time to find proper key Avg. frequency of wrong key selection # of separable modules Size of possible subsets Surfcae texture surface tackiness Our Company Competitor 1 Competitor 2 Competitor 3 Competitor 4 Competitor 5 Chart Axis Values
Demanded Quality (a.k.a. "Customer Requirements" or "Whats") 0 1 2 3 4 5
1 9 8.1 6.0 Easy to remove from pocket ▲ Θ Θ Θ Ο Θ Θ Θ Ο Ο Ο ▲ Ο Ο Ο Ο 0.98
2 9 4.1 3.0 Easy to put into pocket ▲ Θ Θ Θ Ο Θ Θ Θ Ο Ο Ο ▲ Ο Ο Ο Ο 0.94
3 9 9.5 7.0 Fits comfortably in hip pocket Θ Θ Θ Θ Ο Θ Ο Θ Ο ▲ Ο Ο ▲ Ο 0.9
4 9 4.1 3.0 Operates quietly Ο Θ Θ ▲ ▲ Ο Ο ▲ 0.86
5 9 9.5 7.0 Operates quickly ▲ Ο Ο ▲ ▲ Ο Θ Θ Θ Θ Θ ▲ Ο ▲ Ο Θ Ο ▲ ▲ Ο Ο 0.82
6 9 13.5 10.0 Easy to locate proper key Θ Θ Θ ▲ Θ ▲ Ο Θ Θ Ο Ο 0.78
7 9 4.1 3.0 Is lightweight Θ Θ Θ Θ ▲ Ο Ο Θ Ο Ο 0.74
8 9 6.8 5.0 Works with a variety of key sizes Θ Θ Θ ▲ ▲ Ο ▲ Θ ▲ Ο ▲ 0.7
9 9 6.8 5.0 Holds a lot of keys Ο Θ Θ Θ ▲ ▲ Ο Ο Ο Ο Ο Ο Ο Ο Ο Θ Ο ▲ Ο Ο Ο Ο 0.66
10 9 9.5 7.0 Is durable Ο Ο ▲ ▲ Θ Ο Ο Ο Ο Ο 0.62
11 3 6.8 5.0 Is affordable ▲ ▲ ▲ Ο Ο ▲ Ο Ο ▲ ▲ 0.58
12 9 13.5 10.0 Organizes keys Θ Θ Θ ▲ Θ Ο ▲ Θ Θ Θ Θ 0.54
13 9 4.1 3.0 Can combine and separate subsets of keys Ο Ο Ο Ο Ο Ο Ο Ο ▲ ▲ ▲ Ο ▲ Θ Θ ▲ Ο Ο Θ Θ 0.5
14 0.0 0.46
15 0.0 0.42
16 0.0 0.38
17 0.0 0.34
18 0.0 0.3
19 0.0 0.26
20 0.0 0.22
21 0.0 0.18
22 0.0 0.14
23 0.0 0.1
24 0.0 0.06
25 0.0 0.02
Target or Limit Value 163.5 400.0 400.0 381.1 109.5 277.0 367.6 360.8 68.9 68.9 532.4 182.4 150.0 167.6 150.0 105.4 529.7 209.5 140.5 393.2 308.1 360.8 354.1 81.1 100.0
Difficulty (0=Easy to Accomplish, 10=Extremely Difficult)
Max Relationship Value in Column 9 9 9 9 3 9 9 9 9 9 9 9 9 9 9 3 9 9 3 9 9 9 9 3 3
Weight / Importance 163.5 400.0 400.0 381.1 109.5 277.0 367.6 360.8 68.9 68.9 532.4 182.4 150.0 167.6 150.0 105.4 529.7 209.5 140.5 393.2 308.1 360.8 354.1 81.1 100.0
Relative Weight 2.6 6.3 6.3 6.0 1.7 4.4 5.8 5.7 1.1 1.1 8.4 2.9 2.4 2.6 2.4 1.7 8.3 3.3 2.2 6.2 4.8 5.7 5.6 1.3 1.6 Powered by QFD Online (http://www.QFDOnline.com)
Numeric Values for Relationship Matrix Calculations
1 8.1 1 9 9 9 3 9 0 0 0 0 9 9 0 3 0 3 3 1 0 0 0 3 3 3 3
2 4.1 1 9 9 9 3 9 0 0 0 0 9 0 9 3 0 3 3 1 0 0 0 3 3 3 3
3 9.5 9 9 9 9 3 9 0 0 0 0 3 0 0 9 0 0 3 1 0 0 0 3 3 1 3
4 4.1 0 0 0 0 0 3 0 0 9 9 1 0 0 0 0 0 1 0 3 3 1 0 0 0 0
5 9.5 1 3 3 1 1 3 9 9 0 0 9 9 9 0 0 1 3 1 3 9 3 1 1 3 3
6 13.5 0 0 0 0 0 0 9 9 0 0 9 0 0 0 0 1 9 1 3 9 9 3 3 0 0
7 4.1 9 9 9 9 0 0 0 0 0 0 0 0 1 3 3 0 9 0 0 0 0 3 3 0 0
8 6.8 0 9 9 9 0 1 1 0 0 0 3 0 0 0 0 0 1 9 1 3 0 1 0 0 0
9 6.8 3 9 9 9 1 1 3 3 3 3 3 3 3 3 3 0 9 3 1 3 3 3 3 0 0
10 9.5 0 0 0 0 3 3 0 0 0 0 1 0 0 1 9 3 3 0 3 0 0 3 3 0 0
11 6.8 0 1 1 1 0 0 0 0 0 0 0 0 0 0 3 0 3 1 0 0 0 3 3 1 1
12 13.5 0 0 0 0 0 0 9 9 0 0 9 0 0 0 0 1 9 3 1 9 9 9 9 0 0
13 4.1 0 3 3 3 0 0 3 3 3 3 3 1 1 1 3 1 9 9 1 3 3 9 9 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
163.5135135135 163.5135135135 400 400 400 400 381.0810810811 381.0810810811 109.4594594595 109.4594594595 277.027027027 277.027027027 367.5675675676 367.5675675676 360.8108108108 360.8108108108 68.9189189189 68.9189189189 68.9189189189 68.9189189189 532.4324324324 532.4324324324 182.4324324324 182.4324324324 150 150 167.5675675676 167.5675675676 150 150 105.4054054054 105.4054054054 529.7297297297 529.7297297297 209.4594594595 209.4594594595 140.5405405405 140.5405405405 393.2432432432 393.2432432432 308.1081081081 308.1081081081 360.8108108108 360.8108108108 354.0540540541 354.0540540541 81.0810810811 81.0810810811 100 100
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.
Our Company 0.98 0.94 0.9 0.86 0.82 0.78 0.74 0.7 0.66 0.62 0.57999999999999996 0.54 0.5 0.46 0.42 0.38 0.34 0.3 0.26 0.22 0.18 0.14000000000000001 0.1 0.06 0.02 Competitor 1 0.98 0.94 0.9 0.86 0.82 0.78 0.74 0.7 0.66 0.62 0.57999999999999996 0.54 0.5 0.46 0.42 0.38 0.34 0.3 0.26 0.22 0.18 0.14000000000000001 0.1 0.06 0.02 Competitor 2 0.98 0.94 0.9 0.86 0.82 0.78 0.74 0.7 0.66 0.62 0.57999999999999996 0.54 0.5 0.46 0.42 0.38 0.34 0.3 0.26 0.22 0.18 0.14000000000000001 0.1 0.06 0.02 Competitor 3 0.98 0.94 0.9 0.86 0.82 0.78 0.74 0.7 0.66 0.62 0.57999999999999996 0.54 0.5 0.46 0.42 0.38 0.34 0.3 0.26 0.22 0.18 0.14000000000000001 0.1 0.06 0.02 Competitor 4 0.98 0.94 0.9 0.86 0.82 0.78 0.74 0.7 0.66 0.62 0.57999999999999996 0.54 0.5 0.46 0.42 0.38 0.34 0.3 0.26 0.22 0.18 0.14000000000000001 0.1 0.06 0.02 Competitor 5 0.98 0.94 0.9 0.86 0.82 0.78 0.74 0.7 0.66 0.62 0.57999999999999996 0.54 0.5 0.46 0.42 0.38 0.34 0.3 0.26 0.22 0.18 0.14000000000000001 0.1 0.06 0.02

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 2.6 163.5 Product weight 163.5135135135
2 0.0 6.3 400.0 Length 400
3 0.0 6.3 400.0 Width 400
4 0.0 6.0 381.1 Thickness 381.0810810811
5 0.0 1.7 109.5 Edge radii of case or protruding surfaces 109.4594594595
6 0.0 4.4 277.0 Range of free motion when not in use 277.027027027
7 0.0 5.8 367.6 Average operation time 367.5675675676
8 0.0 5.7 360.8 Average time of focused concentration 360.8108108108
9 0.0 1.1 68.9 Peak noise level 68.9189189189
10 0.0 1.1 68.9 Average noise level 68.9189189189
11 0.0 8.4 532.4 Average result, ease ofe use test 532.4324324324
12 0.0 2.9 182.4 Average pocket insertion time 182.4324324324
13 0.0 2.4 150.0 Average pocket removal time 150
14 0.0 2.6 167.6 Average comfort test results 167.5675675676
15 0.0 2.4 150.0 Strength of critical functional components 150
16 0.0 1.7 105.4 Flexibility 105.4054054054
17 0.0 8.3 529.7 Total Key Capacity 529.7297297297
18 0.0 3.3 209.5 Maximum key length 209.4594594595
19 0.0 2.2 140.5 Clearance between moving parts 140.5405405405
20 0.0 6.2 393.2 Average time to find proper key 393.2432432432
21 0.0 4.8 308.1 Avg. frequency of wrong key selection 308.1081081081
22 0.0 5.7 360.8 # of separable modules 360.8108108108
23 0.0 5.6 354.1 Size of possible subsets 354.0540540541
24 0.0 1.3 81.1 Surfcae texture 81.0810810811
25 0.0 1.6 100.0 surface tackiness 100
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
Numeric Values for Relationship Matrix Calculations
1 2.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
2 6.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
3 6.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
4 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
5 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
6 4.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
7 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
8 5.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
9 1.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
10 1.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
11 8.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
12 2.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
13 2.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
14 2.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
15 2.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
16 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
17 8.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
18 3.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
19 2.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 6.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 4.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
22 5.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
23 5.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
24 1.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
25 1.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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 163.5135135135
2 0.0 400
3 0.0 400
4 0.0 381.0810810811
5 0.0 109.4594594595
6 0.0 277.027027027
7 0.0 367.5675675676
8 0.0 360.8108108108
9 0.0 68.9189189189
10 0.0 68.9189189189
11 0.0 532.4324324324
12 0.0 182.4324324324
13 0.0 150
14 0.0 167.5675675676
15 0.0 150
16 0.0 105.4054054054
17 0.0 529.7297297297
18 0.0 209.4594594595
19 0.0 140.5405405405
20 0.0 393.2432432432
21 0.0 308.1081081081
22 0.0 360.8108108108
23 0.0 354.0540540541
24 0.0 81.0810810811
25 0.0 100
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
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 163.5135135135
2 0.0 400
3 0.0 400
4 0.0 381.0810810811
5 0.0 109.4594594595
6 0.0 277.027027027
7 0.0 367.5675675676
8 0.0 360.8108108108
9 0.0 68.9189189189
10 0.0 68.9189189189
11 0.0 532.4324324324
12 0.0 182.4324324324
13 0.0 150
14 0.0 167.5675675676
15 0.0 150
16 0.0 105.4054054054
17 0.0 529.7297297297
18 0.0 209.4594594595
19 0.0 140.5405405405
20 0.0 393.2432432432
21 0.0 308.1081081081
22 0.0 360.8108108108
23 0.0 354.0540540541
24 0.0 81.0810810811
25 0.0 100
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
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/

™

http://www.qfdonline.com/template-terms/ http://www.qfdonline.com/template-terms/ 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/template-terms/ http://www.qfdonline.com/templates/ http://www.qfdonline.com/templates/template-sponsorship/