) for each row, representing the relative importance of criteria. 5. Fuzzy Weights Calculation
A well‑designed fuzzy AHP template not only handles the heavy arithmetic but also guides the user through the entire decision process, from building the hierarchy to interpreting the consistency ratio and final weights.
r̃i=(ril,rim,riu)r tilde sub i equals open paren r sub i l end-sub comma r sub i m end-sub comma r sub i u end-sub close paren Step 4: Compute Fuzzy Weights fuzzy ahp excel template
(1u,1m,1l)open paren 1 over u end-fraction comma 1 over m end-fraction comma 1 over l end-fraction close paren In Excel, if cell B2 contains , C2 contains , and D2 contains , the reciprocal cell will use =1/D2 , =1/C2 , and =1/B2 . Step 2: Calculating Fuzzy Geometric Means
Before touching Excel, draw your decision problem. E.g., Select Best Supplier. ) for each row, representing the relative importance
Create separate sheets for criteria and alternative pairwise comparison matrices. Lay out a ( n \times n ) matrix for each level of the hierarchy. Input each expert's linguistic judgments. Use Excel's data validation to restrict inputs to your defined linguistic terms, preventing entry errors.
: Provides a widely used AHP Excel Template that supports multiple decision-makers and consistency checks, though it focuses on "crisp" AHP (you can adapt it by adding fuzzy columns). r̃i=(ril,rim,riu)r tilde sub i equals open paren r
Next to your visual grid, create the hidden mathematical grid. Use an IF statement to handle the diagonal and reciprocal cells: =IF(Row=Column, 1, VLOOKUP(Cell, ScaleRange, ColumnIndex, FALSE)) Step 3: Compute Row Totals
Once defuzzified, these values are normalized so that the final criteria weights add up to exactly 1.0 or 100%. 5. Consistency Ratio (CR) Check