Klaus D. Goepel, BPMSG, Contact, last update: Sep 4, 2017
267 thoughts on “Feedback”
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 ?
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
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
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.