Obras de drenagem de talvegues em rodovias: a utilização de planilha eletrônica na orçamentação do projeto construtivo de Bueiros Celulares de Concreto (BCCs)

Abstract

The culverts are drainage devices capable of transporting water from a talvegue from one side of the highway to the other. Like other engineering works, the budget for a culvert must be prepared before execution, requiring care and experience from the professional. In public works tenders, for example, it is very common to use unit price tables prepared by public agencies. A price table widely used in the state of Goiás is the Goinfra Service Composition Report. This table does not include, in its compositions, the price per meter of Cellular Concrete Culverts or per input and output unit - called mouth, as it does for Tubular Concrete Culverts. With the aim of providing an alternative that saves time for the estimator in the preparation of the budget spreadsheet, the object of study of this work is to create a computerized and automated electronic spreadsheet, in Excel, which, based on data from structural standard projects of the DNIT and from Goinfra's input and service unit cost tables, be able to return unit prices per meter of body and mouth unit of Cellular Concrete Culverts. For this purpose, this work obtained unit price compositions for normal Simple Cellular Concrete Culverts, with a square section (1.50 x 1.50m; 2.00 x 2.00m; 2.50 x 2.50m and 3.00 x 3.00m) and respective inputs and outputs, with embankment heights ranging from 0.00 to 15.00m.