SUBSTANTIATION OF METHODS OF COLLECTION AND ANALYSIS OF DIGITAL DATA FOR EVALUATION OF MACHINE AGGREGATE OPERATION IN MICROSOFT OFFICE EXCEL

Keywords: machine aggregate, technological operation, operational and economic indicators, quality indicators, tractor

Abstract

Current research shows that the potential of land and varieties of crops (except GMOs, which are now banned in Europe) has actually been exhausted. Therefore, today the main way to increase the yield is to meet the needs of the plants due to the quality of technological operations. The quality of the technological operation is up to 30% of the future harvest. The quality of each technological operation shapes the overall quality and influences the final result - the quality, quantity and cost of production. A badly executed technological operation cannot be re-performed or offset by a qualitative performance of a subsequent technological operation. Modern information technology methods can significantly simplify and reduce the cost of evaluating the performance of ma-chine aggregates. Crucial in this situation is the tool by which data is obtained for processing, analysis and decision making. It is a technique that was used to obtain information. The result of the calculation obtained in the laboratory must be consistent with the results of the observation of the terms in the production conditions. To do this, we have developed a mathematical model and a computer program "Machine aggregate", whose algorithm is written in Microsoft Office Excel. This program is being field-tested with LCMZ and Elvorty. The basic condition of the calculations should be a reliable database.df The input parameters of the computer program "Machine aggregate" are design parameters of tractors and machines as well as agroclimatic and physical-mechanical conditions of their work. The main output parameters of the program implementation are the results of machine aggregates work such as cost and quality of work. The developed technique allows to perform a deep analysis of the operational-economic and quality indicators of use of ma-chine aggregate in any the natural and climatic conditions for both existing and projected aggregates.

References

1. Орманджи К. С. Контроль качества полевых работ. / К.С. Орманджи / Справочник. –М.: Росагропромиздат, 1991. – 191 с.
2. Оптимізація комплексів машин і структури машинного парку та планування технічного сервісу : навчальний посібник / [І. І. Мельник, В. Д. Гречкосій, В. В. Марченко та ін.]. – К. : ВВЦ НАУ, 2004.– 151с.
3. Погорелый Л. В. Применение методов системного анализа при испытаниях сельскохозяйственной техники / Л. В. Погорелый, В. В. Брей // Обзорная информация ЦНИИТЭИ В/О “Сельхозтехника”. – М. : ЦНИИТЭИ В/О “Сельхозтехника”, 1976. – 68 с.
4. Натанзон І. Й. Комплектування машинно-тракторного парку колгоспів і радгоспів різних зон УРСР. / Натанзон І. Й. – К. : Вид-во Укр. акад. с.г. наук, 1961. – 104с.
5. Губко В. Р. Питання методики і результати розрахунків машинно-тракторного парку на ЕОМ / В. Р. Губко, Е. А. Фінн, Л. М. Козакова ; голов. ред. В. С. Крамаров // Застосування математичних методів у дослідженнях складних процесів сільсь-когосподарського виробництва. – К. : Урожай, 1972. – С. 10–17.
6. Губко В. Р. Определение состава машинно-тракторного парка для хозяйств основных зон Украинской ССР / Губко В. Р., Финн Э. А., Варшавский М. Л. – К. :УкрНИИНТИ, 1972. – 44с.
7. Диденко Н. К. Обоснование состава комплексов машин для растениеводства / Н. К. Диденко, В. Д. Гречкосей, И. И. Мельник // Механизация и электрификация сельского хозяйства. – 1980.– № 9. – С. 4–5.
Published
2021-10-12
How to Cite
Zubko, V., Khvorost, T., & Sokolik, S. (2021). SUBSTANTIATION OF METHODS OF COLLECTION AND ANALYSIS OF DIGITAL DATA FOR EVALUATION OF MACHINE AGGREGATE OPERATION IN MICROSOFT OFFICE EXCEL. Bulletin of Sumy National Agrarian University. The Series: Mechanization and Automation of Production Processes, 42(4), 3-9. https://doi.org/10.32845/msnau.2020.4.1