Decision Analysis Module for Excel

Authors: Radomir Perzina, Jaroslav Ramik

Abstract:

The Analytic Hierarchy Process is frequently used approach for solving decision making problems. There exists wide range of software programs utilizing that approach. Their main disadvantage is that they are relatively expensive and missing intermediate calculations. This work introduces a Microsoft Excel add-in called DAME – Decision Analysis Module for Excel. Comparing to other computer programs DAME is free, can work with scenarios or multiple decision makers and displays intermediate calculations. Users can structure their decision models into three levels – scenarios/users, criteria and variants. Items on all levels can be evaluated either by weights or pair-wise comparisons. There are provided three different methods for the evaluation of the weights of criteria, the variants as well as the scenarios – Saaty’s Method, Geometric Mean Method and Fuller’s Triangle Method. Multiplicative and additive syntheses are supported. The proposed software package is demonstrated on couple of illustrating examples of real life decision problems.

Keywords: Analytic hierarchy process, multi-criteria decision making, pair-wise comparisons, Microsoft Excel, Scenarios.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1094721

References:

[1] Aguaron, J., Moreno-Jimenez, J.M.: The geometric consistency index: Approximated thresholds. European Journal of Operational Research 147 (2003), 137-145.
[2] Fishburn, P. C.: A comparative analysis of group decision methods, Behavioral Science (16), 1971, 538-544.
[3] Gass, S.I., Rapcsák, T.: Singular value decomposition in AHP. European Journal of Operational Research 154 (2004), 573-584.
[4] Mazurek, J., Fiedor, J.: The Decision Tool for the Ordinal Consensus Ranking Problem. In: Conference Proceedings of the International Scientific Conference ICT for Competitiveness 2012. Silesian University, School of Business Administration, Karvina, 2012, 184-189.
[5] Ramík, J., Korviny, P.: Inconsistency of pair-wise comparison matrix with fuzzy elements based on geometric mean. Fuzzy Sets and Systems 161 (2010), 1604-1613.
[6] Ramik, J., Perzina, R.: Fuzzy ANP - a New Method and Case Study. In: Proceedings of the 24th International Conference Mathematical Methods in Economics 2006, University of Western Bohemia, 2006.
[7] Ramik, J., Perzina, R.: DAME - Microsoft Excel Add-in for Solving Multicriteria Decision Problems with Scenarios. In: Proceedings of the 30th International Conference Mathematical Methods in Economics 2012, University of Western Bohemia, 2012.
[8] Ramík, J., Vlach, M.: Generalized concavity in optimization and decision making. Kluwer Publ. Comp., Boston-Dordrecht-London, 2001, 305 p.
[9] Saaty, T.L.: Exploring the interface between hierarchies, multiple objectives and fuzzy sets. Fuzzy Sets and Systems 1, 1978, 57-68.
[10] Saaty, T.L.: Multicriteria decision making - the Analytical Hierarchy Process. Vol. I., RWS Publications, Pittsburgh, 1991.
[11] Saaty, T.L.: Decision Making with Dependence and Feedback - The Analytic Network Process. RWS Publications, Pittsburgh, 2001.