Автоматизация обработки результатов экспертных оценок с применением макроса

Abstract

When processing of poorly formalized information, in particular at assessment of professionally important qualities of workers of operator professions in general and drivers of motor transport in particular, the methods based on expert estimates are of great importance. It is necessary to define coherence of expert estimates and at the general level of coherence "having" or to remove absolutely from the analysis or to allocate in the column "dissenting opinion". For this purpose it is possible to use, for example, criterion of coherence of Kendall. At a large number of experts and estimates program processing is necessary. The software has to have the well-known or easily mastered interface. At local use the document MS Excel where a part of operations is carried out by his own parameters, and a part by means of the developed macro executed in the Visual Basic for Application language was applied to data processing.