Prospects of using the algorithm in the environment of Microsoft Excel as an intermediate variant of zootechnical accounting

Available on the domestic market, the program "Emphasis - pedigree accounting in pig breeding" provides the opportunity for accountants and breeding technologists to fully perform pedigree accounting, generate various types of reports, and plan the schedule of certain technological operations in an automated mode. However, there are not so many pig enterprises that use special software (Accent - pedigree accounting in pig breeding and Plem Office Pic) in Ukraine. According to the survey, it turned out that only about 20 % of surveyed enterprises use the specialized IT products. Therefore, the purpose of our work was to analyze the possibilities and prospects of using the Microsoft Excel program as an intermediate simplified option for keeping zootechnical and breeding records in the conditions of modern breeding and commodity enterprises for the production of pig products in Ukraine. The developed Excel algorithm "Primary zootechnical accounting" is a quick and convenient way to create the main forms of breeding accounting, if it is necessary, to display the necessary reports on the monitor screen or in the paper form. The advantages of using the developed Excel algorithm on the example of its use in the conditions of a breeding breeder for breeding Pietren pigs: selection of pairs taking into account the degree of kinship between animals to prevent inbreeding, the actual presence of sows in the herd and the structure of the herd in real time, evaluation of the productivity of boars, sows and others. Disadvantages of the developed Excel algorithm "Primary zootechnical accounting" - the algorithm works quite effectively with a relatively small number of animals (100-200 heads are optimal, and the maximum is up to 500 heads of the main sows), some tables are created manually, and from time to time it is necessary to manually optimize the database. The developed Excel algorithm "Primary zootechnical accounting" is recommended for use in the conditions of breeding farms as a transitional stage to the next use of professional programs for keeping breeding and zootechnical accounting in conditions of limiting the costs of material resources. Key words: primary zootechnical accounting, algorithm, Excel program, breeding stock, pigs.