DOI: 10.37143/0371-4365-2021-75-10

O. V. Tatsii, аспірант кафедри технології виробництва і переробки продукції тваринництва,
ORCID:https://orcid.org/0000-0002-6407-1364
E-mail:aleksandr.tacij@gmail.com
Odesa State Agrarian University, Kanatna Str., 99, Odesa, Ukraine, 65039
R. L. Susol д. с.-г. н., професор кафедри технології виробництва і переробки продукції тваринництва,
ORCID:https://orcid.org/0000-0003-2395-1282
E-mail:r.susol@ukr.net
Odesa State Agrarian University, Kanatna Str., 99, Odesa, Ukraine, 65039

Abstract

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.

REFERENCES

• 1. Ahrarnyi tsentr: prohramne zabezpechennia, informatsiini posluhy [Agrarian center: software, information services]. Retrived from https://agro.agroc.com.ua/KORAL/tree_ration.htmм [in Ukrainian] (date of access: 15.03.2021).
• 2. Vashchenko, P. A., Berezovskyi, M. D., & Tsybenko, V. G. (2018). Obgruntuvannia faktoriv dlia vkliuchennia u model vyznachennia pleminnoi tsinnosti svynei za vidtvoriuvalnymy yakostiamy [The selection of factors for inclusion in the model of assigning the pedigree value of pigs for breeding qualities]. Bulletin of Sumy National Agrarian University. Livestock series. Sumy, 2 (34), 136–143 [in Ukrainian].
• 3. Vashchenko, P. A. (2019). Prohnozuvannia pleminnoi tsinnosti svynei na osnovi liniinykh modelei selektsiinykh indeksiv ta DNK-markeriv [Prediction of breeding value of pigs on the basis of linear models of breeding indices and DNA markers]. (Extended abstract of Doctor’s thesis). Mykolaiv [in Ukrainian].
• 4. Getia, A. A., Vashchenko, P. A., & Berezovskyi, M. D. (2010). Metodychni rekomendatsii shchodo zboru pervynnykh danykh zootekhnichnoho obliku dlia vyznachennia pleminnoi tsinnosti svynei v avtomatyzovanomu rezhymi (zatverdzheni Naukovo-tekhnichnoiu radoiu Minahropolityky vid 14.12.2010) [Methodical recommendations for the collection of primary zootechnical records for determining the breeding value of pigs in an automated mode, approved by the Scientific and Technical Council of the Ministry of Agrarian Policy of 14.12.2010 [in Ukrainian].
• 5. Zakon Ukrainy «Pro identyfikatsiiu ta reiestratsiiu tvaryn [Law of Ukraine "On identification and registration of animals»]. URL: https://zakon.rada.gov.ua/laws/show/1445-17#Text [in Ukrainian].
• 6. Instruktsiia z bonituvannia svynei; Instruktsiia z vedennia pleminnoho obliku u svynarstvi [Instructions for probing pigs; Instructions for keeping pedigree records in pig breeding.] (2003). Kyiv: Vydavnycho-polihrafichnyi tsentr «Kyivskyi universytet» [in Ukrainian].
• 7. IT-tekhnolohii u tvarynnytstvi: rano chy pizno [IT technologies in animal husbandry: sooner or later]. Retrived from http://www.agroprofi.com.ua/statti/1826-it-2 [in Ukrainian].
• 8. Lykhach, V. Ya. (2016). Obgruntuvannia, rozrobka ta vprovadzhennia intensyvno-tekhnolohichnykh rishen u svynarstvi [Justification, development and implementation of intensive technological solutions in pig farming]. Mykolaiv : MNAU [in Ukrainian].
• 9. Luhovyi, S. I., Lykhach, V. Ya., Lykhach, A. V., Serdiuk M. M., & Serdiuk Yu. M.. (2015). Avtomatyzovana informatsiina systema «Aktsent – pleminnyi oblik u svynarstvi» v selektsii tvaryn [Automated information system "Emphasis – pedigree accounting in pig breeding" in animal breeding]. Svynarstvo [Pig Bredeeng]. Poltava, 67, 90–95 [in Ukrainian].
• 10. Nakaz Minsterstva ahrarnoi polityky ta prodovlstva Ukrainy «Pro zatverdzhennia Poriadku identyfikatsii ta reiestratsii svynei» [Order of the Ministry of Agrarian Policy and Food of Ukraine «On approval of the Procedure for identification and registration of pigs»]. Retrived from https://zakon.rada.gov.ua/laws/show/z0154- 18#Text [in Ukrainian].
• 11. Nebylica, N. S. (2012). Jeffektivnost' avtomatizirovannoj sistemy plemennogo uchjota i ocenki svinej. Sovremennye tendencii i tehnologicheskie innovacii v svinovodstve, materialy ХІХ Mezhdunarodnoj nauchno-praktichnoj konferencii [Efficiency of the automated system of breeding records and evaluation of pigs. Modern trends and technological innovations in pig breeding, Proceedings of the 19th International Scientific and Practical. conf]. Gorki : BGSHA [in Russian].
• 12. Serdiuk, M. M., Luhovyi, S. I., Serdiuk, Yu. M. & Kostohlod, B. O. (2013). Informatsiini tekhnolohii v pleminnomu svynarstvi Ukrainy, Materialy III Mizhnarodnoi naukovo-metodychnoi konferentsii [Information technologies in pedigree pig breeding in Ukraine, Proceedings of the 19th International Scientific and Practical conference]. Chernivtsi : Druk Art [in Ukrainian].
• 13. Yevstafiieva, Yu. M., Buchkovska, V. M. IT-tekhnolohii u tvarynnytstvi [IT-technologies in creation]. Retrived from http://dspace.tnpu.edu.ua/bitstream/123456789/16917/1/ Yevstafiieva_Buchkovska.pdf [in Ukrainian].
• 14. Jakubec, V. (1993). Obecný model pro genetické efekty ve šlechtění živočichů. Živ. Výroba., 38, 861–873.
• 15. Peltoniemi, O. A., T. A. Tast, & R. J. Love. (2000). Factors affecting reproduction in the pig: seasonal effects and restricted feeding of the pregnant gilt and sow. Anim. Reprod. Sci., 60–61, 173–184. 16. Šprysl, М., J. Čítek, and R. Stupka. (2012). The significance of the effects influencing the reproductive performance in pigs. Research in pig breeding, 6 (1), 54–58.