Desenvolvimento de um sistema baseado em Excel e Vba para o gerenciamento das locomoções de escavadeiras e perfuratrizes nas operações de desmonte de rocha

Abstract

During the equipment of locomotion activities to meet the rock blasting activities not observed the use of great technologies and control methods. This ends up causing delays in these locomotions, which in turn ends up directly impacting unit operations, and in the mining / exploitation stage, unit operations, of hard rock, are basically divided into drilling, blasting, loading and haulage. These operations are cyclical, occurring according to the sequence already mentioned. These locomotions are necessary due to the great energy released during the operations of blasting with explosive, so it is necessary to trace a safety area as stated in NR22. In order to outline the strategies, control and coordinate these activities, mine planning is included, and it is in planning that the largest number of technological advances, due to the great need for the use of sequencing, drawing and geological modeling software. This work is focused on short-term planning and aims to develop an equipment exit management system for blasting using the Microsoft Excel® software and Visual Basic for Applications (VBA), thus serving as a new management tool for locomotion programming of equipment to meet activities and safety parameters. This system enabled greater efficiency in the planning of locomotion, greater assertiveness in scheduling the times of this activity, through the use of the average speed formula, and made it possible to manage schedules through a database of scheduled versus performed activities.