Fuzzy topsis excel template

broken image
broken image

In the above formulas,, and are the first, second, and third components of the fuzzy numbers, respectively. The following is the structure of this paper: First, principles of SSS by reviewing GSCM, social duty, and determining sustainability standards that affect the company’s purchasing decisions are reviewed (Iqbal et al., 2020).

broken image
broken image

The values of and can be calculated by using the following formulas, respectively: In the formula, is triangular fuzzy numbers of pairwise comparison matrices. Where i represents the row number and j denotes the column number. STEP 4: Calculate for each row of the pair-wise comparison matrixĬan be calculated using the following formula: If there are several experts, elements of a complete pairwise comparison matrix used in the fuzzy AHP method is a triangular fuzzy number where the first component (l) is the least comments, the second component (m) is the mean of numbers and the third component (u) is the maximum number. Hasin, Comparative Analysis of TOPSIS and Fuzzy TOPSIS for the Evaluation. The pair-wise comparison matrix can be expressed as follows : methods on Excel) in terms of the differences number in position on the data. The steps of the fuzzy AHP technique using Chang’s method can be given as follows: STEP 1: Draw the hierarchical chart STEP 2: Define fuzzy numbers for performing the pair-wise comparisons STEP 3: Create the pair-wise comparison matrix using fuzzy numbers

broken image