Dear Klaus,
In the summary sheet, the formula in cell C65 points to the @RGGM2 array, but prints an incorrect formula. Could it be that the @RGGM2 array is not defined?
Attila
C64=50%, but in C65 is error!
I use this file: AHPcalc-2022-07-08.xlsx
I could repair it, now it’s working fine.
I have the same error, how did you solve it?
Hi Dr Klaus,
Based on your paper entitled “Implementation of an Online software tool for the Analytic Hierarchy Process (AHP-OS)”, I am referring to section 3.2 – Partial judgments.
I want to know what scale (from 1 to 9) I should use if a particular requirement is not chosen to be evaluated.
I only want to give input for a particular node, not the whole node.
So, what scale should I choose for nodes that are not involved?
Hi Klaus,
1. On the excel version_summary there is p=selected participants, what it means?
2. On the sheet_In there is a statement “once completed you might adjust highlighted comparations 1 to 3 to improve consistency, kindly explain to me
Regards
Felix
Felix,
all explained in the pdf attached to the template. Please download the latest version, I made some corrections a few days ago.
p = selection of participant (In1, In2, …)
2. Inconsistent judgments on the input sheet will be highlighted, so you can adjust to be more consistent.
Klaus
Hi Klaus, I just saw your excel version. Do you mind to explain me about WEIGHT that we input beside the Participant name? The Eigenvector value changed if we change the weight value. Thanks so much
Hi Felixianus, the weight beside the participant name will give this participant more weight of his/her judgment. A weight of 2, for example, is like two participants would have given this judgment.
INDIKATOR YANG DIIGUNAKAN UNTUK MENGUKUR PELUANG TERJADINYA BANJIR, SEBAIKNYA DITAMBAHKAN DENGAN PERILAKU MANUSIA DALAM MENJAGA LINGKUNGANNYA, SEPERTI PERILAKU MEMBUANG SAMPAH PADA SUNGAI ATAU DRAINASE.
This template has an error when using “n” more than 8 (9 and 10) psi value on cell =k32 shown #REF! (the error is cell Z68, AA68, AA69, AC68, AC69, AC70) fix by copy cell Z67, AA67, AC67 and replace to those error cell
It is highly appreciated,and needs implementation of this policy .Thanking you for giving me an opportunity in this working group.
Dear Klaus,
In the summary sheet, the formula in cell C65 points to the @RGGM2 array, but prints an incorrect formula. Could it be that the @RGGM2 array is not defined?
Attila
Dear Attila,
sorry for my late reply, I was traveling.
RGGM2 is defined. What do you mean by “prints an incorrect formula”?
Try to choose N=2, n=2 and see cell C65 on page Summary!
Yes, C65 = 50%. Why?
C64=50%, but in C65 is error!
I use this file: AHPcalc-2022-07-08.xlsx
I could repair it, now it’s working fine.
I have the same error, how did you solve it?
Hi Dr Klaus,
Based on your paper entitled “Implementation of an Online software tool for the Analytic Hierarchy Process (AHP-OS)”, I am referring to section 3.2 – Partial judgments.
I want to know what scale (from 1 to 9) I should use if a particular requirement is not chosen to be evaluated.
I only want to give input for a particular node, not the whole node.
So, what scale should I choose for nodes that are not involved?
Amazing content. Very clearly explained with visualization features.
Hi Klaus,
1. On the excel version_summary there is p=selected participants, what it means?
2. On the sheet_In there is a statement “once completed you might adjust highlighted comparations 1 to 3 to improve consistency, kindly explain to me
Regards
Felix
Felix,
all explained in the pdf attached to the template. Please download the latest version, I made some corrections a few days ago.
p = selection of participant (In1, In2, …)
2. Inconsistent judgments on the input sheet will be highlighted, so you can adjust to be more consistent.
Klaus
Hi Klaus, I just saw your excel version. Do you mind to explain me about WEIGHT that we input beside the Participant name? The Eigenvector value changed if we change the weight value. Thanks so much
Hi Felixianus, the weight beside the participant name will give this participant more weight of his/her judgment. A weight of 2, for example, is like two participants would have given this judgment.
INDIKATOR YANG DIIGUNAKAN UNTUK MENGUKUR PELUANG TERJADINYA BANJIR, SEBAIKNYA DITAMBAHKAN DENGAN PERILAKU MANUSIA DALAM MENJAGA LINGKUNGANNYA, SEPERTI PERILAKU MEMBUANG SAMPAH PADA SUNGAI ATAU DRAINASE.
This template has an error when using “n” more than 8 (9 and 10) psi value on cell =k32 shown #REF! (the error is cell Z68, AA68, AA69, AC68, AC69, AC70) fix by copy cell Z67, AA67, AC67 and replace to those error cell
Yes, I am aware. Will update and upload a modified version, Thanks!