Educational Microsoft Excel Add-ins - Solving Multicriteria Decision Making Problems

Radomir Perzina, Jaroslav Ramik

Abstract

There exists wide range of software products to support decision making. Main disadvantage of those software products is that they are commercial and relatively expensive and thus it prevents them to be used by students or researchers. Also they are not suitable from pedagogical point of view. This paper introduces two Microsoft Excel add-ins DAME and FVK that were developed for students to help them understand basic principles of Multicriteria Decision Making. They don’t behave as a black box but display all results of all intermediate calculations which are very important for educational purposes. The proposed software packages are demonstrated on couple of illustrating examples of real life decision problems.

References

  1. Aguaron, J., Moreno-Jimenez, J.M., 2003. The geometric consistency index: Approximated thresholds. European Journal of Operational Research 147, 137- 145.
  2. Buckley, J.J., 1985. Fuzzy hierarchical analysis. Fuzzy Sets and Systems 17, 1, p. 233-247.
  3. Chen, S.J., Hwang, C.L. and Hwang, F.P., 1992. Fuzzy multiple attribute decision making. Lecture Notes in Economics and Math. Syst., Vol. 375, SpringerVerlag, Berlin - Heidelberg.
  4. Fishburn, P. C., 1971. A comparative analysis of group decision methods, Behavioral Science (16), 538-544.
  5. Gass, S.I., Rapcsák, T., 2004. Singular value decomposition in AHP. European Journal of Operational Research 154, 573-584.
  6. Ramik, J., Perzina, R., 2006. Fuzzy ANP - a New Method and Case Study. In: Proceedings of the 24th International Conference Mathematical Methods in Economics 2006, University of Western Bohemia.
  7. Ramik, J., Perzina, R., 2008. Microsoft Excel Add-In for Solving Multicriteria Decision Problems in Fuzzy Environment. In: Proceedings of the 26th International Conference Mathematical Methods in Economics, Technical University of Liberec.
  8. Ramik, J., Perzina, R., 2014. Solving Multicriteria Decision Making Problems using Microsoft Excel. In: Proceedings of the 32nd International Conference Mathematical Methods in Economics, Palacky University Olomouc.
  9. Saaty, T.L., 1978. Exploring the interface between hierarchies, multiple objectives and fuzzy sets. Fuzzy Sets and Systems 1, 57-68.
  10. Saaty, T.L., 1991. Multicriteria decision making - the Analytical Hierarchy Process. Vol. I., RWS Publications, Pittsburgh.
  11. Saaty, T.L., 2001. Decision Making with Dependence and Feedback - The Analytic Network Process. RWS Publications, Pittsburgh.
  12. Van Laarhoven, P.J.M. and Pedrycz, W., 1983. A fuzzy extension of Saaty's priority theory. Fuzzy Sets and Systems 11, 4, p. 229-241.
Download


Paper Citation


in Harvard Style

Perzina R. and Ramik J. (2015). Educational Microsoft Excel Add-ins - Solving Multicriteria Decision Making Problems . In Proceedings of the 7th International Conference on Computer Supported Education - Volume 1: CSEDU, ISBN 978-989-758-107-6, pages 510-515. DOI: 10.5220/0005494005100515


in Bibtex Style

@conference{csedu15,
author={Radomir Perzina and Jaroslav Ramik},
title={Educational Microsoft Excel Add-ins - Solving Multicriteria Decision Making Problems},
booktitle={Proceedings of the 7th International Conference on Computer Supported Education - Volume 1: CSEDU,},
year={2015},
pages={510-515},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005494005100515},
isbn={978-989-758-107-6},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 7th International Conference on Computer Supported Education - Volume 1: CSEDU,
TI - Educational Microsoft Excel Add-ins - Solving Multicriteria Decision Making Problems
SN - 978-989-758-107-6
AU - Perzina R.
AU - Ramik J.
PY - 2015
SP - 510
EP - 515
DO - 10.5220/0005494005100515