Fuzzy for Excel, User Manual

Abstract

Listen

Translate article

Software Fuzzy for Excel (further for abridgment - the FE) is intended for the solving of analytical problems in uncertainty conditions in environment of widespread software Microsoft Excel. It is the fourth version of the software which has been developed by consulting group INEX-FT (Ukraine). The FE is based on using of algorithms of fuzzy technology for the solving of analytical problems in uncertainty conditions. By means of the FE the user can solve three types of analytical problems: - any calculations with use of fuzzy numbers; - problems of evaluation and classification of alternatives (problem of correlation of alternatives to the described classes); - problems of forecast.The FE solves the first problems type with use of algorithm of arithmetic operations according to principle of entropy maximum of decision. The FE solves the second problems type with use of fuzzy sets and fuzzy measures. Here the FE provides support of network-like structure of criteria of evaluation and classification. The FE solves the third problems type with using of forecast algorithm of composite events influence. It is fundamentally new forecast algorithm. The algorithm differs from widespread algorithms that this algorithm uses the information about events which have occurred in the past and are expected in the future.The FE has been created in the form of usual add-in of software Microsoft Excel. The FE does not demand special knowledge of fuzzy mathematics. The FE work is hidden from the user who, however, should understand the uncertainty nature in analytical problem and should have some skills of interpretation of fuzzy numbers.The FE contains the multitude of functions and tools (macro definitions). Functions of the FE create fuzzy numbers and execute various operations with them. Functions of the FE also execute a wide spectrum of operations with fuzzy sets and fuzzy measures. The majority of functions works both with fuzzy and with traditional numbers. Rules of a call and use of FE-functions are traditional. Tools of the FE provide the visual analysis of calculations results (including 3D-graphics), the solving of a forecasting problem and also the solving of auxiliary problems.The FE has the full and restricted version. The restricted version differs from the full version only by cells range (A1:F6) in which the FE supports an executing of functions and tools.