Hoja de Calculo de Red Agua Potable Linea 2 Parcial Agua Fria

download Hoja de Calculo de Red Agua Potable Linea 2 Parcial Agua Fria

of 13

Transcript of Hoja de Calculo de Red Agua Potable Linea 2 Parcial Agua Fria

Tabla de ClculoBENEMERITA UNIVERSIDADAUTONOMA DE PUEBLATABLA DE CALCULO DE REDES DE DISTRIBUCION DE AGUA POTABLEFACULTAD DE INGENIERIA CIVILPROYECTO: "VENUSTIANO CARRANZA" PUEBLAL I N E A N o. 2JUNIO DE 2009METODO HARDY-CROSS/MANNINGPROYECTISTA: ING. LAZARO GUTIERREZ GOMEZNo. de tramos: 124No. de nodos: 107TRAMOLONGITUDDIAM.DIAM.COEF.GASTOGASTOVEL.P.C.T.COTA DE T.N.(m)COTA PIEZOMETRICA(m)CARGA DISPONIBLE(m)Dea(m)INTER(mm)EFEVO(mm)RUGOSIDADINICIAL(lps)FINAL(lps)(m/s)(m)INICIALFINALINICIALFINALINICIALFINAL808160.000203.200203.2000.009100.000100.0003.0842.456147.100140.280147.100144.6440.0004.364818338.000203.200203.2000.00999.35599.3553.0641.536140.280135.960144.644143.1084.3647.148838440.000203.200203.2000.00998.94698.9463.0511.603135.960131.410143.108141.5057.14810.095848551.820203.200203.2000.00998.51698.5163.0382.059131.410125.520141.505139.44610.09513.926858630.602203.200203.2000.00997.95997.9593.0211.202125.520122.040139.446138.24413.92616.204868788.836203.200203.2000.00997.63097.6303.0113.466122.040119.940138.244134.77816.20414.838878888.062203.200203.2000.00996.67596.6752.9813.369119.940101.930134.778131.40914.83829.479888953.870203.200203.2000.00995.72895.7282.9522.021101.930100.950131.409129.38829.47928.438899026.931203.200203.2000.00995.14995.1492.9340.998100.950100.300129.388128.39028.43828.090909116.140203.200203.2000.00994.85994.8592.9250.595100.300100.000128.390127.79628.09027.79691921.015203.200203.2000.0090.0130.0130.0000.000100.000100.000127.796127.79527.79627.796919445.493203.200203.2000.00993.27793.2772.8761.620100.00098.383127.796126.17527.79627.79294951.009101.600101.6000.0090.0130.0130.0000.00098.38398.383126.175126.17527.79227.792949818.487203.200203.2000.00991.59991.5992.8250.63598.38397.870126.175125.54027.79227.67098991.000101.600101.6000.0090.0130.0130.0000.00097.87097.870125.540125.54027.67027.6709810055.301203.200203.2000.00990.15490.1542.7801.84097.87095.800125.540123.70027.67027.900100102121.834203.200203.2000.00989.08389.0832.7473.95895.80094.330123.700119.74327.90025.4131001011.153101.600101.6000.0090.0140.0140.0000.00095.80095.800123.700123.70027.90027.9001021036.476101.600101.6000.00921.31421.3142.6290.48694.33094.300119.743119.25725.41324.957102123337.106203.200203.2000.00966.45966.4592.0496.09594.33086.700119.743113.64825.41326.948103104107.199101.600101.6000.00910.50411.0481.3632.16094.30091.200119.257117.09724.95725.89710312054.876101.600101.6000.00910.74110.1961.2580.94294.30093.780119.257118.31524.95724.53510411955.625101.600101.6000.0090.4462.2030.2720.04591.20090.810117.097117.05325.89726.243104105111.594101.600101.6000.0098.9057.6930.9491.09091.20089.020117.097116.00725.89726.98710510956.688101.600101.6000.0091.9352.4280.3000.05589.02089.620116.007115.95226.98726.332105106112.719101.600101.6000.0095.7704.0650.5010.30789.02087.520116.007115.70026.98728.18010610756.093101.600101.6000.0093.3851.6790.2070.02687.52087.680115.700115.67428.18027.994106122109.145101.600101.6000.0091.1741.1740.1450.02587.52085.140115.700115.67528.18030.53510711163.139101.600101.6000.0094.0163.7610.4640.14787.68087.950115.674115.52627.99427.576BENEMERITA UNIVERSIDADAUTONOMA DE PUEBLAFACULTAD DE INGENIERIA CIVILHOJA 1 DE 4TABLA DE CALCULO DE REDES DE DISTRIBUCION DE AGUA POTABLEPROYECTO: "VENUSTIANO CARRANZA" PUEBLAL I N E A N o. 2JUNIO DE 2009TRAMOLONGITUDDIAM.DIAM.COEF.GASTOGASTOVEL.P.C.T.COTA DE T.N.(m)COTA PIEZOMETRICA(m)CARGA DISPONIBLE(m)Dea(m)INTER(mm)EFEVO(mm)RUGOSIDADINICIAL(lps)FINAL(lps)(m/s)(m)INICIALFINALINICIALFINALINICIALFINAL107108109.377101.600101.6000.0091.1761.1760.1450.02587.68085.660115.674115.64927.99429.989109107112.864101.600101.6000.0092.4113.8610.4760.27889.62087.680115.952115.67426.33227.99410911024.091101.600101.6000.0094.1994.4540.5490.07989.62089.540115.952115.87326.33226.333110111119.360101.600101.6000.0093.9404.1950.5170.34789.54087.950115.873115.52626.33327.57611111261.856101.600101.6000.0094.8074.8070.5930.23687.95088.850115.526115.29027.57626.440111117110.398101.600101.6000.0091.1871.1870.1460.02687.95084.990115.526115.50127.57630.5111121161.000101.600101.6000.0090.0130.0130.0000.00088.85088.850115.290115.29026.44026.440112115108.697101.600101.6000.0091.1691.1690.1440.02588.85085.390115.290115.26626.44029.876118109110.988101.600101.6000.0096.4987.7100.9511.08990.81089.620117.041115.95226.23126.3321181211.000101.600101.6000.0090.0130.0130.0000.00090.81090.810117.041117.04126.23126.231120119107.004101.600101.6000.0099.0008.4551.0431.26393.78090.810118.315117.05324.53526.243123124105.098203.200203.2000.00962.83462.8341.9381.69986.70085.140113.648111.94926.94826.8091241255.641101.600101.6000.0099.7139.7131.1980.08885.14085.140111.949111.86126.80926.721124136118.526203.200203.2000.00951.99151.9911.6031.31285.14082.330111.949110.63726.80928.307125126112.444101.600101.6000.0094.7653.9960.4930.29685.14082.400111.861111.56526.72129.16512513056.376101.600101.6000.0094.8875.6570.6980.29885.14085.660111.861111.56326.72125.9031261276.970101.600101.6000.0093.5562.7870.3440.00982.40082.330111.565111.55629.16529.22612712949.300101.600101.6000.0092.4071.6380.2020.02282.33083.320111.556111.53429.22628.2141271281.157101.600101.6000.0090.0130.0130.0000.00082.33082.330111.556111.55629.22629.22612913362.071101.600101.6000.0094.1962.3660.2920.05783.32083.220111.534111.47728.21428.257130129112.455101.600101.6000.0092.3191.2580.1550.02985.66083.320111.563111.53425.90328.21413013161.902101.600101.6000.0090.7532.5830.3190.06885.66084.990111.563111.49525.90326.505131133111.969101.600101.6000.0090.8291.0020.1240.01984.99083.220111.495111.47726.50528.25713113259.548101.600101.6000.0090.0750.7470.3190.06885.00085.390111.495111.48926.50526.2331331341.000101.600101.6000.0090.0130.0130.0000.00083.22083.210111.477111.47628.25728.26613613728.682203.200203.2000.00950.71750.7171.5640.30282.33082.100110.637110.33528.30728.23513713812.550203.200203.2000.00950.40850.4081.5540.13182.10082.090110.335110.20528.23528.115138139142.314101.600101.6000.0094.0564.0560.5000.38682.09080.250110.205109.81828.11529.56813814482.360203.200203.2000.00946.21746.2171.4250.72082.09081.470110.205109.48528.11528.0151391431.000101.600101.6000.0090.0130.0130.0000.00080.25080.250110.205110.20529.56829.56813914035.017101.600101.6000.0091.4091.4090.1740.01180.25081.290109.820109.81029.56828.51713914278.764101.600101.6000.0090.9880.9880.1220.01380.25081.020109.820110.20529.56828.78314014177.386101.600101.6000.0090.9700.9700.1230.01281.29080.960109.810109.80028.52028.0801441451.429203.200203.2000.00945.33245.3321.3980.01281.47081.380109.485109.47328.01528.093145146155.019203.200203.2000.00926.07126.0710.8040.43181.38080.960109.473109.04128.09328.0811451706.411101.600101.6000.00919.24619.2462.3740.39281.38081.380109.473109.08128.09327.701HOJA 2 DE 4BENEMERITA UNIVERSIDADAUTONOMA DE PUEBLATABLA DE CALCULO DE REDES DE DISTRIBUCION DE AGUA POTABLEFACULTAD DE INGENIERIA CIVILPROYECTO: "VENUSTIANO CARRANZA" PUEBLAL I N E A N o. 2JUNIO DE 2009TRAMOLONGITUDDIAM.DIAM.COEF.GASTOGASTOVEL.P.C.T.COTA DE T.N.(m)COTA PIEZOMETRICA(m)CARGA DISPONIBLE(m)Dea(m)INTER(mm)EFEVO(mm)RUGOSIDADINICIAL(lps)FINAL(lps)(m/s)(m)INICIALFINALINICIALFINALINICIALFINAL1461475.123203.200203.2000.00924.40424.4040.7530.01280.96080.960109.041109.02928.08128.0691471487.683203.200203.2000.00918.50618.5060.5710.01180.96080.960109.029109.01828.06928.058147167212.643203.200203.2000.0095.8435.8430.1800.03080.96079.600109.029108.99928.06929.39914814950.704101.600101.6000.0099.1867.8350.9660.51480.96080.270109.018108.50428.05828.23414816462.298203.200203.2000.0099.23710.5880.3260.02980.96080.170109.018108.99028.05828.82014916363.507101.600101.6000.0090.3540.3720.0460.00180.27080.200108.504108.50328.23428.30314915034.363101.600101.6000.0098.2876.9180.8530.27180.27080.270108.504108.23328.23427.96315016264.323101.600101.6000.0092.2540.4440.0550.00280.27080.100108.233108.23127.96328.131150151be101.600101.6000.0095.6636.1040.7530.29480.27079.890108.233107.93927.96328.04915116065.453101.600101.6000.0090.1990.7240.0890.00679.89080.120107.939107.93328.04927.81315115286.311101.600101.6000.0095.3474.8660.6000.33779.89079.530107.939107.60128.04928.07115215868.081101.600101.6000.0091.4770.7270.0900.00679.53078.940107.601107.59628.07128.656152153111.613101.600101.6000.0092.9423.2100.3960.19079.53078.670107.601107.41228.07128.74215315671.485101.600101.6000.0090.0990.7710.0950.00778.67078.100107.412107.40528.74229.30515315459.291101.600101.6000.0091.8401.2390.1530.01578.67078.330107.412107.39728.74229.067154155127.382101.600101.6000.0091.2030.6020.0740.00878.33079.350107.397107.38929.06728.039156155160.362101.600101.6000.0090.1670.7680.0950.01678.10079.350107.405107.38929.30528.03915615766.478101.600101.6000.0090.7150.7150.0880.00678.10078.480107.405107.39929.30528.919158156112.646101.600101.6000.0093.4733.2040.3950.19178.94078.100107.596107.40528.65629.30516416538.505203.200203.2000.0090.4140.4140.0130.00080.17080.750108.990108.99028.82028.240167168175.735203.200203.2000.0093.5573.5570.1100.00979.60078.700108.999108.99029.39930.290168169155.097203.200203.2000.0091.6681.6680.0510.00278.70079.300108.990108.98830.29029.688170171107.032101.600101.6000.0099.5198.6011.0611.30781.38080.520109.081107.77427.70127.25417017757.093101.600101.6000.0099.65810.5761.3041.05481.38081.010109.081108.02527.70127.01517117656.361101.600101.6000.0090.2943.1910.3940.09580.52080.150107.774107.67927.25427.529171172110.742101.600101.6000.0098.0744.2590.5250.33180.52079.750107.774107.44127.25427.69117217556.355101.600101.6000.0094.1250.9640.1190.00979.75079.600107.441107.43227.69127.832172173112.511101.600101.6000.0092.7582.1040.2590.08279.75080.140107.441107.35927.69127.219173187109.821101.600101.6000.0091.1811.1810.1460.02580.14081.400107.359107.33327.21925.93317317456.459101.600101.6000.0091.0740.5560.0350.00380.14079.290107.359107.35928.06927.21917418461.371101.600101.6000.0091.9370.3090.0380.00679.29078.810107.359107.35828.06928.548BENEMERITA UNIVERSIDADAUTONOMA DE PUEBLAHOJA 3 DE 4FACULTAD DE INGENIERIA CIVILTABLA DE CALCULO DE REDES DE DISTRIBUCION DE AGUA POTABLEPROYECTO: "VENUSTIANO CARRANZA" PUEBLAL I N E A N o. 2JUNIO DE 2009TRAMOLONGITUDDIAM.DIAM.COEF.GASTOGASTOVEL.P.C.T.COTA DE T.N.(m)COTA PIEZOMETRICA(m)CARGA DISPONIBLE(m)Dea(m)INTER(mm)EFEVO(mm)RUGOSIDADINICIAL(lps)FINAL(lps)(m/s)(m)INICIALFINALINICIALFINALINICIALFINAL17418673.385101.600101.6000.0090.7890.7890.0970.00879.29080.950107.359107.35228.06926.402175174112.165101.600101.6000.009-0.9081.9910.2460.07379.60079.290107.432107.35927.83228.06917518262.122101.600101.6000.0090.8520.8230.1010.00779.60079.400107.432107.42527.83228.025176175111.761101.600101.6000.0092.3703.6620.4520.24780.15079.600107.679107.43227.52927.83217618062.683101.600101.6000.0092.3192.1540.2660.04880.15080.200107.679107.63027.52927.430177176106.556101.600101.6000.0091.4634.4320.5470.34581.01080.150108.025107.67927.01527.52917717862.493101.600101.6000.0096.4354.3840.5410.19881.01081.020108.025107.82727.01526.807178180106.437101.600101.6000.0095.3993.3480.4130.19781.02080.200107.827107.63026.80727.43017817933.896101.600101.6000.0090.3640.3640.0450.00181.02080.960107.827107.82626.80726.866180182112.496101.600101.6000.0095.5353.3180.4090.20480.20079.400107.630107.42527.43028.02518018133.966101.600101.6000.0090.3650.3650.0450.00180.20080.150107.630107.62927.43027.479182184111.755101.600101.6000.0094.1481.9030.2350.06779.40078.810107.425107.35828.02528.54818218333.529101.600101.6000.0090.3600.3600.0440.00179.40079.530107.425107.42428.02527.89418418532.565101.600101.6000.0090.3500.3500.0430.00178.81078.670107.358107.35828.54828.688*** FIN DE REPORTE ***BENEMERITA UNIVERSIDADAUTONOMA DE PUEBLAFACULTAD DE INGENIERIA CIVILHOJA 4 DE 4

&C&"Arial,Normal"&8&K09-024www.masdisenourbano.com Tel 52(81) 8143 0851

Iteraciones

NodosRESULTADOS EN NODOSNODODESCRIPCIONCOTA PIEZ.(m)COTA T.N.(m)PRESION(m)Q (lps)Q adic.(lps)Q total (lps)TRAMOSDeaQ (lps)1116.586.5300-100-100126.156428135.449921488.3936521002116.46597388.827.6659736.15642806.15642821-6.156428-6.1564283116.4763957838.4763955.4499205.4499231-5.44992-5.449924113.15982.7530.4092.93222802.93222841-88.3936524585.461424-2.9322285110.2328988030.2328982.74734102.74734154-85.461424567.399765573.7190715871.595246-2.7473416110.17381186.523.6738117.39976507.39976565-7.399765-7.3997657110.22539677.9232.3053963.71907103.71907175-3.719071-3.7190718108.09566376.531.5956632.85921702.85921785-71.5952468968.73603-2.8592179106.0434977333.0434972.97856502.97856598-68.7360391065.757464-2.97856510105.54911273.532.0491120.7840400.7840410118.486765109-65.757464101256.486659-0.7840411105.45997482.822.6599748.48676508.4867651110-8.486765-8.48676512104.11088373.530.6108833.09100503.0910051210-56.486659121353.395654-3.09100513103.08508573.529.5850852.46725202.4672521312-53.39565413228.304058131442.624345-2.46725214102.6070997329.6070991.8041101.804111413-42.624345141540.820235-1.8041115101.24648876.7524.4964885.59946505.5994651514-40.82023515168.726085151726.494685-5.59946516101.14959482.818.3495948.72608508.7260851615-8.726085-8.72608517100.668618218.668615.64522905.6452291715-26.49468517187.146624171913.702832-5.64522918100.61538286.514.1153827.14662407.1466241817-7.146624-7.14662419100.5145698713.5145695.62572605.6257261917-13.70283219205.65072619212.42638-5.62572620100.48825888.811.6882585.65072605.6507262019-5.650726-5.65072621100.51248685.515.0124862.4263802.426382119-2.42638-2.4263822103.00158180.2822.7215818.30405808.3040582213-8.304058-8.304058