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

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.

[1]  F. Lootsma.  SCALE SENSITIVITY IN THE MULTIPLICATIVE AHP AND SMART , 1993 .

[2]  Madan G. Singh,et al.  Fuzzy analytic network process and its application to the development of decision support systems , 2003, IEEE Trans. Syst. Man Cybern. Part C.

[3]  Marina Bosch,et al.  Fuzzy Multiple Attribute Decision Making Methods And Applications , 2016 .

[4]  Mario Enea,et al.  Project Selection by Constrained Fuzzy AHP , 2004, Fuzzy Optim. Decis. Mak..

[5]  Thomas L. Saaty,et al.  Multicriteria Decision Making: The Analytic Hierarchy Process: Planning, Priority Setting, Resource Allocation , 1990 .

[6]  R. P. Mohanty,et al.  A fuzzy ANP-based approach to R&D project selection: A case study , 2005 .

[7]  Da Ruan,et al.  Determining the importance weights for the design requirements in the house of quality using the fuzzy analytic network approach , 2004 .

[8]  W. Pedrycz,et al.  A fuzzy extension of Saaty's priority theory , 1983 .

[9]  José María Moreno-Jiménez,et al.  The geometric consistency index: Approximated thresholds , 2003, Eur. J. Oper. Res..

[10]  Didier Dubois.  Possibility Theory, Probability Theory and Multiple-Valued Logics: A Clarification , 2001, Fuzzy Days.

[11]  Thomas L. Saaty,et al.  Decision making with dependence and feedback : the analytic network process : the organization and prioritization of complexity , 1996 .

[12]  J. Buckley,et al.  Fuzzy hierarchical analysis , 1999, FUZZ-IEEE'99. 1999 IEEE International Fuzzy Systems. Conference Proceedings (Cat. No.99CH36315).

[13]  Jaroslav Ramík,et al.  A method for solving fuzzy multicriteria decision problems with dependent criteria , 2010, Fuzzy Optim. Decis. Mak..

[14]  James J. Buckley,et al.  Fuzzy hierarchical analysis revisited , 2001, Eur. J. Oper. Res..

[15]  F. Lootsma.  A model for the relative importance of the criteria in the Multiplicative AHP and SMART , 1996 .