If an expert has been deleted, the expert’s status is “deleted” and you can recovery data. In simple words, we tried to explain how to implement TOPSIS in excel For AHP and FUZZY AHP in excel please. If all the expert data are not completed, the expert’s status is “incompleted”. If all the expert data are completed and saved, the expert’s status is “completed”. Mean: The fuzzy average of all the experts will be observed by clicking on the button “Mean”.Īs you can see in the picture below, the experts’ status include the following: The experts’ Status: The experts’ Status will be displayed by clicking on the button “The experts Status” Fuzzy Topsis software Enter Demo Working with fuzzy Topsis software is very simple: 1. Save Expert: The data of current expert will be saved by clicking on the button “Save Expert”. The workbook consists of 20 input worksheets for pair-wise comparisons, a sheet for the consolidation of all judgments, a summary sheet to display the result, a sheet with reference tables (random index, limits for geometric consistency index GCI, judgment scales) and a sheet for solving the eigenvalue problem. In the formula, is triangular fuzzy numbers of pairwise comparison matrices. The AHP Excel template works under Office Libre and Excel version MS Excel 2013. Where i represents the row number and j denotes the column number. The previous expert will be automatically saved by clicking on the button “Add Expert” and the new expert will be added.ĭelete Expert: The current expert will be deleted by clicking on the button “Delete Expert”. STEP 4: Calculate for each row of the pair-wise comparison matrix. As you can see on the picture above, experts include the following:Īdd Expert: If there are several experts, you can increase the number of experts by clicking “Add Expert”.
