Multimethod to prioritize projects evaluated in different formats
The prioritization of Research, Development & Innovation Projects is an essential step in the innovation management process. As a rule, it is carried out applying methods that allow one to process experts' preferences concerning each project according to criteria. However, there are different preference formats: Ordering of Alternatives, Utility Values, Multiplicative Preference Relations, Fuzzy Estimates, Fuzzy Preference Relations, to name a few; and each prioritization method processes only one of these formats. Thus, the following question arises: how do we prioritize projects taken from portfolios evaluated in different formats? This methodology presents a way to overcome this gap by achieving three main objectives: develop techniques that make it possible a crossover between preference formats and prioritization methods, merge two portfolios of projects built from different prioritization methods and prioritize projects evaluated from different formats. The results of this research are universal and can be applied to replace any method of prioritization. In the specific case, the attached databases bring the data and calculations that allow: 1.) changing valuations in value-for-profit format to the multiplicative relation format; 2.) replace the Mapping method with the Analytic Hierarchy Process method; 3.) include criteria of a quantitative nature; and 4.) replace the Analytic Hierarchy Process with the TODIM method. The attached file contains the following data: evaluations of four projects in a utility-value format and evaluations of three projects in a multiplicative relation format. It also contains the calculations to obtain the value of matrix consistency, fully consistent matrices and the ranking of projects. It also contains the necessary calculations to prioritize projects using the TODIM method.
Steps to reproduce
The necessary steps for reproducing the calculations are detailed in [1-3].  T. L. Saaty, The Analytic Hierarchy Process: Planning, Priority Setting, Resource Allocation (Decision Making Series). McGraw-Hill, 1980.  F. Herrera, E. Herrera-Viedma, and F. Chiclana, "Multiperson decisionmaking based on multiplicative preference relations," Eur. J. Oper. Res., vol. 129, no. 2, pp. 372–385, mar 2001. [Online]. Available: https://doi.org/10.1016/s0377-2217(99)00197-6  A. Ishizaka and M. Lusti, "An expert module to improve the consistency of AHP matrices," Int. T. Oper. Res., vol. 11, no. 1, pp. 97–105, jan 2004. [Online]. Available: https://doi.org/10.1111/j.1475-3995.2004.00443.x