Updated AHP Excel Template Version 2014-05-09

Thanks to feedback from Benedikt, this latest update contains a minor change, to show the convergence of the power method, when calculating the eigenvalue. In the summary sheet a threshold (squared Euclidean distance d2) can be set, to show how many iterations it takes, until the change of the approximated eigenvector is below the given threshold. By default the value is set to Thresh: 1E-07:

thrh

In the above example it takes 7 iterations until d2 is below 1E-07. The actual difference is  3.5E-08 (EVM check). As the number of iterations in the template is fixed to 12, care should be taken if the value reaches 12.

You might download the latest version from my AHP template download page.

Welcome to BPMSG – May 2014

Concepts, Methods and Tools to manage Business Performance

Dear Friends, dear Visitors,

The latest beta version of my AHP online software (AHP-OS) has now additional features to manage complete AHP projects. AHP stands for Analytic Hierarchy Process, and is a decision support tool.  To use the full functionality, please register and log in; it’s all free.

You can store complete decision hierarchies, use them to estimate the weights of criteria and sub-criteria and evaluate up to seven decision alternatives.

AHP is also helpful to support group decision making; participants can input their individual judgments and a consolidated group result is calculated. I have prepared a practical example, where you can participate, input your judgments and view the overall group results and consensus. Just click on the link and try it out.

The development is still continuing. I am further optimizing the handling and plan to implement additional analysis, especially for group decision making. Bookmark the page and revisit from time to time to get the latest updates.

Now please enjoy your visit on the site and feel free to give me feedback – it is always appreciated.

Klaus D. Goepel,

Singapore, May 2014

BPMSG stands for Business Performance Management Singapore. As of now, it is a non-commercial website, and information is shared for educational purposes. Please see licensing conditions and terms of use. Please give credit or a link to my site, if you use parts in your website or blog.

About the author

AHP-OS online software – Frequently Asked Questions

Note: All answers assume that you are a registered user and logged in.

Q: How do I save a new AHP hierarchy definition?

A: In the Session Administration Menu click on New.

The hierarchy window is displayed. Define a new hierarchy in the text input field and click on Submit new hierarchy, then Save in the Hierarchy Input Menu.

The group session window will open. Optionally provide a project short description and  click Go, and the defined hierarchy is stored and shown as type “H” (Hierarchy) in the project table of the Session Administration Menu.

Q: How can I define and store a project for the evaluation of alternatives?

A: Start with a hierarchy definition, save and resume from the project table by clicking on the session code link. Complete all pairwise comparisons (Click on AHP in the hierarchy) to define the weights of criteria. (Before alternatives can be evaluated, criteria weights need to be defined.) Submit for group evaluation and view the result. In the group result page click on Use consol. priorities.

Then click on Evaluate Alternatives in the decision hierarchy display. Provide number and names of your alternatives and save a new project. It will be saved as type “A” (Alternative Evaluation). From there you can resume and start the alternative evaluation.

Q: How can I use a defined and stored hierarchy definition as template for a new project or new group session?

A: Click on the session code link of the project, you want to use, in the Stored AHP project session table.

a)      If the project has no participants, the project will be opened in the group session input mode. Click on Leave, then Close in the Active Session Menu.

b)      If the project has participants, the project will be opened in the AHP Group result window. Click on the Resume link at the bottom of the page, then Leave and Close in the Active Session Menu as in a).

You can now re-use the hierarchy definition and save as a new project.

;