Fuzzy topsis excel template

broken image

Normalisation is usually required as the parameters or criteria are often of incongruous dimensions in multi-criteria problems. An assumption of TOPSIS is that the criteria are monotonically increasing or decreasing. The weights of the criteria in TOPSIS method can be calculated using Ordinal Priority Approach, Analytic hierarchy process, etc. It is a method of compensatory aggregation that compares a set of alternatives, normalising scores for each criterion and calculating the geometric distance between each alternative and the ideal alternative, which is the best score in each criterion. A dedicated book in the fuzzy context was published in 2021 Description TOPSIS is based on the concept that the chosen alternative should have the shortest geometric distance from the positive ideal solution (PIS) and the longest geometric distance from the negative ideal solution (NIS). The Technique for Order of Preference by Similarity to Ideal Solution ( TOPSIS) is a multi-criteria decision analysis method, which was originally developed by Ching-Lai Hwang and Yoon in 1981 with further developments by Yoon in 1987, and Hwang, Lai and Liu in 1993. ( April 2018) ( Learn how and when to remove this template message) Please help improve it to make it understandable to non-experts, without removing the technical details. This article may be too technical for most readers to understand.

broken image