Decision Analysis Module for Excel

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.

• Radomir Perzina
• Jaroslav Ramik

• Analytic hierarchy process
• multi-criteria decision making
• pair-wise comparisons
• Microsoft Excel
• Scenarios.

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