The Analytic Hierarchy Process is frequently used

\r\napproach for solving decision making problems. There exists wide

\r\nrange of software programs utilizing that approach. Their main

\r\ndisadvantage is that they are relatively expensive and missing

\r\nintermediate calculations. This work introduces a Microsoft Excel

\r\nadd-in called DAME – Decision Analysis Module for Excel.

\r\nComparing to other computer programs DAME is free, can work

\r\nwith scenarios or multiple decision makers and displays intermediate

\r\ncalculations. Users can structure their decision models into three

\r\nlevels – scenarios\/users, criteria and variants. Items on all levels can

\r\nbe evaluated either by weights or pair-wise comparisons. There are

\r\nprovided three different methods for the evaluation of the weights of

\r\ncriteria, the variants as well as the scenarios – Saaty’s Method,

\r\nGeometric Mean Method and Fuller’s Triangle Method.

\r\nMultiplicative and additive syntheses are supported. The proposed

\r\nsoftware package is demonstrated on couple of illustrating examples

\r\nof real life decision problems.<\/p>\r\n","references":"[1] Aguaron, J., Moreno-Jimenez, J.M.: The geometric consistency index:\r\nApproximated thresholds. European Journal of Operational Research\r\n147 (2003), 137-145.\r\n[2] Fishburn, P. C.: A comparative analysis of group decision methods,\r\nBehavioral Science (16), 1971, 538-544.\r\n[3] Gass, S.I., Rapcs\u00e1k, T.: Singular value decomposition in AHP. European\r\nJournal of Operational Research 154 (2004), 573-584.\r\n[4] Mazurek, J., Fiedor, J.: The Decision Tool for the Ordinal Consensus\r\nRanking Problem. In: Conference Proceedings of the International\r\nScientific Conference ICT for Competitiveness 2012. Silesian\r\nUniversity, School of Business Administration, Karvina, 2012, 184-189.\r\n[5] Ram\u00edk, J., Korviny, P.: Inconsistency of pair-wise comparison matrix\r\nwith fuzzy elements based on geometric mean. Fuzzy Sets and Systems\r\n161 (2010), 1604-1613.\r\n[6] Ramik, J., Perzina, R.: Fuzzy ANP - a New Method and Case Study. In:\r\nProceedings of the 24th International Conference Mathematical Methods\r\nin Economics 2006, University of Western Bohemia, 2006.\r\n[7] Ramik, J., Perzina, R.: DAME - Microsoft Excel Add-in for Solving\r\nMulticriteria Decision Problems with Scenarios. In: Proceedings of the\r\n30th International Conference Mathematical Methods in Economics\r\n2012, University of Western Bohemia, 2012.\r\n[8] Ram\u00edk, J., Vlach, M.: Generalized concavity in optimization and\r\ndecision making. Kluwer Publ. Comp., Boston-Dordrecht-London,\r\n2001, 305 p.\r\n[9] Saaty, T.L.: Exploring the interface between hierarchies, multiple\r\nobjectives and fuzzy sets. Fuzzy Sets and Systems 1, 1978, 57-68.\r\n[10] Saaty, T.L.: Multicriteria decision making - the Analytical Hierarchy\r\nProcess. Vol. I., RWS Publications, Pittsburgh, 1991.\r\n[11] Saaty, T.L.: Decision Making with Dependence and Feedback - The\r\nAnalytic Network Process. RWS Publications, Pittsburgh, 2001.","publisher":"World Academy of Science, Engineering and Technology","index":"Open Science Index 93, 2014"}