calculo red alcantarillado

PULANSISTEMA DE ALCANTARILLADO,LOCALIDAD DE PULAN1.-NOMBRE DEL PROYECTO" AMPLIACION, MEJORAMIENTO DEL SISTEMA DE AGUA POTABLE Y SANEAMIENTO BSICO DE LA LOCALIDAD DE PULAN, DISTRITO DE PULAN - SANTA CRUZ - CAJAMARCA"

A.-POBLACION ACTUALN de Familias23661416B.-TASA DE CRECIMIENTO (%)1C.-PERIODO DE DISEO (AOS)20D.-POBLACION FUTURA Pf = Po * ( 1+ r*t/100 )1699E.-DOTACION (LT/HAB/DIA)100F.-CONSUMO PROMEDIO ANUAL (LT/SEG)Q = Pob.* Dot./86,4001.966G.-CONSUMO MAXIMO DIARIO (LT/SEG)Qmd = 1.30 * Q2.556H.-CONSUMO MAXIMO HORARIO (LT/SEG)Qmh = 2 * Qmd5.113H.-APORTE A LA RED DE ALCANTARILLADOQd = 0.8 * Qmh4.090H.-CAUDAL UNITARIO QuQu =Qd/N de Familias0.0173

ITEMTRAMOLONGITUD (m)CAUDAL (m3/s)PENDIENTE (M/M)DIAMETRO (mm)DIAMETRO COMERCIALVELOCIDADTENSION TRACTIVACOTAS CTI CTFVIVIENDAS EN EL TRAMO203.201.00P-9MH-7162.600.00150.04748.6249160mm2.2222.443205792091.502088.5324.7444089457152.401.082.00B-13MH-7652.520.00150.00197.7914160mm0.340.54041738112084.992085.052-0.1142421935152.403.00MH-76B-3329.510.00150.15239.0647160mm3.9872.13500726272085.052080.552152.404.00B-33B-1846.110.00150.08143.9735160mm2.9138.36889178322080.552076.815152.405.00B-18B-1950.000.00150.08144.0052160mm2.9038.22206408832076.812072.771152.406.00B-20B-2158.590.00150.10441.9753160mm3.2949.16958810462068.092062.005152.407.00B-26B-2527.610.00150.13939.7643160mm3.8065.61983634232067.612063.784152.408.00B-34B-1854.770.00150.00379.4061160mm0.601.64101909892077.002076.811152.409.00B-19B-2334.400.00150.02953.3025160mm1.7413.7513182452072.772071.77310.00B-23B-2453.050.00150.07844.2529160mm2.8637.0946021892071.772067.614152.4011.00B-24B-2560.270.00150.06446.0323160mm2.5730.06078781172067.612063.783152.4012.00B-4B-555.400.00150.23436.0579160mm4.93110.5764846892069.322056.376152.4013.00B-5B-668.310.00150.15938.7406160mm4.0775.41302643332067.262056.371152.4014.00B-6B-744.190.00150.04249.7791160mm2.0919.80388986442056.372054.520203.2015.00B-7B-826.020.00150.000ERROR:#DIV/0!160mm0.0000152.4016.00B-8B-4414.300.00150.000ERROR:#DIV/0!160mm0.0000152.4017.00B-44B-4335.080.00150.000ERROR:#DIV/0!160mm0.0000152.4015.00B-43B-4547.520.00150.05747.0085160mm2.4326.87757656972050.982048.280152.4016.00B-45B-4643.230.00150.01361.6184160mm1.186.3466643912048.282047.700152.4017.00B-46B-4040.320.00150.01758.7114160mm1.348.21259284072047.702047.00018.00B-39B-4022.240.00150.05547.2469160mm2.4026.16213028692048.232047.00019.00B-2B-2'65.380.00150.09442.7686160mm3.1344.49722985482078.982072.83020.00B-2B-1449.680.00150.04050.2403160mm2.0418.85325660832078.982077.00221.00B-14B-1552.380.00150.07344.8590160mm2.7534.49853432482077.002073.18322.00B-3B-3'68.290.00150.05946.7411160mm2.4727.70803031932073.652069.654152.4023.00B-3B-444.710.00150.09742.5356160mm3.1745.81271203812073.652069.321152.4024.00B-4'B-469.120.00150.04549.1404160mm2.1621.21586483862066.222069.32325.00B-27B-2828.860.00150.11940.9337160mm3.5256.22125926412064.432061.004152.4026.00B-28B-2956.900.00150.08543.5494160mm2.9840.4042247712061.002056.143152.4027.00B-29B-733.070.00150.04948.3340160mm2.2623.17307115682056.142054.526152.4028.00B-16B-1754.990.00150.04948.3468160mm2.2623.14042526132068.162065.474152.4029.00B-21B-228.200.00150.02754.1102160mm1.6712.69146054612062.002061.784152.4030.00B-10B-3660.110.00150.00288.0743160mm0.460.94435936972061.322061.204152.4031.00B-36B-25'30.070.00150.05547.3707160mm2.3825.79961323942061.202059.564152.4032.00B-25'B-3776.500.00150.06346.0703160mm2.5729.92862068652059.562054.724152.4033.00B-37B-4750.360.00150.08543.5521160mm2.9840.39108409052054.722050.424152.4034.00B-47B-3939.500.00150.05547.2250160mm2.4026.22707117222050.422048.234203.2035.00B-38B-3980.320.00150.06845.4386160mm2.6632.21561319122053.702048.234152.4036.00B-22B-22'68.610.00150.05946.6949160mm2.4827.85458685932061.782057.744152.4037.00B-22'B-3875.710.00150.05347.5650160mm2.3625.24241453462057.742053.704152.4038.00B-17B-17'68.210.00150.11141.4834160mm3.3952.36024592562065.472057.924152.4039.00B-17'B-4375.770.00150.09242.9827160mm3.0943.32763247372057.922050.983152.4040.00B-40B-4184.000.00150.05647.0692160mm2.4226.69327318752047.002042.26541.00B-41O-151.820.00150.06445.9879160mm2.5830.21574875812042.262038.95642.00B-15B-3515.010.00150.09342.8367160mm3.1244.12148478862073.182071.78543.00B-35B-1636.520.00150.09942.3506160mm3.2146.89003719632071.782068.16444.00B-25B-1063.080.00150.03950.4455160mm2.0118.44786866142063.782061.32345.00B-11B-3221.800.00150.01758.6671160mm1.358.24574459172087.452087.07546.00B-32B-1463.420.00150.15938.7697160mm4.0775.11142621582087.072077.00350.00B-1B-3118.860.00150.000ERROR:#DIV/0!160mm0.0002152.4047.00B-31B-259.500.00150.03850.6955160mm1.9917.96777286782081.242078.98548.00MH-71B-1139.380.00150.02753.8878160mm1.6912.97331070182088.532087.45649.00MH-77B-1848.150.00150.00478.3008160mm0.621.76839382292076.992076.815152.4050.00MH-78B-359.140.00150.09043.1131160mm3.0642.63327194542078.982073.656152.4051.00MH-79B-1556.260.00150.00867.9218160mm0.913.77528192472073.632073.18652.00MH-80B-1658.470.00150.02057.2608160mm1.449.38485724732069.322068.16653.00MH-81B-557.740.00150.15838.8240160mm4.0574.55338869772065.472056.37654.00MH-82B-2737.370.00150.02256.0614160mm1.5210.50649286942065.262064.43655.00MH-83B-1949.660.00150.00867.4912160mm0.933.90552945082073.182072.77656.00MH-84B-2052.690.00150.08543.5793160mm2.9840.25688629262072.572068.09657.00MH-87B-2441.510.00150.01263.3598160mm1.105.47004979192068.092067.61558.00MH-89B-2055.220.00150.00196.6935160mm0.360.5739594042068.162068.095152.4059.00MH-91B-2145.700.00150.03750.8942160mm1.9717.59687288772063.702062.00560.00MH-92B-2258.040.00150.06146.3584160mm2.5228.94998405882065.332061.78565.00MH-74MH-7647.650.00150.000ERROR:#DIV/0!160mm0.000566.00O-1B-5376.220.00150.000ERROR:#DIV/0!160mm0.0004152.4067.00B-53B-5472.670.00150.000ERROR:#DIV/0!160mm0.000168.00B-54CAMARA DE REJAS23.940.00150.000ERROR:#DIV/0!160mm0.000161.00B - 2'B-3'56.980.00150.05647.1668160mm2.4126.40021420592072.832069.65162.00B - 3'B - 4'44.830.00150.07744.4575160mm2.8236.19329784432069.652066.221TOTAL236152.40152.40TUBERIA152.40200mm3478.41M152.40160mm0.00MTOTAL3478.41M3,382.07