How to use the AHP excel template in a project?

Q: I’m very new to AHP and I want to use it to identify which country is the best location to offshore a certain function of a company for my MBA project. I need to find relative importance of different factors for such decision and the relative ranking of different ountries from those factors.

How do I use this excel for such purpose? Do I run it multiple times; first for finding the priority of the factors, and then for the comparison of the countries one by one for each of the factors? And lastly multiply the priorities of the factors by each country’s priority? Is there an easier way via your template to do it?

A: There is no easier way. My template only calculates the priorities of factors in one single category of a hierarchy. If you have different categories, you have to run it multiple times (once in each category/ sub-category); then calculate the final weighting factors and make the evaluation of alternatives in your own sheet. NEW since Dec 2013: You might also use my online tool BMPSG AHP hierarchy.

I cannot generalize my template, as the hierarchy could be very different from one to another project.

News from BPMSG

I’m really getting lazy …
No update of my web site since May 2012; page rank down from 3 to 2. What is going on?

It seems less questions coming up regarding my AHP excel template, though the number of downloads is quite stable. I am still curious to know about your applications; so please kindly feedback, if you are using the template for your study or work.

In between I upgraded my video equipment, using a Canon XA10 video camera and Adobe Premier Elements for editing. I produced a couple of videos for work and on holidays. Very satisfied with the results, brilliant quality in HD. Hopefully I will find some time to share my experience here or on  my Youtube channel,  so just stay connected.

Thanks so far!

Klaus

September 2012

P.S. Update Nov 8th, 2012 – Now having  problems with my XA-10 Camcorder