Journal of Business and Management

Journal of Business and Management

ISSN: 2291-1995 (Print)    ISSN: 2291-2002 (Online)

Volume 3 (2014), No. 4, Pages 1-16

DOI: 10.12735/jbm.v3i4p01

Download Full Text:

Solving Decision Problems with Dependent Criteria by New Fuzzy Multicriteria Method in Excel

Jaroslav Ramík1  Radomír Perzina1 

1Centre of Excellence IT4Innovations, Division of the University of Ostrava, Czech Republic


To Cite this Article     Article Views: 1543     Downloads: 889  Since January, 2015


We propose a new MCDM method based on fuzzy pair-wise comparisons and a feedback between the criteria. The evaluation of the weights of criteria, the variants as well as the feedback between the criteria is based on the data given in pair-wise comparison matrices. Extended arithmetic operations with fuzzy numbers are used as well as ordering fuzzy relations to compare fuzzy outcomes. An illustrating numerical example is presented to clarify the methodology. A special SW – Microsoft Excel add-in named FVK was developed for applying the proposed method. Comparing to other software products, FVK is free, able to work with fuzzy data and utilizes capabilities of widespread spreadsheet Microsoft Excel.

JEL Classifications: C44, C88

Keywords: multi-criteria decision making, analytic hierarchy process, pair-wise comparisons, feedback, fuzzy numbers

To Cite this Article: Ramík, J., & Perzina, R. (2014). Solving decision problems with dependent criteria by new fuzzy multicriteria method in excel. Journal of Business and Management, 3(4), 1-16.

Copyright © Jaroslav Ramík & Radomír Perzina

Creative Commons License
This article is published under license to Science and Education Centre of North America. This is an Open Access article distributed under the terms of the Creative Commons Attribution 4.0 International License.

To make sure that you can receive messages from us, please add the '' domain to your e-mail 'safe list'. If you do not receive e-mail in your 'inbox', check your 'bulk mail' or 'junk mail' folders.

Solving Decision Problems with Dependent Criteria by New Fuzzy Multicriteria Method in Excel