A spreadsheet module for consistent consensus building in AHP-group decision making

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-Jimenez 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.