Hoja1TramoLongitudHabitantesGastos (lps)Dimetro (mm)RugosidadPerdida de CargaCotasCarga DisponibleDeARealVirtualIndice de hacinamientoLotesPropiosTributariosTotalesDotacionQmCoeficiente de variacion diariaQmDCoeficiente de variacion horariaQmhQ, areas verdesQ totalTericoPropuestoArea del tuboComprobacion por velocidadPiezomtricoTerreno4.5000015001.401.5500000001501248.813814.54180181500.0311.40.0431.550.06700.0678.431750.00440.0151500.000261620.451161010.45132201932350.263614.541818361500.0631.40.0881.550.13600.13612.013750.00440.0311500.001011620.452160812.45158431973450.121414.541836541500.0941.40.1321.550.20500.20514.748750.00440.0471500.002151620.453160614.4525900254410138.970624.51881541351500.2341.40.3281.550.50800.50823.216750.00440.1151500.032131620.455160416.4547387743

7850.326524.58360361500.0631.40.0881.550.13600.13612.013750.00440.0311500.001011620.428160317.4275785243

58138.990324.518810811500.1411.40.1971.550.30500.30517.989750.00440.0691500.012461620.416160317.41612414578949.608724.58361171531500.2661.40.3721.550.57700.57724.743750.00440.1311500.014531620.429160218.4285854885

69139.123824.518810811500.1411.40.1971.550.30500.30517.989750.00440.0691500.012471620.431160218.430643222791052.04824.58362342701500.4691.40.6571.551.01801.01832.865750.00440.2311500.043751620.443160911.44311653461011150.799624.5231044055091500.8841.41.2381.551.91901.91945.123750.00440.4361500.411441620.487161010.4868714873

141550.699324.58360361500.0631.40.0881.550.13600.13612.013750.00440.0311500.001011620.881160911.8809408639

1215151.304824.520900901500.1561.40.2181.550.33800.33818.938750.00440.0771500.016421620.866160812.8655385606151650.512524.58361261621500.2811.40.3931.550.60900.60925.42750.00440.1381500.016361620.882161010.8819552873

1316151.028924.520900901500.1561.40.2181.550.33800.33818.938750.00440.0771500.016391620.882160713.8819241806161149.554924.58362522881500.51.40.71.551.08501.08533.93750.00440.2471500.046891620.898160515.89831097181117150.486124.524108796.5904.51501.571.42.1981.553.40703.40760.124750.00440.7741501.192191620.945160614.9452047449

202151.098224.58360361500.0631.40.0881.550.13600.13612.013750.00440.0311500.001021619.218160613.218041885

1821150.382924.520900901500.1561.40.2181.550.33800.33818.938750.00440.0771500.016321619.203160613.2027475903212250.823224.58361261621500.2811.40.3931.550.60900.60925.42750.00440.1381500.016461619.219160613.2190642899

1922150.536624.520900901500.1561.40.2181.550.33800.33818.938750.00440.0771500.016331619.219160613.2191872013221750.45624.58362522881500.51.40.71.551.08501.08533.93750.00440.2471500.047751619.236160712.23552057751723140.839524.523103.51192.512961502.251.43.151.554.88304.88371.979750.00441.111502.176961619.283160910.283267061

262750.145914.54180181500.0311.40.0431.550.06700.0678.431750.00440.0151500.000271621.423161011.4229650908

2427138.136424.518810811500.1411.40.1971.550.30500.30517.989750.00440.0691500.012381621.411161011.4108497639272850.761514.5418991171500.2031.40.2841.550.4400.4421.607750.00440.11500.008991621.423161011.4232345493

2528138.241224.518810811500.1411.40.1971.550.30500.30517.989750.00440.0691500.012391621.420161011.419828338282350.469314.54181982161500.3751.40.5251.550.81400.81429.388750.00440.1851500.028011621.432161011.43222251932329125.113314.51254151215661502.7191.43.8071.555.90105.90179.1271000.00790.7511500.677171621.460161011.4602311806

3432289.798124.541184.50184.51500.321.40.4481.550.69400.69427.136750.00440.1581500.119601621.536161011.53567161073233327.725824.5401801853651500.6341.40.8881.551.37601.37638.21750.00440.3131500.482131621.655161110.65527283353329200.603614.522993654641500.8061.41.1281.551.7480.5122.2648.969750.00440.5141500.741571622.137161210.1373989012293030.69604.500203020301503.5241.44.9341.557.648030.64180.3052000.0314160.9751500.121031622.879161210.8793468.4845117.41224.37316231613

Hoja2TramoLongitudHabitantesGastos (lps)RugosidadPerdida de CargaCotasCarga DisponibleDeARealIndice de hacinamientoLotesPropiosTributariosTotalesDotacionQmCoeficiente de variacion diariaQmDCoeficiente de variacion horariaQmhQ, localQ. casetaQ, areas verdes y jardines vecinalesQ, clubes - restaurantesQ, totalTericoPropuestoArea del tuboComprobacion por velocidadPiezomtricoTerreno43101.165311551552500.4481.40.6271.550.9720.0440.0071.02332.946750.00440.2331500.08614.7481.2613.48832123.935211051552602500.7521.41.0531.551.6320.782.41250.589750.00440.5481500.51714.2311.4712.761

871145321601602500.4631.40.6481.551.0040.0120.0071.02332.946750.00440.2331500.09714.7372.112.6377614.66501601602500.4631.40.6481.551.0040.0411.04533.298750.00440.2381500.01314.7241.5913.1346556.3458401602002500.5791.40.8111.551.2570.0081.26536.636750.00440.2881500.07114.6531.5913.0635233.5652002002500.5791.40.8111.551.2571.25736.52750.00440.2861500.04214.6121.2613.352

1218.254602501.3311.41.8631.552.8880.0073.67662.453750.00440.8351500.16614.8341.313.53415.0001.3

Hoja4TramoLongitudHabitantesGastos (lps)RugosidadPerdida de CargaCotasCarga DisponibleDeARealIndice de hacinamientoLotesPropiosTributariosTotalesDotacionQmCoeficiente de variacion diariaQmDCoeficiente de variacion horariaQmhQ, localQ. casetaQ, areas verdes y jardines vecinalesQ, clubes - restaurantesQ, totalTericoPropuestoArea del tuboComprobacion por velocidadPiezomtricoTerreno43101.165311551552500.4481.40.6271.550.9720.0440.0071.02332.946750.00440.2331500.08614.7481.2613.48832123.935211051552602500.7521.41.0531.551.6320.782.41250.589750.00440.5481500.51714.2311.4712.761

871145321601602500.4631.40.6481.551.0040.0120.0071.02332.946750.00440.2331500.09714.7372.112.6377614.66501601602500.4631.40.6481.551.0040.0411.04533.298750.00440.2381500.01314.7241.5913.1346556.3458401602002500.5791.40.8111.551.2570.0081.26536.636750.00440.2881500.07114.6531.5913.0635233.5652002002500.5791.40.8111.551.2571.25736.52750.00440.2861500.04214.6121.2613.352

1218.254602501.3311.41.8631.552.8880.0073.67662.453750.00440.8351500.16614.8341.313.53415.0001.3

Hoja3

PROYECTO:

DISEO HIDRULICOCONCEPTOCANTIDADUNIDADPOB. FIJA1,004Hab.LISTA DE MATERIAL
WinuE: WinuE:DATOS DEL MATERIAL A UTILIZARPOB. FLOTANTE0Hab.1C.S.CONCRETO SIMPLEMATERIAL A UTILIZAR:6POBLACIN TOTAL1,004Hab.2C.R.CONCRETO REFORZADOVELOCIDAD MXIMA PERMISIBLE (m/s):ERROR:#N/ACOEF. APORTACIN75%3AC.ACEROVELOCIDAD MNIMA PERMISIBLE (m/s):ERROR:#N/ADOTACIN POB. FIJA 150.00lt/hab/da4FC.FIBROCEMENTOCOEFICIENTE DE RUGOSIDAD (Adim.)0.009DOTACIN POB. FLOTANTE150.00lt/hab/da5PEADPOLIETILENO DE ALTA DENSIDAD INFILTRACIN (m3/seg.)0.0000APORTACIN POB. FIJA112.50lt/hab/da6PVC_MPOLI (CLORURO DE VINILO) PVC (Mtrico)PROFUNDIDAD DEL POZO INICAL (m)1.2APORTACIN POB. FLOTANTE112.50lt/hab/da7PVC_IPOLI (CLORURO DE VINILO) PVC (Ingls) PENDIENTE MNIMA PROPUESTA (mm)2.00COEFICIENTE DE PREVISIN1.5LONGITUD DEL TRAMO0.00mDENSIDAD DE POBLACIN FIJA0.000000000Hab./mDENSIDAD DE POBLACIN FLOT.0.000000000Hab./m NO. DE TRAMOP O Z OPOBLACIN ACUMULADA TOTAL (Hab.)COEFICIENTE DE HARMON POB. FIJA (Hab.)POBLACIN FLOTANTE A FUTURO ACUMULADA TOTAL (Hab.)COEFICIENTE DE HARMON POB. FLOTANTE (Hab.)GASTO RESIDUAL MEDIO (m3/seg.)GASTO RESIDUAL MNIMO (m3/seg.)GASTO RESIDUAL Mx. Inst. (m3/seg.)GASTO RESIDUAL Mx. Ext. (m3/seg.) GASTO DE INFILTRA. (m3/seg.) GASTO DE DISEO (m3/seg.) E L E V A C I O N E S CADA (m)TIPO DE POZOPROFUNDIDAD DE POZO (m)CADENAMIENTO COLECTOR (m)CADENAMIENTO TRAZOLONG. (m)PENDIEN. TERR (Por cada mil m.)PENDIEN. PROP (Por cada mil m.)PENDIEN. MN. PERMISIBLE (Por cada mil m.)DIMETRO (m)REA TUBO (m2)Vel. A TUBO LLENO (m/seg.)Q. TUBO LLENO (m3/seg.)VELOCIDAD EFECTIVA (m/seg.) TIRANTE (m)RELACIN DE GASTOSRELACIN DE VELOCIDADRELACIN DE TIRANTES C O L C H NVOLMENES T E R R E N OP L A N T I L L AINICIAL (m)FINAL (m)EXCAVACIN m3PLANTILLA m3RELLENO m3INICIALFINALINICIAL (m)FINAL (m)INICIAL (m)FINAL (m)EXCAVACINEXCAVACINEXCAVACIN

112273.8000.000000.000000.000000.00000-0.160600.00150110.89109.56109.56108.36CONTADOCONTADO1.2071.0071.0019.0019.00FALSE0.200.03-0.01-0.000.840.02-4.170.400.111.131.00FALSEFALSE-2.23223593.8000.000000.000000.000000.00000-0.160600.00150109.69106.24108.36105.040.00POZO COMUN1.2071.0071.0049.0047.00FALSE0.200.03-0.02-0.001.140.02-2.650.350.091.131.00FALSEFALSE-2.23334863.8000.000000.000000.000000.00000-0.162860.00150106.24105.04105.04103.840.00POZO COMUN1.2072.0072.0017.0017.00FALSE0.200.03-0.01-0.000.810.02-4.410.410.111.001.00FALSEFALSE-2.26

454323.8000.000000.000000.000000.00000-0.171910.00150105.34105.04104.14103.840.00POZO COMUN1.20176.9876.004.004.00FALSE0.200.03-0.01-0.000.500.03-9.090.530.151.001.00FALSEFALSE-2.3954131173.8000.000000.000000.000000.00000-0.117620.00150105.04100.95103.8499.750.00POZO COMUN1.20219.0452.0079.007.00FALSE0.200.03-0.01-0.000.620.03-6.870.490.131.001.00FALSEFALSE-1.63

656323.8000.000000.000000.000000.00000-0.171910.00150105.34104.50104.14103.300.00POZO COMUN1.20252.5876.0011.0011.05FALSE0.200.03-0.01-0.000.710.02-5.470.450.121.001.00FALSEFALSE-2.39767633.8000.000000.000000.000000.00000-0.176430.00150104.50103.53103.30102.230.00POZO COMUN1.20315.2978.0012.0013.72FALSE0.200.03-0.01-0.000.760.02-4.910.430.111.001.10FALSEFALSE-2.45878863.8000.000000.000000.000000.00000-0.176430.00150103.53102.02102.23100.820.00POZO COMUN1.30393.2378.0019.0018.08FALSE0.200.03-0.01-0.000.830.02-4.270.410.111.101.00FALSEFALSE-2.4598171173.8000.000000.000000.000000.00000-0.150760.00150102.02100.63100.8299.430.00POZO COMUN1.20435.9166.6521.009.00FALSE0.200.03-0.01-0.000.670.02-6.060.470.121.001.00FALSEFALSE-2.09

10910543.8000.000000.000000.000000.00000-0.160600.00150109.62108.23108.42107.030.00POZO COMUN1.20484.4271.0020.0013.00FALSE0.200.03-0.01-0.000.750.02-5.040.430.111.001.00FALSEFALSE-2.231110111173.8000.000000.000000.000000.00000-0.160600.00150108.23105.01107.03103.910.00POZO COMUN1.20524.4371.0045.0019.00FALSE0.200.03-0.01-0.000.840.02-4.170.400.111.000.90FALSEFALSE-2.231211121533.8000.000000.000000.000000.00000-0.108570.00150105.01101.36103.91100.160.00POZO COMUN1.10566.4748.0076.0021.00FALSE0.200.03-0.01-0.000.870.02-3.970.400.100.901.00FALSEFALSE-1.511312131713.8000.000000.000000.000000.00000-0.054290.00150101.36100.95100.1699.750.001.20611.5424.0017.0022.00FALSE0.200.03-0.01-0.000.880.02-3.870.390.101.001.00FALSEFALSE-0.75

1461503.8000.000000.000000.000000.00000-0.117620.00150104.50103.36103.30102.160.001.20661.5252.0022.0020.00FALSE0.200.03-0.01-0.000.850.02-4.060.400.101.001.00FALSEFALSE-1.63151514633.8000.000000.000000.000000.00000-0.171910.00150103.36102.82102.16101.620.001.20706.6276.007.0016.00FALSE0.200.03-0.01-0.000.790.02-4.540.420.111.001.00FALSEFALSE-2.391614131263.8000.000000.000000.000000.00000-0.171910.00150102.82100.95101.6299.750.001.20756.5376.0025.0013.00FALSE0.200.03-0.01-0.000.750.02-5.040.430.111.001.00FALSEFALSE-2.391713211263.8000.000000.000000.000000.00000-0.117620.00150100.9598.1699.7596.960.001.20774.2652.0054.0026.00FALSE0.200.03-0.01-0.000.930.02-3.560.380.101.001.00FALSEFALSE-1.63

181516143.8000.000000.000000.000000.00000-0.087720.00150103.36103.23102.16102.03CONTADOCONTADO1.2071.0038.783.0019.00FALSE0.200.03-0.01-0.000.840.02-4.170.400.111.001.00FALSEFALSE-1.22191617453.8000.000000.000000.000000.00000-0.167950.00150103.23100.63102.0399.430.00POZO COMUN1.2071.0074.2535.0047.00FALSE0.200.03-0.02-0.001.140.02-2.650.350.091.001.00FALSEFALSE-2.332017E1623.8000.000000.000000.000000.00000-0.041850.00150100.63100.4099.4399.200.00POZO COMUN1.2072.0018.5012.0017.00FALSE0.200.03-0.01-0.000.810.02-4.410.410.111.001.00FALSEFALSE-0.58

211819633.8000.000000.000000.000000.00000-0.160600.00150107.44106.68106.24105.48CONTADOCONTADO1.2071.0071.0011.0019.00FALSE0.200.03-0.01-0.000.840.02-4.170.400.111.001.00FALSEFALSE-2.232219201263.8000.000000.000000.000000.00000-0.160600.00150106.68102.47105.48101.270.00POZO COMUN1.2071.0071.0059.0047.00FALSE0.200.03-0.02-0.001.140.02-2.650.350.091.001.00FALSEFALSE-2.232320211803.8000.000000.000000.000000.00000-0.041850.00150102.4798.16101.2796.960.00POZO COMUN1.2072.0018.50233.0017.00FALSE0.200.03-0.01-0.000.810.02-4.410.410.111.001.00FALSEFALSE-0.58

242322503.8000.000000.000000.000000.00000-0.153540.00150101.3499.19100.1497.990.001.20661.5267.8832.0020.00FALSE0.200.03-0.01-0.000.850.02-4.060.400.101.001.00FALSEFALSE-2.132522211083.8000.000000.000000.000000.00000-0.153520.0015099.1998.1697.9996.960.001.20706.6267.8715.0016.00FALSE0.200.03-0.01-0.000.790.02-4.540.420.111.001.00FALSEFALSE-2.132621272843.8000.000000.000000.000000.00000-0.117620.0015098.1696.7396.9695.530.001.20756.5352.0027.0013.00FALSE0.200.03-0.01-0.000.850.03-5.040.490.131.001.00FALSEFALSE-1.63

271903.8000.000000.000000.000000.00000-0.117620.00150110.89109.62109.69108.420.001.20661.5252.0024.0020.00FALSE0.200.03-0.01-0.000.850.02-4.060.400.101.001.00FALSEFALSE-1.632821803.8000.000000.000000.000000.00000-0.117620.00150109.62107.44108.42106.240.001.20706.6252.0042.0016.00FALSE0.200.03-0.01-0.000.790.02-4.540.420.111.001.00FALSEFALSE-1.6329182403.8000.000000.000000.000000.00000-0.117620.00150107.44104.82106.24103.620.001.20756.5352.0050.0013.00FALSE0.200.03-0.01-0.000.750.02-5.040.430.111.001.00FALSEFALSE-1.63302425273.8000.000000.000000.000000.00000-0.160600.00150104.82102.98103.62101.780.001.20774.2671.0026.0026.00FALSE0.200.03-0.01-0.000.930.02-3.560.380.101.001.00FALSEFALSE-2.23312526593.8000.000000.000000.000000.00000-0.160600.00150102.9898.33101.7897.130.001.20774.2671.0065.0026.00FALSE0.200.03-0.01-0.000.930.02-3.560.380.101.001.00FALSEFALSE-2.23

3231103.8000.000000.000000.000000.00000-0.117620.00150106.24105.01105.04103.910.00POZO COMUN1.20484.4252.0024.0013.00FALSE0.200.03-0.01-0.000.750.02-5.040.430.111.000.90FALSEFALSE-1.6333112003.8000.000000.000000.000000.00000-0.117620.00150105.01102.47103.91101.270.00POZO COMUN1.10524.4352.0049.0019.00FALSE0.200.03-0.01-0.000.840.02-4.170.400.110.901.00FALSEFALSE-1.6334202603.8000.000000.000000.000000.00000-0.117620.00150102.4798.33101.2797.130.00POZO COMUN1.20566.4752.0080.0021.00FALSE0.200.03-0.01-0.000.870.02-3.970.400.101.001.00FALSEFALSE-1.633526271453.8000.000000.000000.000000.00000-0.162860.0015098.3396.7397.1395.530.001.20611.5472.0022.0022.00FALSE0.200.03-0.01-0.000.880.02-3.870.390.101.001.00FALSEFALSE-2.26

361623323.8000.000000.000000.000000.00000-0.171270.00150102.23101.34102.03100.140.001.20661.5275.7212.0020.00FALSE0.200.03-0.01-0.000.850.02-4.060.400.100.001.00FALSEFALSE-2.38372328633.8000.000000.000000.000000.00000-0.171270.00150101.3498.33100.1497.130.001.20706.6275.7240.0016.00FALSE0.200.03-0.01-0.000.790.02-4.540.420.111.001.00FALSEFALSE-2.38382827323.8000.000000.000000.000000.00000-0.182540.0015098.3396.7397.1395.530.001.20756.5380.7020.0013.00FALSE0.200.03-0.01-0.000.750.02-5.040.430.111.001.00FALSEFALSE-2.543927298423.8000.000000.000000.000000.00000-0.152820.0015096.7393.5895.5392.380.001.20774.2667.5647.0026.00FALSE0.200.03-0.01-0.001.480.04-3.560.610.201.001.00FALSEFALSE-2.124029308423.8000.000000.000000.000000.00000-0.152840.0015093.5890.4492.3889.240.001.20774.2667.5746.0026.00FALSE0.200.03-0.01-0.001.480.04-3.560.610.201.001.00FALSEFALSE-2.124130318423.8000.000000.000000.000000.00000-0.152910.0015090.4487.0989.2485.890.001.20661.5267.6050.0020.00FALSE0.200.03-0.01-0.001.340.04-4.060.630.211.001.00FALSEFALSE-2.122831328423.8000.000000.000000.000000.00000-0.146120.0015087.0983.7685.8982.900.001.20706.6264.6052.0016.00FALSE0.200.03-0.01-0.001.230.04-4.540.650.221.000.66FALSEFALSE-2.032932E8423.8000.000000.000000.000000.00000-0.053380.0015083.7684.0082.9082.800.000.86756.5323.60-10.000.00FALSE0.200.030.000.000.580.07ERROR:#DIV/0!0.860.370.661.00FALSEFALSE-0.741,004