Sistema de controle de veículos (SCV)

Abstract

The Transportation Division of the Acre State Department of Education is responsible for managing the fleet of vehicles and uses Excel spreadsheets to perform maintenance checks. However, using spreadsheets can lead to typos that could compromise the veracity of the information. In a web system, any change requires multiple commands, such as adding, editing, and deleting before making any changes. We still have the following disadvantages related to the use of spreadsheets: limited options regarding the choice of formatting; possibilities of elaboration failures; a worksheet is not configured to include items and keeping it updated requires a lot of work; involuntary exclusion of formulas and data; difficulty maintaining the organization when the worksheet is shared; it is not possible to know what each user of the spreadsheet is doing in real time or who has performed a particular operation and also does not favor the quick decision-making of the managers because the actions of extracting the data of the different users that operate it, consolidating them and Summing up the information can take a long time. In this way, the purpose of this system is to replace the worksheet that was previously used collecting information from vehicles, drivers and maintenance. In addition, the system is able to record the trips made and the sectors that request the trips. It also produces reports on frequency of use of the fleet, municipalities that request the most services, purchased parts, contracted services, number of drivers, fuel expense and distance traveled by vehicles. Thus, it will enable the managers involved to make better decisions from accurate data that will be constantly presented by the system. Each operation performed is instantly saved to the database and at the end of the day a backup is performed automatically in order to avoid the loss of information. Each report can be printed using the capabilities of a web browser. Even because sorting, querying, and sharing data are more appropriate for databases than Excel spreadsheet.