excel abastos

3
TRAMO (m) CAUDAL (l/s) TRAMO DISEÑO RES-A 1.758 60 1 1/2 1.541981055 A- 0.191 1.758 125 1 1/2 1.541981055 -C 0.252 0.747 97 1 1/2 0.655210!8 C-D 0.25 0.25 67 1 0.49!!81!1 C-E 0.245 0.245 105 1 0.48!51!684 -R" 0.156 0.82 109 1 1/2 0.719240!1 R"-# 0.161 0.664 98 1 1/2 0.582409227 #-$ 0.186 0.186 119 1 0.!67075695 #-% 0.164 0.!14 100 1 0.619686926 %-I 0.15! 0.15! 120 1 0.!01949!62 1.758 LO&$ITUD (m) DIAMETRO ('l ) ELOCIDAD (m/s)

Upload: dither-vargas-gutierrez

Post on 05-Nov-2015

215 views

Category:

Documents


0 download

DESCRIPTION

hoja de calculo para abastecimientos

TRANSCRIPT

Hoja1TRAMO (m)CAUDAL (l/s)LONGITUD (m)DIAMETRO (plg)VELOCIDAD (m/s)PERDIDA DE CARGACOTA PIEZOMETRICA (msnm)TERRENO (msnm)PRESION TRAMODISEOUNIT (%)TRAMO (m)INICIALFINALINICIALFINALINICIALFINALRES-A1.758601 1/21.541981055373.01201779364.380721067624622457.619278932424622443014.6192789324A-B0.1911.7581251 1/21.541981055373.01201779369.12650222422457.61927893242448.49277670822443243214.619278932416.4927767082B-C0.2520.747971 1/20.655210380114.96456935321.45156322732448.49277670822447.04121348092432243016.492776708217.0412134809C-D0.250.256710.493381310314.2023248540.95155576522447.04121348092446.08965771572430242417.041213480922.0896577157C-E0.2450.24510510.483513684113.68079811681.43648380232447.04121348092445.60472967862430243217.041213480913.6047296787B-RP0.1560.821091 1/20.719240310217.78491215381.93855542482448.49277670822446.55422128342432241216.492776708234.5542212834RP-F0.1610.664981 1/20.582409226812.03198633231.179134660624122410.820865339424122392018.8208653394F-G0.1860.18611910.36707569498.21356209980.97741388992410.82086533942409.84345144962392236918.820865339440.8434514496F-H0.1640.31410010.619686925821.6607549522.16607549522410.82086533942408.65478984422392238518.820865339423.6547898442H-I0.1530.15312010.30194936195.72077238150.68649268582408.65478984422407.96829715852385237223.654789844235.96829715851.758