Pair comparison 2.xls, prioritization and consistency

Risk management helps decision makers make informed choices, prioritize actions, and differentiate between alternative courses of action. Pair comparison helps the decision-maker determine priorities when comparing objects. Objects can be goals, strategies, desires, project stages of improvements or changes, personnel-anything that requires prioritization. Sometimes it is very difficult to give preference to something or determine the most important-a pair comparison will allow you to do this quickly enough, and even with the assessment of logic (transitivity). The proposed Excel file is designed in such a way that allows you to compare 45 categories in pairs, does not require special training of an appraiser (expert) and allows you to get a rating (the sequence from the most important to the most unimportant object of comparison), as well as calculates the transitivity coefficient (logic) according to the method proposed by M. Kandel.