cÁlculo drenaje (autoguardado)

41
PROYECTO PARA CONSTRUCCIÓN DE REDES DE AGUA POTABLE Y ALCANTARILLADO PARA EL FRAC. AVIACIÓN, EN EL MUNICIPIO DE CHARCAS, S.L.P MUNICIPIO DE CHARCAS, S.L.P. No. De lotes 223.0 Habitantes 1003.5 n = 0.009 n = Hacinamiento 4.5 CVD 1.4 Diámetro = 0.25 m Diámetro = Dotación 230 lps CVH 1.55 Area tubo= 0.049 m2 Area tubo= Coef. de Aportación 75 % Coef.de Harmon 3.8 R = 0.0635 R = TRAMO Longitudes Gasto de Aguas Negras Funcionamiento Minimo Medio Máximo Tubo lleno 1 - 2 71 0 71 27 0.03 0.054 0.20 0.31 19.0 20.00 75.57 2.44 2 -3 71 71 142 59 0.06 0.117 0.44 0.67 47.0 20.00 118.85 3.83 3 - 4 72 142 214.00 86 0.09 0.171 0.65 0.97 17.0 20.00 71.48 2.31 5 - 4 76 0 76 32 0.03 0.063 0.24 0.36 4.0 20.00 34.67 1.12 4 - 13 52 290.00 342.00 117 0.12 0.234 0.89 1.33 79.0 20.00 154.09 4.97 5 - 6 76 0 76 32 0.03 0.063 0.24 0.36 11.0 20.00 57.50 1.85 6 - 7 78 76 154 63 0.06 0.126 0.48 0.72 14.0 20.00 64.87 2.09 7 - 8 75 154 229 86 0.09 0.171 0.65 0.97 18.0 20.00 73.55 2.37 8 - 17 66.65 229 295.65 117 0.12 0.234 0.89 1.33 21.0 20.00 79.45 2.56 9 - 10 71 0 71 54 0.05 0.108 0.41 0.61 20.0 20.00 77.53 2.50 10 - 11 71 71 142 117 0.12 0.234 0.89 1.33 44.0 20.00 115.00 3.71 11 - 12 48 142 190 153 0.15 0.305 1.16 1.74 78.0 20.00 153.11 4.94 12 - 13 24 190 214 171 0.17 0.341 1.30 1.95 17.0 20.00 71.48 2.31 CÁLCULO DE LA RED DE ALCANTARILLADO SANITARIO DEL FRAC, AVIACIÓN EN EL MUNICIPIO DE CHARCAS, S.L.P. Población servida (acumulada) Pendiente (milésimas) Diámetro cm Propia del tramo Tributari a en el crucero Acumulada para el tramo Máximo Extraor dinario Gasto l. p. s. Velocidad m/seg

Upload: alejandro

Post on 16-Dec-2015

8 views

Category:

Documents


0 download

DESCRIPTION

Memoria de calculo de drenaje

TRANSCRIPT

Hoja1

CLCULO DE LA RED DE ALCANTARILLADO SANITARIO DEL FRAC, AVIACIN EN EL MUNICIPIO DE CHARCAS, S.L.P.

No. De lotes223.0Habitantes1003.5n =0.009n =0.009Hacinamiento4.5CVD1.4Dimetro =0.25mDimetro =0.2Dotacin230lpsCVH1.55Area tubo=0.049m2Area tubo=0.031Coef. de Aportacin75%Coef.de Harmon3.8R =0.0635R =0.0635

TRAMOLongitudesPoblacin servida (acumulada)Gasto de Aguas NegrasPendiente (milsimas)Dimetro cmFuncionamiento HidralicoPropia del tramoTributaria en el cruceroAcumulada para el tramoMinimoMedioMximoMximo ExtraordinarioTubo lleno% de llenadoGasto l. p. s.Velocidad m/segMnimo %Mximo %

1 - 271071270.030.0540.200.3119.020.0075.572.440.040.4 2 -37171142590.060.1170.440.6747.020.00118.853.830.050.6 3 - 472142214.00860.090.1710.650.9717.020.0071.482.310.121.4

5 - 476076320.030.0630.240.364.020.0034.671.120.091.0 4 - 1352290.00342.001170.120.2340.891.3379.020.00154.094.970.080.9

5 - 676076320.030.0630.240.3611.020.0057.501.850.050.6 6 - 77876154630.060.1260.480.7214.020.0064.872.090.101.1 7 - 875154229860.090.1710.650.9718.020.0073.552.370.121.3 8 - 1766.65229295.651170.120.2340.891.3321.020.0079.452.560.151.7

9 - 1071071540.050.1080.410.6120.020.0077.532.500.070.8 10 - 1171711421170.120.2340.891.3344.020.00115.003.710.101.2 11 - 12481421901530.150.3051.161.7478.020.00153.114.940.101.1 12 - 13241902141710.170.3411.301.9517.020.0071.482.310.242.7

6 - 155205200.000.0000.000.0022.020.0081.322.620.000.0 15 - 147652128630.060.1260.480.727.020.0045.871.480.141.6 14 - 13761282041260.130.2520.961.4325.020.0086.682.800.151.7 13 - 21524184701260.130.2520.961.4354.020.00127.404.110.101.1

15 - 1638.78038.78140.010.0270.100.153.020.0030.030.970.040.5 16 - 1774.2538.78113.03450.040.0900.340.5131.020.0096.533.110.050.517 - E18.25408.68426.931620.160.3231.231.8427.020.0090.082.910.182.0

18 - 1971071630.060.1260.480.7211.020.0057.501.850.111.2 19 - 2071711421260.130.2520.961.4359.020.00133.174.300.091.1 20 - 21761422181800.180.3591.372.0560.020.00134.294.330.131.5

23 - 2267.87067.87500.050.0990.380.563.020.0030.030.970.161.922 - 2167.8767.87135.741040.100.2070.791.1831.020.0096.533.110.111.2 21 - 2752353.74405.742840.280.5662.153.2327.020.0090.082.910.313.6

1 - 95205200.000.0000.000.0024.020.0084.932.740.000.0 2 - 18525210400.000.0000.000.0042.020.00112.363.620.000.0 18 - 245210415600.000.0000.000.0050.020.00122.593.950.000.0 24 - 2571156227270.030.0540.200.3126.020.0088.402.850.030.3 25 - 2671227298590.060.1170.440.6765.020.00139.774.510.040.5

3 - 1152.0005200.000.0000.000.0022.020.0081.322.620.000.0 11 - 2052.005210400.000.0000.000.0051.020.00123.813.990.000.0 20 - 2652.0010415600.000.0000.000.0080.020.00155.065.000.000.0 26 - 2772.00454526860.090.1710.650.9722.020.0081.322.620.101.2

16 - 2375.72075.72320.030.0630.240.3625.020.0086.682.800.040.4 23 - 2875.7275.72151.44630.060.1260.480.7240.020.00109.653.540.060.7 28 - 2780.70151.44232.14320.030.0630.240.3680.020.00155.065.000.020.2 27 - 2967.561163.881231.443960.400.7913.004.5161.020.00135.404.370.293.3 29 - 3067.571231.441299.013960.400.7913.004.5132.020.0098.073.160.404.6 30 - 3167.601299.011366.613960.400.7913.004.5150.020.00122.593.950.323.7 31 -3264.601366.611431.213960.400.7913.004.5146.020.00117.583.790.343.8 32 - E23.601431.211454.813960.400.7913.004.514.020.0034.671.121.1413.0

PROYECTO PARA CONSTRUCCIN DE REDES DE AGUA POTABLE Y ALCANTARILLADO PARA EL FRAC. AVIACIN, EN EL MUNICIPIO DE CHARCAS, S.L.P

MUNICIPIO DE CHARCAS, S.L.P.

DRENAJE JEAN

CLCULO DE LA RED DE ALCANTARILLADO SANITARIO DEL FRAC, LOS LUCEROS EN EL MUNICIPIO DE MATEHUALA, S.L.P.

No. De lotes39.0Habitantes195n =0.009n =0.009Hacinamiento5.0CVD1.4Dimetro =0.25mDimetro =0.2Dotacin250lpsCVH1.55Area tubo=0.049m2Area tubo=0.031Coef. de Aportacin75%Coef.de Harmon3.8R =0.0635R =0.0635

TRAMOLongitudesPoblacin servida (acumulada)Gasto de Aguas NegrasPendiente (milsimas)Dimetro cmFuncionamiento HidralicoPropia del tramoTributaria en el cruceroAcumulada para el tramoMinimoMedioMximoMximo ExtraordinarioTubo lleno% de llenadoGasto l. p. s.Velocidad m/segMnimo %Mximo %

11--1265.3065.3250.030.0540.210.313.520.0032.431.050.081.012--169.8265.3135.12500.050.1090.410.623.520.0032.431.050.171.9

9--1070.56070.56250.030.0540.210.313.520.0032.431.050.081.010--1365.470.56135.96250.030.0540.210.313.520.0032.431.050.081.0

14--1371.13071.30500.050.1090.410.623.520.0032.431.050.171.9

13--261.81207.26269.07750.080.1630.620.933.520.0032.431.050.252.9

8--637.62037.62150.020.0330.120.193.520.0032.431.050.050.6

7--644.65044.65150.020.0330.120.193.520.0032.431.050.050.6

6--534.9482.27117.21350.040.0760.290.434.02034.671.120.111.25--461.1117.21178.31400.040.0870.330.494.020.0034.671.120.131.44--3109.5178.31287.81600.070.1300.490.743.520.0032.431.050.202.33--2104.43287.81392.24700.080.1520.580.873.520.0032.431.050.232.7

2--110.93796.43807.361450.160.3151.201.793.520.0032.431.050.495.51--E7807.36814.361950.210.4231.612.413.520.0032.431.050.657.4

DRENAJE OSCAR

CLCULO DE LA RED DE ALCANTARILLADO SANITARIO DEL FRAC, AVIACIN EN EL MUNICIPIO DE CHARCAS, S.L.P.

No. De lotes223.0Habitantes1003.5n =0.009n =0.009Hacinamiento4.5CVD1.4Dimetro =0.25mDimetro =0.2Dotacin230lpsCVH1.55Area tubo=0.049m2Area tubo=0.031Coef. de Aportacin75%Coef.de Harmon3.8R =0.0635R =0.0635

TRAMOLongitudesPoblacin servida (acumulada)Gasto de Aguas NegrasPendiente (milsimas)Dimetro cmFuncionamiento HidralicoPropia del tramoTributaria en el cruceroAcumulada para el tramoMinimoMedioMximoMximo ExtraordinarioTubo lleno% de llenadoGasto l. p. s.Velocidad m/segMnimo %Mximo %

15--1497.5097.5700.070.1400.530.8019.020.0075.572.440.091.114--123797.5134.5700.070.1400.530.8047.020.00118.853.830.060.7

13--1297.5097.501100.110.2200.831.2547.020.00118.853.830.091.1

12--535134.50169.501800.180.3591.372.0579.020.00154.094.970.121.3

11--1020020.00300.030.0600.230.3411.020.0057.501.850.050.610--92120.0041.00300.030.0600.230.3414.020.0064.872.090.050.59--82041.0061.00300.030.0600.230.3418.020.0073.552.370.040.58--717.561.0078.50300.030.0600.230.3421.020.0079.452.560.040.47--62078.5098.50300.030.0600.230.3421.020.0079.452.560.040.46--525.798.50124.20600.060.1200.460.6820.020.0077.532.500.080.9

5--335293.70328.702400.240.4791.822.7378.020.00153.114.940.161.8

4--397.5097.51100.110.2200.831.2517.020.0071.482.310.151.8

3--135426.20461.203500.350.6992.663.987.020.0045.871.480.768.7

2--197.50.0097.50700.070.1400.530.8054.020.00127.404.110.050.6

1--E4558.70562.704200.420.8393.194.783.020.0030.030.971.4015.9

DRENAJE JEFF-NER

CLCULO DE LA RED DE ALCANTARILLADO SANITARIO DEL FRAC, BERNAL EN EL MUNICIPIO DE MATEHUALA, S.L.P.

No. De lotes266.0Habitantes1330n =0.009n =0.009Hacinamiento5.0CVD1.4Dimetro =0.25mDimetro =0.2Dotacin250lpsCVH1.55Area tubo=0.049m2Area tubo=0.031Coef. de Aportacin75%Coef.de Harmon3.8R =0.0635R =0.0635

TRAMOLongitudesPoblacin servida (acumulada)Gasto de Aguas NegrasPendiente (milsimas)Dimetro cmFuncionamiento HidralicoPropia del tramoTributaria en el cruceroAcumulada para el tramoMinimoMedioMximoEdificiosMximo ExtraordinarioTubo lleno% de llenadoGasto l. p. s.Velocidad m/segMnimo %Mximo %

47--4656.2056.2550.060.1190.450.683.520.0032.431.050.182.146--4556.256.2112.4950.100.2060.781.183.520.0032.431.050.323.6 45--4456.2112.4168.601700.180.3691.402.103.520.0032.431.050.576.544--4350.15168.60218.752050.220.4451.691.644.183.520.0032.431.050.6912.943--4250.15218.75268.902550.280.5532.103.153.520.0032.431.050.859.742--4150.15268.90319.053300.360.7162.724.083.520.0032.431.051.1012.641--3950.15319.05369.203850.420.8363.170.134.893.520.0032.431.051.2915.1

40--3910.99010.99150.020.0330.120.193.520.0032.431.050.050.6

39--3858.77380.19438.964400.480.9553.635.443.520.0032.431.051.4716.8

21--2420.03020.03150.020.0330.120.193.520.0032.431.050.050.6

23--2453.95053.95350.040.0760.291.892.324.020.0034.671.120.116.7

24--2523.5173.9897.49650.070.1410.540.803.520.0032.431.050.222.525--2649.5997.49147.08950.100.2060.781.183.520.0032.431.050.323.6

28--2739.99039.99300.030.0650.250.373.520.0032.431.050.101.127--2639.9939.9979.98300.030.0650.250.373.520.0032.431.050.101.1

26--2940.2227.06267.261550.170.3361.281.923.520.0032.431.050.525.9

31--3054.66054.66450.050.0980.370.30.863.520.0032.431.050.152.630--2955.154.66109.76950.100.2060.781.183.520.0032.431.050.323.6

29--3240.02377.02417.042700.290.5862.233.343.520.0032.431.050.9010.3

33--3258.69058.69500.050.1090.411.612.233.520.0032.431.050.176.9

34--3240.68475.73516.413200.350.6942.643.963.520.0032.431.051.0712.2

35--3446.75046.75300.030.0650.250.220.593.520.0032.431.050.101.8

34--3640.03563.16603.193700.400.8033.054.583.520.0032.431.051.2414.1

37--3638.6038.6100.010.0220.080.123.520.0032.431.050.030.4

36--3819.32641.79661.113900.420.8463.224.823.520.0032.431.051.3014.9

38--4842.531100.071142.608400.911.8236.9310.393.520.0032.431.052.8132.0

12--1136.40036.4350.040.0760.290.433.520.0032.431.050.121.311--1036.436.472.8400.040.0870.330.130.623.520.0032.431.050.131.910--949.9172.8122.71800.090.1740.660.993.520.0032.431.050.273.19--849.72122.71172.431300.140.2821.071.613.520.0032.431.050.435.08--753.92172.43226.351550.170.3361.280.222.143.520.0032.431.050.526.67--653.92262.75316.672000.220.4341.652.473.520.0032.431.050.677.6

20--1922.00022150.020.0330.120.193.520.0032.431.050.050.6

18--1922.80022.80100.010.0220.080.123.520.0032.431.050.030.4

19--1640.7044.8085.50400.040.0870.330.493.520.0032.431.050.131.5

17--1655.69055.69450.050.0980.370.563.520.0032.431.050.151.720.0016--1539.99141.19181.181050.110.2280.871.303.520.0032.431.050.354.0

14--1567.05067.05550.060.1190.450.20.883.520.0032.431.050.182.70.0015--1339.87181.18221.051800.200.3911.482.233.520.0032.431.050.606.913--653.79221.05274.841950.210.4231.612.413.520.0032.431.050.657.4

6--442.32591.51633.833950.430.8573.264.893.520.0032.431.051.3215.1

48--48.631142.601151.238400.911.8236.9310.393.520.0032.431.052.8132.0

4--2128.851785.061913.919000.981.9537.4211.133.520.0032.431.053.0134.3

5--443.28043.28550.060.1190.450.683.520.0032.431.050.182.14--343.4243.2886.70700.080.1520.580.873.520.0032.431.050.232.73--243.1586.70129.85950.100.2060.781.183.520.0032.431.050.323.6

2--1109.322043.762153.089951.082.1598.2112.313.520.0032.431.053.3337.9

CALCULO DE ALTURAS JEFF-NERTRAMOCOTASLONGITUD DEL TRAMOPENDIENTE MINIMAPROFUNDIDAD COTAS DE PLANTILLAPENDIENTE (milesimas) ANCHURAAREAVOLUMEN EXCAVADOVOLUMEN ARENAVOLUMEN TUBOVOLUMEN RELLENOVOLUMEN TEPETATEVOLUMEN SOBRANTEINICIOFINALLONGITUD REALLONGITUD FINALINICIOFINALINICIOFINALAREA TUBOVOLUMEN 47--46107106.556.2550.00351.21.3925105.8105.10753.50.8546.7560.59968754.6750.0492.69525.35527.87468757.3746--45106.5106.256.2550.00351.39251.585105.1075104.6153.50.8546.7569.59906254.6750.0492.69528.0534.17906257.37 45--44106.2105.956.2550.00351.5851.7775104.615104.12253.50.8546.7578.59843754.6750.0492.69528.0543.17843757.3744--43105.9105.350.1548.950.00351.77751.948825104.1225103.3511753.50.8541.607577.52153371884.160750.0492.3985524.964545.99773371886.559343--42105.3104.950.1548.950.00351.9488252.12015103.351175102.779853.50.8541.607584.64993865624.160750.0492.3985524.964553.12613865626.559342--41104.9104.250.1548.950.00352.120152.291475102.77985101.9085253.50.8541.607591.77834359384.160750.0492.3985524.964560.25454359386.559341--39104.2103.950.1548.950.00352.2914752.4628101.908525101.43723.50.8541.607598.90674853124.160750.0492.3985524.964567.38294853126.5593

40--39103.6103.910.999.790.00351.21.234265102.4102.6657353.50.858.321510.12836809880.832150.0490.479714.99293.82360809881.31186

39--38103.9103.658.7757.570.00351.2342651.43576102.665735102.164243.50.8548.934565.32816918124.893450.0492.8209329.360728.25308918127.71438

21--24106.8106.420.0318.830.00351.21.265905105.6105.1340953.50.8516.005519.73402123881.600550.0490.922679.60337.60750123882.52322

23--24106.1106.453.9552.750.0041.21.411104.9104.98940.8544.837558.535356254.483750.0492.5847526.902524.564356257.0685

24--25106.410623.5122.310.00351.4111.489085104.989104.5109153.50.8518.963527.49788094881.896350.0491.0931911.378113.13024094882.9895425--26106105.949.5948.390.00351.4890851.65845104.510915104.241553.50.8541.131564.73141792624.113150.0492.3711124.678933.56825792626.48426

28--27106.7106.339.9938.790.00351.21.335765105.5104.9642353.50.8532.971541.80398784883.297150.0491.9007119.782916.82322784885.1978627--26106.3105.939.9938.790.00351.3357651.47153104.964235104.428473.50.8532.971546.28036354623.297150.0491.9007119.782921.29960354625.19786

26--29105.9105.440.2390.00351.658451.79495104.24155103.605053.50.8533.1557.2401053.3150.0491.91119.8932.1241055.226

31--30105.1104.954.6653.460.00351.21.38711103.9103.512893.50.8545.44158.7804327554.54410.0492.6195427.264624.3521927557.1636430--29104.9104.355.153.90.00351.387111.57576103.51289102.724243.50.8545.81567.8719445254.58150.0492.641127.48933.1603445257.2226

29--32105.4105.240.0238.820.00351.794951.93082103.60505103.269183.50.8532.99761.4696163453.29970.0491.9021819.798236.4695363455.20188

33--32105.5105.458.6957.490.00351.21.401215104.3103.9987853.50.8548.866563.55613639884.886650.0492.8170129.319926.53257639887.70366032--34105.5105.440.6839.480.00351.4012151.539395104.098785103.8606053.50.8533.55849.340495193.35580.0491.9345220.134823.915375195.29032

35--34104.9105.546.7545.550.00351.21.359425103.7104.1405753.50.8538.717549.54726871883.871750.0492.2319523.230520.21306871886.1037

34--36105.510540.0338.830.00351.3594251.49533104.140575103.504673.50.8533.005547.11130807623.300550.0491.9026719.803322.10478807625.20322

37--36105.310538.637.40.00351.21.3309104.1103.66913.50.8531.7940.22865553.1790.0491.832619.07416.14305555.0116

36--38105103.619.3218.120.00351.495331.55875103.50467102.041253.50.8515.40223.519470081.54020.0490.887889.241211.850190082.42808

38--48103.6103.142.5341.330.00351.435761.580415102.16424101.5195853.50.8535.130552.97986791883.513050.0492.0251721.078326.36334791885.53822

12--11105.8105.436.4035.20.00351.21.3232104.6104.07683.50.8529.9237.7470722.9920.0491.724817.95215.0782724.716811--10105.4105.236.435.20.00351.32321.4464104.0768103.75363.50.8529.9241.4332162.9920.0491.724817.95218.7644164.716810--9105.210549.9148.710.00351.44641.616885103.7536103.3831153.50.8541.403563.41536024884.140350.0492.3867924.842132.04612024886.527149--8105104.849.7248.520.00351.6168851.786705103.383115103.0132953.50.8541.24270.185429394.12420.0492.3774824.745238.938549396.501688--7104.8104.553.9252.720.00351.7867051.971225103.013295102.5287753.50.8544.81284.200179584.48120.0492.5832826.887250.248499587.064487--6104.5104.153.9252.720.00351.9712252.155745102.528775101.9442553.50.8544.81292.468889824.48120.0492.5832826.887258.517209827.06448

20--19105.6105.322.0020.80.00351.21.2728104.4104.02723.50.8517.6821.8595521.7680.0491.019210.6088.4643522.7872

18--19105104.922.8021.60.00351.21.2756103.8103.62443.50.8518.3622.7260081.8360.0491.058411.0168.8156082.8944

19--16104.9104.540.7039.50.00351.27281.41105103.6272103.088953.50.8533.57545.0551318753.35750.0491.935520.14519.6171318755.293

17--16104.7104.555.6954.490.00351.21.390715103.5103.1092853.50.8546.316559.99642564884.631650.0492.6700127.789924.90486564887.30166

16--15104.5104.339.9938.790.00351.411051.546815103.08895102.7531853.50.8532.971548.76262292383.297150.0491.9007119.782923.78186292385.19786

14--15104.6104.367.0565.850.00351.21.430475103.4102.8695253.50.8555.972573.61713096885.597250.0493.2266533.583531.20973096888.8239

15--13104.3104.339.8738.670.00351.5468151.68216102.753185102.617843.50.8532.869553.06739688123.286950.0491.8948319.721728.16391688125.1817813--6104.3104.153.7952.590.00351.682161.866225102.61784102.2337753.50.8544.701579.30906603884.470150.0492.5769126.820945.44110603887.04706

6--4104.1103.142.3241.120.00351.8662252.010145102.233775101.0898553.50.8534.95267.743442123.49520.0492.0148820.971241.262162125.51008

48--4103.1103.18.637.430.00351.5804151.60642101.519585101.493583.50.856.315510.06322822120.631550.0490.364073.78935.27830822120.99562

4--2103.1103128.85127.650.00351.606422.053195101.49358100.9468053.50.85108.5025198.538688268810.850250.0496.2548565.1015116.332088268817.1051

5--4105104.843.2842.080.00351.21.34728103.8103.452723.50.8535.76845.555555523.57680.0492.0619221.460818.456035525.638724--3104.8103.943.4242.220.00351.347281.49505103.45272102.404953.50.8535.88751.0013483553.58870.0492.0687821.532223.8116683555.657483--2103.910343.1541.950.00351.495051.641875102.40495101.3581253.50.8535.657555.92745159383.565750.0492.0555521.394528.91165159385.6213

2--1103102.7109.32108.120.00352.0531952.431615100.946805100.2683853.50.8591.902206.081504319.19020.0495.2978855.1412136.4522243114.48808TOTAL:2127.332896.09331731180.823051082.24331528.78779731285.06222

CALCULO DE ALTURAS JEANTRAMOCOTASLONGITUD DEL TRAMOPENDIENTE MINIMAPROFUNDIDAD COTAS DE PLANTILLAPENDIENTE (milesimas) ANCHURAAREAVOLUMEN EXCAVADOVOLUMEN ARENAVOLUMEN TUBOVOLUMEN RELLENOVOLUMEN TEPETATEVOLUMEN SOBRANTEINICIOFINALLONGITUD REALLONGITUD FINALINICIOFINALINICIOFINALAREA TUBOVOLUMEN11--1210410365.364.10.00351.21.42435102.8101.575653.50.8554.48571.4938548755.44850.0493.140929.550133.3543548758.589412--110310069.8268.620.00351.424351.66452101.5756598.335483.50.8558.32790.0822602455.83270.0493.3623834.996245.8909802459.19508

9--1010510470.5669.360.00351.21.44276103.8102.557243.50.8558.95677.903279285.89560.0493.3986435.373633.235439289.2942410--1310410365.464.20.00351.442761.66746102.55724101.332543.50.8554.5784.86235275.4570.0493.145832.74243.51755278.6028

14--1310410371.1369.930.00351.21.444755102.8101.5552453.50.8559.440578.60277978885.944050.0493.4265735.664333.56785978889.37062

13--210310061.8160.610.00351.667461.879595101.3325498.1204053.50.8551.518591.36947650885.151850.0492.9698930.911152.33663650888.12174

8--6105105.537.6236.420.00351.21.32747103.8104.172533.50.8530.95739.1214443953.09570.0491.7845818.574215.6669643954.88028

7--6104105.544.6543.450.00351.21.352075102.8104.1479253.50.8536.932547.12725496883.693250.0492.1290522.159519.14545496885.8223

6--5105.510434.9433.740.0041.327471.46243104.17253102.5375740.8528.67940.005771052.86790.0491.6532617.207418.277211054.521165--410410261.159.90.0041.462431.70203102.53757100.2979744--3102101109.5108.30.00351.702032.08108100.2979798.918923.50.8592.055174.1270955259.20550.0495.306755.233104.38189552514.51223--2101100104.43103.230.00352.081082.44238598.9189297.5576153.50.8587.7455198.45684907888.774550.0495.0582752.6473131.976729078813.83282

2--110010010098.80.00352.4423852.78818597.55761597.2118153.50.8583.98219.63163438.3980.0494.841250.388156.004434313.23921--E10010010098.80.00352.7881853.13398597.21181596.8660153.50.8583.98248.67191838.3980.0494.841250.388185.044718313.2392979.461461.45597101578.1626465.8347872.400231015123.22104

CALCULO DE ALTURA OSCARTRAMOCOTASLONGITUD DEL TRAMOPENDIENTE MINIMAPROFUNDIDAD COTAS DE PLANTILLAPENDIENTE (milesimas) ANCHURAAREAVOLUMEN EXCAVADOVOLUMEN ARENAVOLUMEN TUBOVOLUMEN RELLENOVOLUMEN TEPETATEVOLUMEN SOBRANTEINICIOFINALLONGITUD REALLONGITUD FINALINICIOFINALINICIOFINALAREA TUBOVOLUMEN15--1410410397.596.30.00351.21.53705102.8101.462953.50.8581.855112.0206138758.18550.0494.718744.394354.72211387512.904214--121031003735.80.00351.537051.66235101.4629598.337653.50.8530.4348.6788713.0430.0491.754218.25825.6236714.7972

13--1210510497.596.30.00351.21.53705103.8102.462953.50.8581.855112.0206138758.18550.0494.718749.11350.00341387512.90421041030.00351.537051.53705102.46295101.46295ERROR:#DIV/0!0.850000.049000012--53533.81041030.00351.21.2102.8101.8ERROR:#DIV/0!0.850000.049000011--102018.810--91031002119.80.00351.537051.60635101.4629598.393653.50.8516.8326.4517111.6830.0490.970210.09813.7005112.65329--82018.88--7105105.517.516.30.00351.21.25705103.8104.242953.50.8513.85517.0212138751.38550.0490.79878.3136.5240138752.18427--62018.86--5104105.525.724.50.00351.21.28575102.8104.214253.50.8520.82525.8828718752.08250.0491.200512.49510.1048718753.283

5--3105.51043533.80.0041.257051.39225104.24295102.6077540.8528.7338.05719452.8730.0491.656217.23816.28999454.52921041020.0041.392251.39225102.60775100.60775ERROR:#DIV/0!4--310210197.596.30.00351.392251.7293100.6077599.27073.50.8581.855127.7572376258.18550.0494.718749.11365.74003762512.90421011000.00351.72931.729399.270798.2707ERROR:#DIV/0!0.850000.04900003--13533.81001000.00351.72931.729398.270798.2707ERROR:#DIV/0!0.850000.04900002--110010097.596.30.00351.72932.0663598.270797.933653.50.8581.855155.3464653758.18550.0494.718749.11393.32926537512.9042663.23679343.809258.1353336.03789369.06361--E42.8