AHP-OS Data Download and Import in Excel

Most data generated with AHP-OS can be downloaded as csv files for import into a spreadsheet program and further analysis:

  • From the Hierarchy Input Menu – decision hierarchy and local & global priorities
  • From the Group Result Menu – Priorities by node and consolidated decision matrix
  • From the Project Data Menu – Decision matrices from each participant

For each download you can select “.” or “,” as decimal separator. The downloaded csv (text) file is coded in UTF-8 and supports multi-language characters like Chinese, Korean, Japanese and of course a variety of Western languages.

How to import into excel?

Open Excel, click on “File” -> “New” to have a blank worksheet. Click on “Data“. On the left top you will find the “Get External Data” box.

Continue reading AHP-OS Data Download and Import in Excel

AHP-OS – Editing saved projects

In the project menu of the latest AHP-OS version (2017-05-25), I added a button to edit saved projects. As long as there are no participants’ inputs (completed pairwise comparisons), any saved project’s hierarchy, alternatives or description can be modified.

Open a project from your project list, and click on Edit Project. The project hierarchy page will open with a message on top , indicating that you are modifying an existong project. You can now change the hierarchy, for example add criteria or alternatives. A click on Save/Update in the Hierarchy Input Menu

will overwrite the data of the original project under the same session code. You will see it in a message . Before you click on Go to save,  you  can also update the project short description:

Continue reading AHP-OS – Editing saved projects

AHP-OS New Release with simplified project administration

Based on feedback from users, I just released a major update of BPMSG’s AHP online software AHP-OS with simplified menu structure and additional functionality.  Starting the program as registered and logged-in user, the project session  table is displayed, showing your projects.

You can open one of your projects, either using a click on the session code in the project table, or selecting the session code from the session administration menu:

This will bring you to the project summary page, showing

Continue reading AHP-OS New Release with simplified project administration

AHP Group Consensus Indicator – how to understand and interpret?

BPMSG’s AHP excel template and AHP online software AHP-OS can be used for group decision making by asking several participants to give their inputs to a project in form of pairwise comparisons. Aggregation of individual judgments (AIJ) is done by calculating the geometric mean of the elements of all decision matrices using this consolidated decision matrix to derive the group priorities.

AHP consensus indicator

In [1] I proposed an AHP group consensus indicator to quantify the consensus of the group, i.e. to have an estimate of the agreement on the outcoming priorities between participants. This indicator ranges from 0% to 100%. Zero percent corresponds to no consensus at all, 100% to full consensus. This indicator is derived from the concept of diversity based on Shannon alpha and beta entropy, as described in [2].  It is a measure of homogeneity of priorities between the participants and can also be interpreted as a measure of overlap between priorities of the group members.

Continue reading AHP Group Consensus Indicator – how to understand and interpret?

The Analytical Hierarchy Process (AHP) – Is it old and outdated?

This was a question in researchgate.net, and the answer of Prof. Saaty – the creator of the method – is of course: “The AHP is the only accurate and rigorous mathematical way known for the measurement on intangibles. It is not going to get old for a long time., with a lot of answers from others following.

When it comes to AHP, it seems the scientific world is still divided in opponents and advocates of the method.

I answered with the statistic of my website: BPMSG has more than 4000 users of the online software AHP-OS, 600 of them active users with 1000 projects and more than 3500 decision makers. My AHP excel template reached nearly 21 thousand downloads.  It clearly shows that the method is not outdated.

As a reply Nolberto wrote:

No, I don´t think that AHP is outdated, but the fact that over than 1000 projects have been developed using AHP does not mean that their results are correct (which is impossible to check), or that the method is sound (which is easily challenged)… 

Here my answer:

yes, I agree, the numbers only show that AHP is not outdated (which was the original question). They don’t show, whether the results are correct or incorrect, but they also do not show whether the users did or did not realise the method’s drawbacks and limitations.

For me, as a practitioner, AHP is one of the supporting tools in decision making. The intention of a tool is what it does. A hammer intends to strike, a lever intends to lift. It is what they are made for.

From my users feedback I sometimes get the impression that some of them expect a decision making support tool to make the decision for them, and this is not what it is made for.

In my practical applications AHP helped me and the teams a lot to gain a better insight into a decision problem, to separate important from less important criteria and to achieve a group consensus and agreement how to tackle a problem or proceed with a project. Probably, this could be achieved with other tools too, but as you say, AHP is simple, understandable and easy.

For sure, real world problems are complex. Therefore they have to be broken down and simplified, to be handled with the method, and I agree, over-simplification can be dangerous. On the other hand, what other approach than the break down of complex problems into digestable pieces is possible?

Finally, it’s not the tool producing the decision, but the humans behind it. They will be accountable for the decision, and it’s their responsibility to find the appropriate model of a decision problem and the right balance between  rational and non-rational arguments and potential consequences of their decision.

Let me know your opinion!

 

AHP-OS News March 2017

I received some feedback about session timeout and expired session errors. I have now extended the session timeout to 45 min. After 45 minutes of inactivity (no refresh of html pages, click on menu botton, etc.) the session expires and session data are lost. Kindly feedback, if you still face a problem.

AHP-OS can handle multibyte characters (Chinese, Korean, Japanese etc.) Unfortunately, the bar chart of priorities on the group result page cannot handle these characters; the annotation of the axis will not be readable. I am working on a solution.

When doing a pairwise comparison – leaving all comparisons at the default value of 1 (equal importance) – criteria will get equal priorities. I implemented a confirmation message box: Are you sure to leave all comparisons at equal importance?  This was done in order to avoid unintential submission of the default values.

AHP-OS and Farsi

Thanks to the feedback of a user from Iran, I found out that AHP-OS is working with RTL fonts like Farsi. It is important to add the semicolon to the right end of a node definition, and use latin punctuation marks, for example:

کاربری: مسکونی , تجاری , اداری ;

A simple decision hierarchy example looks like here:

farsi

Unfortunately, I am not able to check for a hierarchy with more than one level. If anyone could provide a 2 level hierarchy, I would appreciate. Arabic fonts should work too; kindly contact me, if you have an example.

 

Group Decision Making with AHP-OS

My AHP free online software AHP-OS has a feature to involve a group of decision makers to give their inputs to a decision problem. In contrast to my AHP Excel template, in AHP-OS the number of participants is practically unlimited. As of now, I see users having up to 100 participants in one project.

Other articles:

How to use AHP-OS for Group Decision Making?

As registered user you need to start with a new project by defining your decision hierarchy. In the Project Administration Menu click on New, define your hierarchy, Submit and Save as project. You have the possibility to give a short project description, explaining the project, before it is saved.

Continue reading Group Decision Making with AHP-OS

AHP Online Software CSV Data Export

AHP-OS allows for downloading your project data as a comma separated value text file. The following menus include a csv download key:

  • Hierarchy Input Menu – download the AHP hierarchy
  • Group Result Menu – download resulting priorities and consolidated (aggregated) decision matrix
  • Project Data Menu – download decision matrices for all individual participants

Depending on your regional settings of your PC, for each download you can select the decimal point or decimal comma as decimal separator.

Text encoding of the CVS file is UTF-8. If you are using country specific characters and Windows Excel, you can convert from UTF-8 to ANSI. Open the CSV file with notepad, and save as a new file with Encoding set to ANSI.

 

AHP Online Software – Decision Matrices – Update 2016-11-02

With the latest update of my AHP-OS online software you can now view and download the decision matrices of all participant. The group result menu was extended by a selection View Input Data:

g-result-menu

From there you reach the Project Detailed Input page, which shows the decision matrix for each individual participant and all nodes of the hierarchy:

projectinputdata

The project data menu has the button to download the data in csv format:

p-data-menu

The csv file contains the basic project data – Session Code, Project Name, Project description, Author, Date, Type of evaluation, Number of Participants – as well as all input decision matrices sorted by participant and nodes (categories of the hierarchy) or criteria for alternative evaluation.

With the Back link you can go back to the Group Result Page.