I just downloaded your AHP Excel template. Also, I paid (donated) per your suggestion via PayPal. I will familiarize with the tool during the next few days. I am doing some research on Credit Risk Analytics. I am familiar with traditional AHP methodology. I may want to try Fuzzy AHP process in my research. Any suggestions from you as to how to use your template or any good reference on fuzzy AHP would be appreciated. Thanks in advance for your assistance. Best Regards.
I want to thank you for developing this template,and I currently doing my MSC.thesis and use AHP process and I have 6 main criteria to evaluate 4 alternatives.I like if you comment on the value of RI(random index for randomly generated matrix)
Thank you very much.
Hi Diriba, in my excel template and in my online software I don’t use RI, but the linear fit proposed by Alonso and Lamata (2006) to calculate the consistency ratio CR. Please see my working paper about the software implementation eq. 2.5. The Alonso & Lamata reference is given under references in the paper.
thank you for the nice Excel tool!
I am writing my master thesis and a survey based on the AHP is part of it. I used a balanced scale for the survey and in the tool, but I cannot fully retrace the results of the Evaluation Matrix.
I guess the tool assumes the scale to have 9 points on each side and the values are distributed based on a quadratic (?) formula. Could you help me with some more information about the theoretical background of your tool ?
fortunately I found it myself but I want to post to answer to my own question, if someone has the same question:
The background information to the scales can be found on page 7 in:
Goepel, K. D. (2017). Implementation of an Online Software Tool for the Analytic Hierarchy Process – Challenges and Practical Experiences. Working paper prepared for publication, Singapore July 2017
First, I like to thank you for making this wonderful tool. It is really helpful, either for companies, students, individuals etc. However, I maybe have some feedback to even more improve this tool. My suggestion is: adding a sensitivity calculation based on the scale (9-1/9). This will result that the ranking scores can be checked. With this sensitivity calculation, the weight of the alternatives will differ. Therefore, another addition could be that the differentiation of the ‘new’ calculated ranking scores can be compared to the original.
Hi Frank,
thanks for your feedback. Sensitivity calculation is implemented, see para 6 and 8 of my working paper about the software implementation. ahp-software
On the result page click on “var” and “refresh” to get the results.
Regards, Klaus
Can you help me? How to use your template if my number of criteria more than 10. total i have 20 criteria. i already key in 10 criteria, another 10, i don’t know how to key in..can you advise me on this matter? thank you
Dear Klaus
Thank you very much for making so nice online tools for multi-criteria decision making using AHP. It is a very useful tool.
I just downloaded your AHP Excel template. Also, I paid (donated) per your suggestion via PayPal. I will familiarize with the tool during the next few days. I am doing some research on Credit Risk Analytics. I am familiar with traditional AHP methodology. I may want to try Fuzzy AHP process in my research. Any suggestions from you as to how to use your template or any good reference on fuzzy AHP would be appreciated. Thanks in advance for your assistance. Best Regards.
I want to thank you for developing this template,and I currently doing my MSC.thesis and use AHP process and I have 6 main criteria to evaluate 4 alternatives.I like if you comment on the value of RI(random index for randomly generated matrix)
Thank you very much.
Hi Diriba, in my excel template and in my online software I don’t use RI, but the linear fit proposed by Alonso and Lamata (2006) to calculate the consistency ratio CR. Please see my working paper about the software implementation eq. 2.5. The Alonso & Lamata reference is given under references in the paper.
Hello Klaus,
thank you for the nice Excel tool!
I am writing my master thesis and a survey based on the AHP is part of it. I used a balanced scale for the survey and in the tool, but I cannot fully retrace the results of the Evaluation Matrix.
I guess the tool assumes the scale to have 9 points on each side and the values are distributed based on a quadratic (?) formula. Could you help me with some more information about the theoretical background of your tool ?
Best regards,
Martin
Hello Klaus,
fortunately I found it myself but I want to post to answer to my own question, if someone has the same question:
The background information to the scales can be found on page 7 in:
Goepel, K. D. (2017). Implementation of an Online Software Tool for the Analytic Hierarchy Process – Challenges and Practical Experiences. Working paper prepared for publication, Singapore July 2017
or under: https://bpmsg.com/wordpress/wp-content/uploads/2017/09/ahp-software.pdf
Thanks,
Martin
Hi Martin,
please see here:
https://bpmsg.com/isahp_2013-13-03-13-goepel/
and here:
https://bpmsg.com/wordpress/wp-content/uploads/2012/04/AHPcalc-v2017-03-29.pdf
See also my posting and paper about AHP scales:
https://bpmsg.com/why-the-ahp-balanced-scale-is-not-balanced/
Regards, Klaus
Dear Klaus,
First, I like to thank you for making this wonderful tool. It is really helpful, either for companies, students, individuals etc. However, I maybe have some feedback to even more improve this tool. My suggestion is: adding a sensitivity calculation based on the scale (9-1/9). This will result that the ranking scores can be checked. With this sensitivity calculation, the weight of the alternatives will differ. Therefore, another addition could be that the differentiation of the ‘new’ calculated ranking scores can be compared to the original.
Greetings, Frank
Hi Frank,
thanks for your feedback. Sensitivity calculation is implemented, see para 6 and 8 of my working paper about the software implementation.
ahp-software
On the result page click on “var” and “refresh” to get the results.
Regards, Klaus
Hi Klaus
Can you help me? How to use your template if my number of criteria more than 10. total i have 20 criteria. i already key in 10 criteria, another 10, i don’t know how to key in..can you advise me on this matter? thank you
Hi Mas, the template cannot handle more than 10 criteria. Use my AHP online SW AHP-OS
Hi Klaus,
Is the online version constrained to a number of criteria and alternatives that you can use? I have some 11 criteria but 11 alternatives.
Thanks,
Warwick
Hi Warwick, you can define up to 20 criteria and up to 12 alternatives.