Suppose an investor wants to evaluate three investment opportunities: A, B, and C. The investor has identified three criteria: return on investment (ROI), risk, and liquidity. Criteria Sub-criteria ROI High, Medium, Low Risk High, Medium, Low Liquidity High, Medium, Low Using the Fuzzy AHP Excel template, the investor performs fuzzy pairwise comparisons between the criteria and sub-criteria. The results are: Criteria Fuzzy weight ROI 0.45 Risk 0.30 Liquidity 0.25 The investor then evaluates the three investment opportunities against each criterion, using fuzzy numbers. The results are: Alternative ROI Risk Liquidity A High Medium Low B Medium Low High C Low High Medium The Fuzzy AHP Excel template calculates the aggregated fuzzy weights and rankings of the alternatives: Alternative Fuzzy score A 0.62 B 0.55 C 0.33 The results indicate that investment opportunity A has the highest fuzzy score, followed by B and C.
By integrating fuzzy logic into AHP, Fuzzy AHP enables decision-makers to handle uncertain and imprecise data, making it a more robust and realistic approach for complex decision-making problems. Fuzzy Ahp Excel Template
To make Fuzzy AHP more accessible and user-friendly, we have created a Fuzzy AHP Excel template. This template allows users to easily apply Fuzzy AHP to their decision-making problems, without requiring extensive knowledge of fuzzy logic or programming. Suppose an investor wants to evaluate three investment