A Spreadsheet Module for Consistent Consensus Building in AHP-Group Decision Making

JosÉ MarÍa (), Moreno JimÉnez, Juan AguarÓn Joven, AgustÍn Raluy Pirla and Alberto TurÓn Lanuza
Additional contact information
JosÉ MarÍa: Universidad de Zaragoza
Moreno JimÉnez: Universidad de Zaragoza
Juan AguarÓn Joven: Universidad de Zaragoza
AgustÍn Raluy Pirla: Universidad de Zaragoza
Alberto TurÓn Lanuza: Universidad de Zaragoza

Group Decision and Negotiation, 2005, vol. 14, issue 2, No 2, 89-108

Abstract: Abstract This paper presents a spreadsheet module developed with Microsoft Excel and Visual Basic to search for consensus when dealing with AHP in group decision making. On the basis of the theoretical results included in the paper Moreno-Jiménez et al. (2003), this spreadsheet module allows us to construct, in a local context (one criterion), the Consistent Consensus Matrix (CCM) corresponding to the core of consistency associated with the actors involved in the decision making process. By means of simulation techniques, this module provides, for each of the different values of the inconsistency thresholds considered, the preference structures derived from the interval incomplete matrix (CCM) that represents the group’s core of consistency. This information will be used to establish consensus paths between the actors involved in the resolution process, one of the most important goals in distributed and participatory decision making.

Keywords: group decision making; negotiation; AHP; consensus building; core of consistency; excel (search for similar items in EconPapers)
Date: 2005
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (4)

Downloads: (external link)
http://link.springer.com/10.1007/s10726-005-2407-8 Abstract (text/html)
Access to the full text of the articles in this series is restricted.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:grdene:v:14:y:2005:i:2:d:10.1007_s10726-005-2407-8

Ordering information: This journal article can be ordered from
http://www.springer.com/journal/10726/PS2

DOI: 10.1007/s10726-005-2407-8

Access Statistics for this article

Group Decision and Negotiation is currently edited by Gregory E. Kersten

More articles in Group Decision and Negotiation from Springer
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().