calculo-drenajes-pluviales

1
AREA AREA * COEFICIENTE SUMATORIA AREAS AREA EN HECTAREAS TECHOS PAVIMENTO AREA VERDE ADOQUINAMIENTO TECHOS PAVIMENTO AREA VERDE ADOQUINAMIENTO R-1 PV1 540.18 0.00 486.16 0.00 0.00 540.18 486.16 0.90 0.05 PV1 PV2 540.18 0.00 486.16 0.00 0.00 540.18 486.16 0.90 0.05 R2 PV2 257.27 0.00 0.00 0.00 218.68 257.27 218.68 0.85 0.03 R-3 PV2 656.51 11.98 282.37 222.59 623.68 10.78 70.59 189.20 1173.45 894.26 0.76 0.12 PV2 PV3 656.51 552.16 282.37 479.86 623.68 496.94 70.59 407.88 1970.90 1599.10 0.81 0.20 R-4 PV3 173.78 54.18 0.00 156.40 0.00 46.05 227.96 202.46 0.89 0.02 PV3 PV4 656.51 725.94 282.37 534.04 623.68 653.35 70.59 453.93 2198.86 1801.56 0.82 0.22 R-5 PV4 191.72 568.38 0.00 0.00 47.93 483.12 760.10 531.05 0.70 0.08 R-6 PV4 59.96 0.00 0.00 0.00 50.97 59.96 50.97 0.85 0.01 PV4 PV5 656.51 725.94 474.09 1162.38 623.68 653.35 118.52 988.02 3018.92 2383.58 0.79 0.30 R-7 PV5 447.05 48.93 130.65 0.00 402.35 12.23 111.05 626.63 525.63 0.84 0.06 R-8 PV5 566.64 24.80 152.84 0.00 509.98 6.20 129.91 744.28 646.09 0.87 0.07 PV5 PV6 656.51 1739.63 547.82 1445.87 623.68 1565.67 136.96 1228.99 4389.83 3555.30 0.81 0.44 R-9 PV6 566.64 24.81 152.84 0.00 509.98 6.20 129.91 744.29 646.09 0.87 0.07 R-10 PV6 362.50 176.93 78.17 344.38 0.00 44.23 66.44 617.60 455.05 0.74 0.06 PV6 RIO 1019.01 2306.27 749.56 1676.88 968.06 2075.64 187.39 1425.35 5751.72 4656.44 0.81 0.58 SUMATORIA AREAS * COEFICIENTE COEFICIENTE REDONDEADO

Upload: allan-h-nimatuj

Post on 05-Sep-2015

212 views

Category:

Documents


0 download

DESCRIPTION

Hoja electrónica para el calculo de drenajes pluviales

TRANSCRIPT

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