Fuzzy Ahp Excel | Template [hot]

Because we are dealing with fuzzy arithmetic, you must divide by the inverted sum of the columns: wilw sub i l end-sub = rilr sub i l end-sub divided by the sum of all upper values ( wimw sub i m end-sub = rimr sub i m end-sub divided by the sum of all middle values ( wiuw sub i u end-sub = riur sub i u end-sub divided by the sum of all lower values ( In Excel, this looks like: =Row_L / SUM(All_U_Column) Step 4: Defuzzification (De-fuzzing the Data)

Now you have fuzzy weights expressed as triplets. To rank your criteria, you must convert these triplets back into single "crisp" percentages. The most reliable method is the method: fuzzy ahp excel template

To build your Excel template, you must convert the traditional 1–9 Saaty scale into TFN intervals. Below is the standard conversion matrix used in data modeling: Linguistic Variable Traditional AHP Scale Triangular Fuzzy Number (TFN) Reciprocal TFN (Inverse Comparison) Equally Important Moderately Preferred Strongly Preferred Very Strongly Preferred Extremely Preferred Intermediate Values 2, 4, 6, 8 Reciprocal of TFN Step-by-Step Architecture of a Fuzzy AHP Excel Template Because we are dealing with fuzzy arithmetic, you