In Excel, use the =GEOMEAN() function across the lower, middle, and upper columns individually.

| Linguistic term | TFN (l, m, u) | |----------------|----------------| | Equal importance | (1, 1, 1) | | Weak importance | (2, 3, 4) | | Strong importance | (4, 5, 6) | | Very strong | (6, 7, 8) | | Absolute | (8, 9, 9) |

Allows users to focus on pairwise comparisons rather than complex arithmetic. Flexibility: Easily adjust inputs and see updated results. Components of a Functional Fuzzy AHP Excel Template

Crisp Weight (M)=l+m+u3Crisp Weight open paren cap M close paren equals the fraction with numerator l plus m plus u and denominator 3 end-fraction

) for each row, representing the relative importance of criteria. 5. Fuzzy Weights Calculation

⚠️ : Many free templates contain errors in fuzzy multiplication or reciprocal handling. Validate with a known example from literature.

You can quickly add rows for new criteria or modify scales to fit your specific industry.

For each criterion, users compare the actual options against each other (e.g., Vendor A vs. Vendor B under the "Cost" criterion).