Advanced Statistical Methods and Tools for Product Design
TOPSIS WORKSHEET
TOPSIS (Technique for Order Preference by Similarity to Ideal Solution) is a decision making technique that fits between the qualitative Pugh Matrix and quantitative SDI Matrix approaches. TOPSIS is a Goal-based approach for finding the alternative that is closest to the ideal solution
Enter the name for this tabbed section: Features
- Create and manage a TOPIS matrix with up to 200 Criteria and 200 Options
- Add, remove, or insert Criteria and Options with click of a button
- Expand the TOPSIS Matrix with click of a button
- Each criterion can be weighted
- Sort Criteria and Options by any row or column
- Automatic calculation of scores
- Check inputs for errors.
- Integrated pareto chart
- Manage information visibility
- Context-sensitive help and right-click popup
- All work is stored in a standard Excel worksheet
Enter the name for this tabbed section: How It Works
The basic concept of this method is that the selected Design Options should have the shortest distance from the ideal solution and the farthest from the negative-ideal solution (in a geometric sense). The Euclidean distance approach is used to evaluate the relative closeness of each Design Option to the Ideal solution.
TOPSIS approach:
TOPSIS assumes that each Design Option wants to either be maximized or minimized, so the positive-ideal solution for a Criterion that wants to be maximized is the maximum value of all the design options considered and the negative-ideal solution is the minimum values of all the design options considered.
TOPSIS approach:
- Create matrix with Design Options and Criteria
- Assign Importance to Criteria
- Enter Design Option data for each Criteria
- Assign goal direction (Minimize or Maximize)
- Compute and Evaluate Scores
TOPSIS assumes that each Design Option wants to either be maximized or minimized, so the positive-ideal solution for a Criterion that wants to be maximized is the maximum value of all the design options considered and the negative-ideal solution is the minimum values of all the design options considered.
Enter the name for this tabbed section: Video Demo
http://www.youtube.com/watch?v=eWvVcTqMpxY
Multi-Criteria Design Selection using Triptych
