This excel worksheet for AHP is fantastic. I’m investigating the possibility of using it for project prioritization. Do you have any thoughts on how I could use this worksheet to weight the criterion and then rate different projects based on the criterion? For example, if I have criterion for cost, safety, and reliability. Then I list all projects and compare each project as it relates to cost, then each project as it relates to safety, etc… My thoughts are to get the weights for each criterion then make each participant a criterion result with the weights. Then use the criterion in your worksheet as the projects. Your thoughts???
Hi Chris,
yes, first you have to determine the weights for cost, safety and reliability in one template. Then for each of theses categories the weights of sub-criteria in another template. Multiply the weights of sub-criteria with the weights of categories to normalize from local to global priorities. Project evaluation by applying global priorities for each subcategory. See also here http://bpmsg.com/how-to-use-the-ahp-template-in-a-project/
I was looking at the excel model you had provided as a link here. I wanted to know how you assigned the liner regression coefficients to the part worth utilities.
“Color” is assigned the utility of -0.25; excel cell reference = “F32”
“Memory” is assigned the utility of -2.0; excel cell reference =”E32″
“Delivery” is assigned the utility of -1.0; excel cell reference=”D32″
“Price” is assigned the utility of -0.25; excel cell reference =”C32″
In an AHP model, how does the different levels matter? I mean which entity is at the first level, and which one at the next, etc.? I can understand criteria and sub-criteria, but what about other totally different types of entities like ‘Actors’? What level should they be in? If you can tell us about the significance of ‘levels’ in AHP model design.
I don’t really understand your question. You have to structure/organize your project hierarchically: Highest level is the objective, next level the main criteria, next level subcriteria and so on. Actors ( if I understand them as stakeholders or decision makers) do the judgment as pairwise comparisons. You might have different stakeholders at different levels.
I am referring to “T.L. Saaty. The Analytic Hierarchy Process, Planning, Priority Setting, Resource Allocation. McGraw-Hill, New York, 1980”, “Section 6-5: Future of higher education in the United States (1985-2000)”;
There, at Level 1 we have “Focus”, at Level 2, “Primary Factors”, at Level 3-Actors, level 4- Objectives, level 5-Contrasting scenarios (Composite scenarios).
If you could look at the question on the above basis.
I need to use the AHP method in a variety of cases, some have 2 variables and other 45 variables. Also I have about 100 participant. Is there any chance I can have a modify version that meets my needs?
Hi, Klaus
I’m kind new at AHP, but I can clearly see your template benefits. I have two questions:
1- Is it possible to enter multi level criteria?
2- How to evaluate alternatives regarding those criteria?
Thank you very much
Sergio
Hi Sergio,
the sheet only calculates priorities for one category/set of criteria. Please see also here. How to evaluate alternatives is shown for example in my AHP video .
regards, Klaus
Excellent piece of Work.
Very useful tool for researchers.
Please keep it up and improve upon where ever required like for eg increase in number of respondents beyond 20 etc.
Warm regards
Thanks! Always a question of available time 😉
This excel worksheet for AHP is fantastic. I’m investigating the possibility of using it for project prioritization. Do you have any thoughts on how I could use this worksheet to weight the criterion and then rate different projects based on the criterion? For example, if I have criterion for cost, safety, and reliability. Then I list all projects and compare each project as it relates to cost, then each project as it relates to safety, etc… My thoughts are to get the weights for each criterion then make each participant a criterion result with the weights. Then use the criterion in your worksheet as the projects. Your thoughts???
Hi Chris,
yes, first you have to determine the weights for cost, safety and reliability in one template. Then for each of theses categories the weights of sub-criteria in another template. Multiply the weights of sub-criteria with the weights of categories to normalize from local to global priorities. Project evaluation by applying global priorities for each subcategory. See also here http://bpmsg.com/how-to-use-the-ahp-template-in-a-project/
Thank you for the Free-Tabel. It was very helpful for my Bachelor-thesis.
Hi,
I was looking at the excel model you had provided as a link here. I wanted to know how you assigned the liner regression coefficients to the part worth utilities.
“Color” is assigned the utility of -0.25; excel cell reference = “F32”
“Memory” is assigned the utility of -2.0; excel cell reference =”E32″
“Delivery” is assigned the utility of -1.0; excel cell reference=”D32″
“Price” is assigned the utility of -0.25; excel cell reference =”C32″
Look forward to your reply.
Thanks,
Mathew
Hi Mathew,
you are right. Color: F32, Mem: E32 etc.
In Excel the linest function outputs the slopes in the order
m(n), m(n-1),m(n-2)…m(1)
regards,
Klaus
Hi Klaus: thanks for your inputs.
In an AHP model, how does the different levels matter? I mean which entity is at the first level, and which one at the next, etc.? I can understand criteria and sub-criteria, but what about other totally different types of entities like ‘Actors’? What level should they be in? If you can tell us about the significance of ‘levels’ in AHP model design.
Thx and Rgds, S Roy
I don’t really understand your question. You have to structure/organize your project hierarchically: Highest level is the objective, next level the main criteria, next level subcriteria and so on. Actors ( if I understand them as stakeholders or decision makers) do the judgment as pairwise comparisons. You might have different stakeholders at different levels.
Hi Klaus,
I am referring to “T.L. Saaty. The Analytic Hierarchy Process, Planning, Priority Setting, Resource Allocation. McGraw-Hill, New York, 1980”, “Section 6-5: Future of higher education in the United States (1985-2000)”;
There, at Level 1 we have “Focus”, at Level 2, “Primary Factors”, at Level 3-Actors, level 4- Objectives, level 5-Contrasting scenarios (Composite scenarios).
If you could look at the question on the above basis.
Rgds, S Roy
Hi
I need to use the AHP method in a variety of cases, some have 2 variables and other 45 variables. Also I have about 100 participant. Is there any chance I can have a modify version that meets my needs?
Thanks
Cesar P
Better to use a commercial software. 45 variables (in one level) means nearly 2000 pair wise comparisons – not feasible. Regards, Klaus
Hi Klaus, Can we split the variables? Say into two levels, 5 in the 1st level, and around 9 in the second?
Thx, SRoy
yes, you can. Depends on how you structure your hierarchy.
Mr. Goepel, thank you very much for your teaching about AHP method.
It is very useful for preparing my assignments in master program.
Genius doc! thanks for sharing!
Hi, Klaus
I’m kind new at AHP, but I can clearly see your template benefits. I have two questions:
1- Is it possible to enter multi level criteria?
2- How to evaluate alternatives regarding those criteria?
Thank you very much
Sergio
Hi Sergio,
the sheet only calculates priorities for one category/set of criteria. Please see also here. How to evaluate alternatives is shown for example in my AHP video .
regards, Klaus
your sheet is good but limited upto 8 entries
A new version is in preparation for 10 criteria and 10 participants. It will also highlight inconsistencies in the pair-wise comparisons.