Diseño de línea de conducción a gravedad mediante la aplicación de una hoja de cálculo programada

Abstract

A good force conduction design requires a lot of time and effort on the part of the designer to find the suitable alternative so that the cost of the pipe is minimal. The objective of this degree work is to prepare a spreadsheet for the design of a water conduction line, both for stationary and transient flow, which has a database of commercial PVC diameters that can be used for the different pipeline working pressures, allowing the software to give us adequate pressures without oversizing, giving us an optimal diameter for the design. The work contains information necessary for the design of gravity conduction destined to transport raw water from a desander to a treatment plant. This is based on standards and design manuals such as the Ecuadorian Construction Code C.E.C. Standards for Study and Design of Drinking Water Systems and Wastewater Disposal for Populations Greater than 1000 Inhabitants. The hydraulic design makes use of the Hazen Williams formula to calculate head losses, in addition the design considers minor losses produced by accessories such as control or shut-off valves, air valves, drain valves, elbows and teas. Within the applications of the spreadsheet there is the entry of valves at the discretion of the designer considering the AWWA design standards.