IDEAS home Printed from https://ideas.repec.org/a/spr/grdene/v14y2005i2d10.1007_s10726-005-2407-8.html
   My bibliography  Save this article

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

Author

Listed:
  • 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)

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.

Suggested Citation

  • JosÉ MarÍa & Moreno JimÉnez & Juan AguarÓn Joven & AgustÍn Raluy Pirla & Alberto TurÓn Lanuza, 2005. "A Spreadsheet Module for Consistent Consensus Building in AHP-Group Decision Making," Group Decision and Negotiation, Springer, vol. 14(2), pages 89-108, March.
    • Handle: RePEc:spr:grdene:v:14:y:2005:i:2:d:10.1007_s10726-005-2407-8
    DOI: 10.1007/s10726-005-2407-8
    as

    Download full text from publisher

    File URL: http://link.springer.com/10.1007/s10726-005-2407-8
    File Function: Abstract
    Download Restriction: Access to the full text of the articles in this series is restricted.
    File URL: https://libkey.io/10.1007/s10726-005-2407-8?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Escobar, M. T. & Moreno-Jimenez, J. M., 2000. "Reciprocal distributions in the analytic hierarchy process," European Journal of Operational Research, Elsevier, vol. 123(1), pages 154-174, May.
    2. Van den Honert, R. C., 1998. "Stochastic group preference modelling in the multiplicative AHP: A model of group consensus," European Journal of Operational Research, Elsevier, vol. 110(1), pages 99-111, October.
    3. Brugha, Cathal M., 2000. "Relative measurement and the power function," European Journal of Operational Research, Elsevier, vol. 121(3), pages 627-640, March.
    4. Roy, Bernard, 1993. "Decision science or decision-aid science?," European Journal of Operational Research, Elsevier, vol. 66(2), pages 184-203, April.
    5. Ramanathan, R. & Ganesh, L. S., 1994. "Group preference aggregation methods employed in AHP: An evaluation and an intrinsic process for deriving members' weightages," European Journal of Operational Research, Elsevier, vol. 79(2), pages 249-265, December.
    6. Saaty, Thomas L., 1990. "Eigenvector and logarithmic least squares," European Journal of Operational Research, Elsevier, vol. 48(1), pages 156-160, September.
    7. Escobar, María Teresa & Moreno-Jiménez, José María, 2002. "A linkage between the Analytic Hierarchy Process and the Compromise Programming Models," Omega, Elsevier, vol. 30(5), pages 359-365, October.
    8. Forman, Ernest & Peniwati, Kirti, 1998. "Aggregating individual judgments and priorities with the analytic hierarchy process," European Journal of Operational Research, Elsevier, vol. 108(1), pages 165-169, July.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Ahadi, Pedram & Fakhrabadi, Farbod & Pourshaghaghy, Alireza & Kowsary, Farshad, 2023. "Optimal site selection for a solar power plant in Iran via the Analytic Hierarchy Process (AHP)," Renewable Energy, Elsevier, vol. 215(C).
    2. Bowen Zhang & Yucheng Dong & Enrique Herrera-Viedma, 2019. "Group Decision Making with Heterogeneous Preference Structures: An Automatic Mechanism to Support Consensus Reaching," Group Decision and Negotiation, Springer, vol. 28(3), pages 585-617, June.
    3. Francineide Morais Bezerra & Paulo Melo & João Paulo Costa, 2014. "Visual and Interactive Comparative Analysis of Individual Opinions: A Group Decision Support Tool," Group Decision and Negotiation, Springer, vol. 23(1), pages 101-125, January.
    4. S. Lipovetsky, 2009. "Global Priority Estimation in Multiperson Decision Making," Journal of Optimization Theory and Applications, Springer, vol. 140(1), pages 77-91, January.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Aguaron, Juan & Moreno-Jimenez, Jose Maria, 2003. "The geometric consistency index: Approximated thresholds," European Journal of Operational Research, Elsevier, vol. 147(1), pages 137-145, May.
    2. Pilar Gargallo & José María Moreno-Jiménez & Manuel Salvador, 2007. "AHP-Group Decision Making: A Bayesian Approach Based on Mixtures for Group Pattern Identification," Group Decision and Negotiation, Springer, vol. 16(6), pages 485-506, November.
    3. José María Moreno-Jiménez & Manuel Salvador & Pilar Gargallo & Alfredo Altuzarra, 2016. "Systemic decision making in AHP: a Bayesian approach," Annals of Operations Research, Springer, vol. 245(1), pages 261-284, October.
    4. Alfredo Altuzarra & José María Moreno-Jiménez & Manuel Salvador, 2010. "Consensus Building in AHP-Group Decision Making: A Bayesian Approach," Operations Research, INFORMS, vol. 58(6), pages 1755-1773, December.
    5. Manuel Salvador & Alfredo Altuzarra & Pilar Gargallo & José María Moreno-Jiménez, 2015. "A Bayesian Approach to Maximising Inner Compatibility in AHP-Systemic Decision Making," Group Decision and Negotiation, Springer, vol. 24(4), pages 655-673, July.
    6. Bernasconi, Michele & Choirat, Christine & Seri, Raffaello, 2014. "Empirical properties of group preference aggregation methods employed in AHP: Theory and evidence," European Journal of Operational Research, Elsevier, vol. 232(3), pages 584-592.
    7. Claudio Marcianò & Giuseppa Romeo & Fortunato Cozzupoli, 2015. "An Integrated Methodological Framework for the Definition of Local Development. Strategies for Fisheries Local Action Groups: an application to the Stretto Coast FLAG in South Italy," 2015 EAFE (European Association of Fisheries Economists) Conference Papers 008, Nisea.
    8. Kreng, Victor B. & Wu, Chao-Yi, 2007. "Evaluation of knowledge portal development tools using a fuzzy AHP approach: The case of Taiwanese stone industry," European Journal of Operational Research, Elsevier, vol. 176(3), pages 1795-1810, February.
    9. Natalie M. Scala & Jayant Rajgopal & Luis G. Vargas & Kim LaScola Needy, 2016. "Group Decision Making with Dispersion in the Analytic Hierarchy Process," Group Decision and Negotiation, Springer, vol. 25(2), pages 355-372, March.
    10. J. M. Moreno-Jiménez & J. Aguarón & M. T. Escobar, 2008. "The Core of Consistency in AHP-Group Decision Making," Group Decision and Negotiation, Springer, vol. 17(3), pages 249-265, May.
    11. María Teresa Escobar & José María Moreno-jiménez, 2007. "Aggregation of Individual Preference Structures in Ahp-Group Decision Making," Group Decision and Negotiation, Springer, vol. 16(4), pages 287-301, July.
    12. Jacinto González-Pachón & Carlos Romero, 2007. "Inferring consensus weights from pairwise comparison matrices without suitable properties," Annals of Operations Research, Springer, vol. 154(1), pages 123-132, October.
    13. Hahn, Eugene D., 2006. "Link function selection in stochastic multicriteria decision making models," European Journal of Operational Research, Elsevier, vol. 172(1), pages 86-100, July.
    14. B S Ahn & S H Choi, 2008. "ERP system selection using a simulation-based AHP approach: a case of Korean homeshopping company," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 59(3), pages 322-330, March.
    15. Hsu-Shih Shih, 2016. "A Mixed-Data Evaluation in Group TOPSIS with Differentiated Decision Power," Group Decision and Negotiation, Springer, vol. 25(3), pages 537-565, May.
    16. Zhu, Bin & Xu, Zeshui, 2014. "Analytic hierarchy process-hesitant group decision making," European Journal of Operational Research, Elsevier, vol. 239(3), pages 794-801.
    17. Aull-Hyde, Rhonda & Erdogan, Sevgi & Duke, Joshua M., 2006. "An experiment on the consistency of aggregated comparison matrices in AHP," European Journal of Operational Research, Elsevier, vol. 171(1), pages 290-295, May.
    18. Juan Aguarón & María Teresa Escobar & José María Moreno-Jiménez & Alberto Turón, 2019. "AHP-Group Decision Making Based on Consistency," Mathematics, MDPI, vol. 7(3), pages 1-15, March.
    19. Milan Ranđelović & Jelena Stanković & Kristijan Kuk & Gordana Savić & Dragan Ranđelović, 2018. "An Approach to Determining the Importance of Model Criteria in Certifying a City as Business-Friendly," Interfaces, INFORMS, vol. 48(2), pages 156-165, April.
    20. Lee, Hakyeon & Geum, Youngjung, 2017. "Development of the scenario-based technology roadmap considering layer heterogeneity: An approach using CIA and AHP," Technological Forecasting and Social Change, Elsevier, vol. 117(C), pages 12-24.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:spr:grdene:v:14:y:2005:i:2:d:10.1007_s10726-005-2407-8. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Sonal Shukla or Springer Nature Abstracting and Indexing (email available below). General contact details of provider: http://www.springer.com .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.