ГОДОВОЙ ПЛАН-ГРАФИК ТЕХНИЧЕСКОГО ОБСЛУЖИВАНИЯ С ИСПОЛЬЗОВАНИЕМ ПРОГРАММЫ MICROSOFT EXCEL

Abstract

We reviewed the main stages of the development of the annual schedule of maintenance and technical diagnostics of the fleet of trucks on a computer, taking into account individual information on each of their samples and the time features of the formation of the fleet in a separate farm. (Research purpose) The research purpose is developing an annual schedule of maintenance and technical diagnostics of the fleet of trucks in the MS-Office program. (Materials and methods) It was shown that in order to solve the problem, the necessary information is entered into the computer in specially designed tabular forms. Used as input information: the list of trucks of the farm; the term of their commissioning/overhaul and mileage after it; the annual schedule of vacations of farm drivers; the annual schedule of holidays and weekends; the average annual mileage of farm truck models over the past year; schedules of intensive spring and autumn mechanized transport operations of the farm; individual mileage of all trucks over the past year year; individual planned mileage of each truck for a year; individual mileage of them after the last license plate maintenance. (Results and discussion) The output information is presented in the table for all trucks with the dates of their numbered technical services and technical diagnoses by month of the year. We used the Microsoft Excel spreadsheet package as a software environment for developing an annual maintenance schedule and technical diagnostics, which allows us to implement the principle of single data entry, thereby reducing the complexity of transferring them to a computer. (Conclusions) The development was presented as a special version of the system of software-algorithmic and information tools generated in the MS-Office spreadsheet environment.