Templates
QFD 2

QFD 2 Matrix of CTQs to Functions. To be used to prioritize Functions from CTQs.
Note: Both Functions and CTQs form part of Axiomatic Design's Functional Requirements domain.
The consequent use of the list of functional requirements with functions on the top hierarchy levels and CTQs as sub items of functions already defines relations between CTQs and functions. By using the copy link mechanism, even n to m relations can be handled. Functions can be prioritized by simply summing up priorities of the subitem CTQs. All this makes use of a QFD 2 matrix obsolete.
Use the QFD 2 matrix only if you do not want to sort CTQs under functions or you have many relations from CTQs to different functions.
Worksheets
QFD2

CTQs
This is the list of critical to quality items (CTQs). It is a subset of the list of functional requirements showing CTQs only.Importance (CTQs)
This table shows the importance values of functional requirements. As the list at the left only shows CTQs, the table will show importances of CTQs only. Importance values usually are calculated from QFD 1 by linear mapping or by use of another prioritization method, e.g. AHP.Functions
This is the list of functions. It is a subset of the list of functional requirements showing functions only.QFD2
The central matrix defines relations between the functions (top) and the CTQs (left).Importance (Functions)
The priorities for functions are calculated by linear mapping from the QFD 2 matrix and the CTQ priorities. In order to use the QFD 2 matrix for function prioritization, make sure that the calculation method is set correctly.
Checking the calculation method
- click into a cell in table Importance (Functions)
- click f(x) left of the formula edit line

Select QFD2 to be used as calculation method for functions.
Roadmap
More Worksheets
Need more information? Open questions? Please let us know.