Aplicação da Visual Basic for Applications no Microsoft Office Excel para a elaboração de orçamentos analíticos em projetos de engenharia civil

Abstract

Budget worksheets are components of the design of an engineering project. In the process of elaborating the detailed budget of an engineering work or service we call analytical budgeting. Analytically budgeting a shell-work involves a lot of budgeting knowledge and there are software specifically designed for this purpose, but much of Microsoft Excel is still used, software that is part of the Microsoft company's Office suite and is present on most personal computers. The problem is that Excel is a pro gram for spreadsheets in general, that is, it is not specific for engineering budgets and the insertion of several services in the budget, even if through reference sources, ma kes It is a waste of "copy and paste" work. It was developed with this work an orthogo nal worksheet prepared in Excel and using VBA, short version of the programming language Visual Basic and feature present natively in the softwares of the Office package, whose purpose is that by means of buttons and forms the user can of form practice consulting services and inputs in the SINAPI worksheets, available from Caixa Econômica Federal, or registering new services and inputs, and quickly adding them to the budget being prepared.