Movimiento de Tierras

14
0.00 0.00 229.57 10.00 0.00 229.27 20.00 0.00 229.21 0.00 10.00 229.40 10.00 10.00 229.37 20.00 10.00 229.33 24.00 10.00 229.14 0.00 20.00 229.53 10.00 20.00 229.45 20.00 20.00 229.42 27.70 20.00 229.34 0.00 30.00 229.59 10.00 30.00 229.58 20.00 30.00 229.50 30.00 30.00 229.29 33.80 30.00 229.38 0.00 40.00 229.66 10.00 40.00 229.56 20.00 40.00 229.54 30.00 40.00 229.52 36.50 40.00 229.41 0.00 50.00 229.69 10.00 50.00 229.64 20.00 50.00 229.63 30.00 50.00 229.50 40.00 50.00 229.48 0.00 60.00 229.75 10.00 60.00 229.72 20.00 60.00 229.69 30.00 60.00 229.61 40.00 60.00 229.55 0.00 70.00 229.86 10.00 70.00 229.81 20.00 70.00 229.75 30.00 70.00 229.74 40.00 70.00 229.61 43.00 70.00 229.54 0.00 80.00 229.87 10.00 80.00 229.86 20.00 80.00 229.78 30.00 80.00 229.76 40.00 80.00 229.80 47.00 80.00 229.62 0.00 90.00 229.94 10.00 90.00 229.91 20.00 90.00 229.85 30.00 90.00 229.83 40.00 90.00 229.89 50.00 90.00 229.72 54.70 90.00 229.65

description

Plantilla para nivelacion de tierras. Metodo de los minimos cuadrados

Transcript of Movimiento de Tierras

XYZ0.000.00229.5710.000.00229.2720.000.00229.210.0010.00229.4010.0010.00229.3720.0010.00229.3324.0010.00229.140.0020.00229.5310.0020.00229.4520.0020.00229.4227.7020.00229.340.0030.00229.5910.0030.00229.5820.0030.00229.5030.0030.00229.2933.8030.00229.380.0040.00229.6610.0040.00229.5620.0040.00229.5430.0040.00229.5236.5040.00229.410.0050.00229.6910.0050.00229.6420.0050.00229.6330.0050.00229.5040.0050.00229.480.0060.00229.7510.0060.00229.7220.0060.00229.6930.0060.00229.6140.0060.00229.550.0070.00229.8610.0070.00229.8120.0070.00229.7530.0070.00229.7440.0070.00229.6143.0070.00229.540.0080.00229.8710.0080.00229.8620.0080.00229.7830.0080.00229.7640.0080.00229.8047.0080.00229.620.0090.00229.9410.0090.00229.9120.0090.00229.8530.0090.00229.8340.0090.00229.8950.0090.00229.7254.7090.00229.650.00100.00229.9810.00100.00230.0020.00100.00229.9130.00100.00229.8440.00100.00229.8350.00100.00229.8359.00100.00229.740.00110.00230.1110.00110.00230.0820.00110.00229.9730.00110.00229.9740.00110.00229.8950.00110.00229.8960.00110.00229.800.00120.00230.1610.00120.00230.0420.00120.00230.0330.00120.00230.0440.00120.00229.9450.00120.00229.9660.00120.00229.8862.80120.00229.900.00130.00230.1910.00130.00230.1420.00130.00230.1330.00130.00230.0440.00130.00230.0450.00130.00230.1360.00130.00230.0365.30130.00229.810.00140.00230.3910.00140.00230.2220.00140.00230.1430.00140.00230.1540.00140.00230.1450.00140.00230.1460.00140.00230.1068.50140.00229.990.00150.00230.3510.00150.00230.2920.00150.00230.2630.00150.00230.2140.00150.00230.2050.00150.00230.2460.00150.00230.1770.00150.00230.0772.40150.00230.090.00160.00230.3710.00160.00230.3420.00160.00230.2630.00160.00230.2240.00160.00230.2050.00160.00230.2160.00160.00230.2168.50160.00230.1475.60160.00230.120.00170.00230.4210.00170.00230.32520.00170.00230.26730.00170.00230.25740.00170.00230.23550.00170.00230.1260.00170.00230.18568.50170.00230.2178.60170.00230.080.00180.00230.4910.00180.00230.4720.00180.00230.3630.00180.00230.3040.00180.00230.3250.00180.00230.2560.00180.00230.3168.50180.00230.2180.00180.00230.170.00190.00230.5310.00190.00230.5020.00190.00230.3930.00190.00230.3540.00190.00230.3750.00190.00230.3360.00190.00230.3068.50190.00230.3172.80190.00230.200.00200.00230.5610.00200.00230.5420.00200.00230.3930.00200.00230.4440.00200.00230.4350.00200.00230.3760.00200.00230.2868.50200.00230.2670.00200.00230.2084.00200.00230.250.00210.00230.5710.00210.00230.520.00210.00230.5130.00210.00230.4440.00210.00230.3650.00210.00230.3260.00210.00230.3270.00210.00230.2280.00210.00230.1982.35210.00230.310.00220.00230.6410.00220.00230.5420.00220.00230.530.00220.00230.4840.00220.00230.3850.00220.00230.4160.00220.00230.3670.00220.00230.3175.00220.00230.430.00230.00230.6810.00230.00230.6420.00230.00230.630.00230.00230.5140.00230.00230.4650.00230.00230.4560.00230.00230.463.50230.00230.460.00240.00230.7010.00240.00230.7220.00240.00230.6330.00240.00230.4940.00240.00230.4850.00240.00230.470.00250.00230.7910.00250.00230.6820.00250.00230.5930.00250.00230.5634.65250.00230.60.00260.00230.7810.00260.00230.7220.00260.00230.740.00268.00230.785.00268.00230.57

Principal0.005.0010.0020.0024.0027.7030.0033.8034.6536.5040.0043.0047.0050.0054.7059.0060.0062.8063.5065.3068.5070.0072.4072.8075.0075.6078.6080.0082.3584.00IndexBase SurfaceComparison SurfaceCut(Mcubo)Fill(Mcub)Net(Mcubo)Cut FactorFill FactorCut (adjusted)Fill (adjusted)Net (adjusted)Net Graph0.00229.57229.27229.210.00229.350.00Sx0.0047Zc230.10Plano Original1Terreno NaturalSuperficie Propuesta2393.73726.271667.46112393.73 Cu. M.726.27 Cu. M.1667.46 Cu. M.10.00229.40229.37229.33229.1410.00229.3140.00Sy0.0052Xc30.310.0020.00229.53229.45229.42229.3420.00229.4380.00D229.05Yc142.6330.00229.59229.58229.50229.29229.3830.00229.47150.00Pendiente Propuestas 140.00229.66229.56229.54229.52229.4140.00229.54200.00D229.21S1x0.00350.00229.69229.64229.63229.50229.4850.00229.59250.00S1y0.00260.00229.75229.72229.69229.61229.5560.00229.66300.00D229.7270.00229.86229.81229.75229.74229.61229.5470.00229.72420.00EcuacionZc=0.003*X+0.002*Y+229.6580.00229.87229.86229.78229.76229.80229.6280.00229.78480.00C/R (1)329.59%90.00229.94229.91229.85229.83229.89229.72229.6590.00229.83630.00Total estacas467.00100.00229.98230.00229.91229.84229.83229.83229.74100.00229.87700.00110.00230.11230.08229.97229.97229.89229.89229.80110.00229.96770.00Correccion120.00230.16230.04230.03230.04229.94229.96229.88229.90120.00229.99960.00FC7.67130.00230.19230.14230.13230.04230.04230.13230.03229.81130.00230.061040.00140.00230.39230.22230.14230.15230.14230.14230.10229.99140.00230.161120.00Propuesta 2150.00230.35230.29230.26230.21230.20230.24230.17230.07230.09150.00230.211350.00S1x0.023160.00230.37230.34230.26230.22230.20230.21230.21230.12160.00230.241280.00S1y0.015170.00230.42230.33230.27230.26230.24230.12230.19230.08170.00230.241360.00D227.21180.00230.49230.47230.36230.30230.32230.25230.31230.17180.00230.331440.00190.00230.53230.50230.39230.35230.37230.33230.30230.20190.00230.371520.00IndexBase SurfaceComparison SurfaceCutFillNetCut FactorFill FactorCut (adjusted)Fill (adjusted)Net (adjusted)Net Graph200.00230.56230.54230.39230.44230.43230.37230.28230.20230.25200.00230.381800.002.00Terreno OriginalTerrenoNivel28208.213863.054345.16 Cu. M.1.001.008208.213863.054345.16 Cu. M.210.00230.57230.5230.51230.44230.36230.32230.32230.22230.19230.31210.00230.372100.00212%220.00230.64230.54230.5230.48230.38230.41230.36230.31230.43220.00230.451980.00230.00230.68230.64230.6230.51230.46230.45230.4230.46230.00230.531840.00240.00230.70230.72230.63230.49230.48230.47240.00230.581440.00250.00230.79230.68230.59230.56230.6250.00230.641250.00260.00230.78230.72230.74260.00230.75780.00268.00230.78230.57268.00230.68536.000.005.0010.0020.0024.0027.7030.0033.8034.6536.5040.0043.0047.0050.0054.7059.0060.0062.8063.5065.3068.5070.0072.4072.8075.0075.6078.6080.0082.3584.00142.63230.19230.57230.11230.05229.14229.34230.07229.38230.60229.41230.08229.54229.62230.18229.65229.74230.18229.90230.46229.81229.99230.20230.09230.20230.43230.12230.08230.18230.31230.25n(total)181.000.005.00270.00540.0024.0027.70690.0033.8034.6536.50800.0043.0047.00800.0054.7059.00780.0062.8063.5065.3068.50280.0072.4072.8075.0075.6078.60160.0082.3584.0030.31