The consensus of the complete hierarchy is calculated as weighted arithmetic mean of the consensus of all hierarchy nodes (categories); for alternatives, we take the consensus indicator of the consolidated alternative evaluation matrix weighted with the global priorities.
Please see:
Goepel, K.D. (2018). Implementation of an Online Software Tool for the Analytic Hierarchy Process (AHP-OS). International Journal of the Analytic Hierarchy Process, Vol. 10 Issue 3 2018, pp 469-487, https://doi.org/10.13033/ijahp.v10i3.590
I plan to try out the template in our next strategy/priority session. Thank you for making the template available, and the great documentation in the powerpoint.
I would like to be able to change the name of the tab to the participants name so it is clear which tab they own.
I began using your excel template for my research, thank you for providing this!
I wonder if you have an excel template for more than 20 participants since I will have to use more participants for my research. If not, can the spreadsheet be updated easily for new participants and what steps should I follow for this?
I recommend to use my free online software AHP-OS for more complex projects. It can handle hierarchies, alternatives and an practically unlimited number of participants. All results can be exported in csv. https://bpmsg.com/ahp
Good. make it better
thank you for providing this! sir Klaus D. Goepel
Thank you very very much, I proud of you.
The AHP calculated you uploaded works very well.
Do the some thing for others.
It’s difficult understand how to do the clasification. In the begin ing in order to understand, please gives some examples.
Is diversity / group consensus calculation possible for multiple hierarchies? How would we do that?
Do we have to calculate the consensus for each hierarchy set separately, or is an overall aggregate value possible to be realized?
The consensus of the complete hierarchy is calculated as weighted arithmetic mean of the consensus of all hierarchy nodes (categories); for alternatives, we take the consensus indicator of the consolidated alternative evaluation matrix weighted with the global priorities.
Please see:
Goepel, K.D. (2018). Implementation of an Online Software Tool for the Analytic Hierarchy Process (AHP-OS). International Journal of the Analytic Hierarchy Process, Vol. 10 Issue 3 2018, pp 469-487,
https://doi.org/10.13033/ijahp.v10i3.590
I plan to try out the template in our next strategy/priority session. Thank you for making the template available, and the great documentation in the powerpoint.
I would like to be able to change the name of the tab to the participants name so it is clear which tab they own.
Unfortunately renaming the sheets will break the calculation. Just add another sheet with input numbers and names in a table for the participants.
Hi,
I began using your excel template for my research, thank you for providing this!
I wonder if you have an excel template for more than 20 participants since I will have to use more participants for my research. If not, can the spreadsheet be updated easily for new participants and what steps should I follow for this?
Thanks and regards
I recommend to use my free online software AHP-OS for more complex projects. It can handle hierarchies, alternatives and an practically unlimited number of participants. All results can be exported in csv. https://bpmsg.com/ahp