Crisp weight ( W_i = \fracl_i + m_i + u_i3 )
Even in fuzzy environments, consistency matters. A good template converts fuzzy matrices to crisp Saaty matrices (using defuzzification like the graded mean integration or alpha-cut at μ=0.5) and calculates: fuzzy ahp excel template
Some templates simply run standard AHP on fuzzy-number midpoints. That’s wrong. True fuzzy AHP maintains TFNs throughout the geometric mean and normalization steps. Fix: Examine formula cells – if you see only single values (not three cells per weight), it’s not true fuzzy AHP. Crisp weight ( W_i = \fracl_i + m_i