Proposta de aplicativo para desenvolvimento de planilhas orçamentárias com base no sinapi

The budget aims to analyze the technical and economic feasibility of the construction, besides facilitating the fulfillment of action plans and goals. However, the budget elaboration can turn out to be a long and laborious process, causing errors that implicates in the final result. This study aimed to develop a computer program that optimizes the budget construction spreadsheet based on the spreadsheet of the brazilian National System of Research on Costs and Indices of Civil Construction (Sinapi). The literature review provided greater knowledge on subjects such as budget, Sinapi and programming. From these studies, a mental map was made that encompassed characteristics and information that the program should include and how it would be returned to the user. Then the code was structured using the TypeScript language, the data from the Sinapi spreadsheet were extracted for objects and arrays, the compositions were allocated in the database, creation of the web page interface, and finally the export of the spreadsheet final budget. A website was created where the user can choose the Sinapi spreadsheet to use for the budget, research and select the services, grouping them into different stages of work, generating a budget spreadsheet in Excel format, which can be used within the educational context.