To build your Excel template, you must first establish a standard evaluation scale. Buckley’s method and Chang’s extent analysis are the two most popular frameworks. Below is a standard triangular fuzzy scale commonly used in FAHP templates: Linguistic Variable Crisp Scale Fuzzy Number Reciprocal Fuzzy Number Equally Important Moderately Preferred Strongly Preferred Very Strongly Preferred Extremely Preferred Intermediate Values 2, 4, 6, 8 Add/subtract 1 from Calculate reciprocals accordingly 3. Step-by-Step Guide to Building the Excel Template

, the reciprocal comparison (Criterion B to Criterion A) must be the mathematical inverse:

Example matrix (C vs S):

Let's say you are choosing a software vendor based on three criteria: .

A commonly cited application of FAHP is selecting the best location for a project, such as a new dry port.