calculo-drenajes-pluviales

Hoja1COEFICIENTE DE ESCORRENTIATECHOS0.95INTENSIDAD DE LLUVIA24.3PAVIMENTO0.9AREA VERDE0.25ADOQUINAMIENTO ENLADRILLADO0.85

DEACOTASDISTANCIA HORIZONTAL (metros)(S) PENDIENTE DEL TERRENOCAUDAL (lt./seg)CAUDAL TRAMO (lt./seg)CAUDAL ACUMULADO (lt./seg)DIAMETRO TUBO (pulg.)S % TUBOVELOCIDAD LLENA (mt/seg)Q LLENO (lt./seg)q / Qv/Vd/DVD (mt/seg)COTAS INVERTAREAAREA * COEFICIENTESUMATORIA AREASSUMATORIA AREAS * COEFICIENTECOEFICIENTE REDONDEADOAREA EN HECTAREAS PVINICIALFINALSALIDAENTRADATECHOSPAVIMENTO AREA VERDEADOQUINAMIENTOTECHOSPAVIMENTOAREA VERDEADOQUINAMIENTORANGOd/Dv/VR-1PV194.594.527.130%3.283.283.28421.3611.000.300.880.3751.199392.46R-1PV1540.180.00486.160.000.00540.18486.160.900.050.010.050.29PV1PV294.59332.195%3.283.283.28621.7832.440.100.650.221.169392.36PV1PV2540.180.00486.160.000.00540.18486.160.900.050.020.090.39R-2PV294.19324.894%1.481.481.48421.3611.000.130.70.250.9592.692.10R2PV2257.270.000.000.00218.68257.27218.680.850.030.030.1180.45R-3PV293.19321.450%6.046.046.04421.3611.000.551.0250.531.3991.691.17R-3PV2656.5111.98282.37222.59623.6810.7870.59189.201173.45894.260.760.120.040.1390.49PV2PV39391.528.435%10.7910.7910.79621.7832.440.330.910.411.6291.590.93PV2PV3656.51552.16282.37479.86623.68496.9470.59407.881970.901599.100.810.200.050.160.54DR-4PV393.191.5218%1.371.371.37421.3611.000.120.680.240.9291.691.18R-4PV3173.7854.180.00156.400.0046.05227.96202.460.890.020.060.1750.57PV3PV491.59136.681%12.1612.1612.16621.7832.440.370.930.431.659089.27PV3PV4656.51725.94282.37534.04623.68653.3570.59453.932198.861801.560.820.220.070.190.6R-5PV493.19123.449%3.583.583.58421.3611.000.330.90.401.2291.691.13R-5PV4191.72568.380.000.0047.93483.12760.10531.050.700.080.080.2030.62R-6PV491.69132.472%0.340.340.34421.3611.000.030.450.120.6190.189.45R-6PV459.960.000.000.0050.9759.9650.970.850.010.090.2150.64PV4PV5918824.9512%16.0916.0916.09621.7832.440.5010.501.7889.589.00PV4PV5656.51725.94474.091162.38623.68653.35118.52988.023018.922383.580.790.300.10.220.65R-7PV588.68814.64%3.553.553.55421.3611.000.320.90.401.2287.186.81R-7PV5447.0548.93130.650.00402.3512.23111.05626.63525.630.840.060.110.230.67R-8PV588.68826.652%4.364.364.36421.3611.000.400.9450.441.2887.186.57R-8PV5566.6424.80152.840.00509.986.20129.91744.28646.090.870.070.120.240.68PV5PV68885.530.928%24.0024.0024621.7832.440.741.050.641.8786.585.88PV5PV6656.511739.63547.821445.87623.681565.67136.961228.994389.833555.300.810.440.130.250.7R-9PV687.185.59.2117%4.364.364.36421.3611.000.400.9450.441.2885.685.42R-9PV6566.6424.81152.840.00509.986.20129.91744.29646.090.870.070.140.260.71R-10PV687.185.525.086%3.073.073.07421.3611.000.280.860.361.1785.685.10R-10PV6362.50176.9378.17344.380.0044.2366.44617.60455.050.740.060.150.270.73PV6RIO85.584453%31.4331.4331.43621.7832.440.971.050.791.878483.10PV6RIO1019.012306.27749.561676.88968.062075.64187.391425.355751.724656.440.810.580.160.280.74ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.170.290.76ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.180.2950.77ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.190.30.78ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.20.310.79ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.210.320.8ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.220.3250.81ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.230.330.82ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.240.340.83ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.250.350.84ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.260.3550.85ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.270.360.86ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.280.370.87ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.290.3750.88ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.30.380.885ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.310.390.89ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.320.40.9ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.330.4050.91ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.340.410.915ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.350.4150.92ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.360.420.925ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.370.430.93ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.380.4350.94ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.390.440.945ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.40.4450.95ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.410.450.955ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.420.460.96ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.000.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!0.00000.000.000.000.000.000.00ERROR:#DIV/0!0.000.430.4650.9650.440.470.970.450.4750.980.460.480.9850.470.490.990.480.4950.9950.490.510.50.5051.050.510.511.010.520.5151.0150.530.521.020.540.531.0250.550.5351.030.560.541.0350.570.551.040.580.5551.050.590.560.60.5650.610.570.620.580.630.5850.640.590.650.5950.660.60.670.610.680.6150.690.620.70.6250.710.630.720.6350.730.640.740.6450.750.650.760.660.770.6650.780.670.790.6750.80.680.810.690.820.6950.830.70.840.7050.850.710.860.720.870.7250.880.730.890.740.90.7450.910.750.920.760.930.770.940.780.950.7850.960.790.970.80.980.810.990.8210.83

DRENAJE AGUA PLUVIAL

Hoja2

Hoja3