PUGH MATRIX WORKSHEET FEATURES
- Create and manage a Pugh matrix with up to 200 Criteria and 200 Options
- Select a new datum and automatically create a new Pugh matrix
- Add, remove, or insert Criteria and Options with click of a button
- Expand the Pugh Matrix with click of a button
- Each criterion can be weighted
- Sort Criteria and Options by any row or column
- Automatic calculation of scores
- Integrated pareto chart
- Manage information visibility
- Context-sensitive help and right-click popup
- All work is stored in a standard Excel worksheet
Using Pugh Matrix Worksheet in Product Development
Triptych Pugh Matrix Worksheet allows you to rate and rank multiple user-defined design options against multiple user-defined criteria using the qualitative Pugh Matrix approach. Each option is rated as better than, same as, or worse than a datum for each criterion.
- Create a new Pugh Matrix in Triptych
- Add one or more Criteria and assign descriptions
- Enter the Datum
- Add one or more Options and assign descriptions
- For each Criterion, compare each Option against the Datum. From the in-cell drop-down list, select B or Better than Datum or S for Same as Datum, or W for Worse than Datum.
- Select the next Datum and repeat step 5 until the best design option is identified.
