Geração automatizada de linhas de balanço através de planilhas eletrônicas

Abstract

In recent decades, the Line of Balance methodology has been widely used in the planning of linear works, such as highways and multi-story buildings, due to its efficiency in projects with repetitive activities. However, small and medium-sized construction companies, as well as engineers involved in planning and facing financial constraints, encounter challenges in accessing advanced planning tools due to the high costs and complexity of specialized software. This work proposes the development of an electronic spreadsheet in Microsoft Excel, offering an accessible and functional alternative. The spreadsheet automates the creation of schedules and workforce allocation using advanced formulas, incorporating productivity compositions from the National System of Construction Costs and Indexes (SINAPI). Unlike traditional software, the solution is cost-effective, easy to use, and meets the needs of companies unable to invest in robust tools. The main results include the automated generation of detailed schedules, integration with SINAPI data and practical application for small and medium-sized construction projects, all within a simplified interface.