Group Decision and Negotiation

, Volume 14, Issue 2, pp 89–108

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
  • Alberto TurÓn Lanuza
Article

DOI: 10.1007/s10726-005-2407-8

Cite this article as:
MarÍa, J., JimÉnez, M., Joven, J.A. et al. Group Decis Negot (2005) 14: 89. doi:10.1007/s10726-005-2407-8
  • 269 Downloads

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.

Key words

group decision makingnegotiationAHPconsensus buildingcore of consistencyexcel

Copyright information

© Springer Science + Business Media, Inc. 2005

Authors and Affiliations

  • JosÉ MarÍa
    • 1
  • Moreno JimÉnez
    • 1
  • Juan AguarÓn Joven
    • 1
  • AgustÍn Raluy Pirla
    • 1
  • Alberto TurÓn Lanuza
    • 1
  1. 1.Grupo Decisión Multicriterio Zaragoza, Facultad de EconómicasUniversidad de ZaragozaSpain