Desenvolvimento de um programa em Phyton para criação de orçamentos de obras

Abstract

The process of preparing a budget can be quite laborious, dealing with huge spreadsheets and extracting the desired data from them is something routinely done by professionals in the budgeting area and can be a step that takes a lot of time for this professional. Seeking a way to simplify and accelerate this process, the main objective of this work is to create, using the Python programming language, a tool that helps the user in creating budgets for civil works, being an alternative to conventional spreadsheets and for the programs that exist on the market and that have a certain financial cost associated with their use. With this objective in mind, through the literature review, the main elements related to the budgeting process were described, such as degrees of budget information, cost category, factors that influence the budget and creation process. Basic elements related to the Python programming language were also addressed. Through the study carried out, a program was created capable of verifying data in cost reference spreadsheets and providing the user with a more intuitive interface to perform an analysis of these data. In this way, the program offers the creation of a report in pdf format with the created budget, being possible to choose the budget information level (analytical or synthetic) and, as complementary information, the total cost of labor, the total cost of equipment and the generation of the ABC curve of the budget, a summary of the budget is also generated at the end. As a result, based on the compositions of three reference budgets, an analytical budget, an ABC curve report and a budget summary for each of these budgets were generated. Comparing the reference budgets presented and the budgets generated by the program, an average difference of 0.0536% was found between them, and this divergence was generated due to the rounding performed by the program. At the end, possible complements to the work were discussed and the files generated by the program and one of the reference budgets used as a basis for comparison were presented.