hoja de cálculo de nivelación

3
PUNTOS IDA Vista atrás vista adelante A-B 1.539 1.129 0.41 B-C 1.61 1.218 0.392 C-D 1.611 1.197 0.414 D-E 1.794 1.378 0.416 E-F 1.785 1.382 0.403 F-G 1.842 1.399 0.443 G-H 1.646 1.278 0.368 H-I 1.65 1.225 0.425 I-J 1.579 1.149 0.43 J-K 0 K-L 0 L-M 0 M-N 0 PUNTOS DISTANCIA V.ATRÁS H V.ADELANTE COTA A 0 1.539 100.000 B 20 1.610 101.539 1.129 100.410 C 20 1.611 102.020 1.218 100.802 D 20 1.794 102.413 1.197 101.216 E 20 1.785 103.010 1.378 101.632 F 20 1.842 103.417 1.382 102.035 G 20 1.646 103.877 1.399 102.478 H 20 1.650 104.124 1.278 102.846 I 20 1.579 104.496 1.225 103.271 J 20 1.149 104.850 1.149 103.701 I 20 1.243 104.850 1.580 103.270 H 20 1.285 104.513 1.671 102.842 G 20 1.410 104.127 1.655 102.472 F 20 1.440 103.882 1.856 102.026 E 20 1.389 103.466 1.840 101.626 D 20 1.274 103.015 1.801 101.214 C 20 1.223 102.488 1.691 100.797 B 20 1.153 102.020 1.613 100.407 A 20 101.560 1.561 99.999 suma 360 26.622 26.623 0.001 0.001

Upload: jorgemanuelsilva

Post on 01-Oct-2015

7 views

Category:

Documents


2 download

DESCRIPTION

Hoja de excel para nivelación topografica

TRANSCRIPT

Hoja1PUNTOSIDAVueltaVista atrsvista adelantevista atrs vista adelanteERROR0.0240.048A-B1.5391.1290.411.1531.5610.4080.0020.0000040.002B-C1.611.2180.3921.2231.6130.390.0020.0000040.002C-D1.6111.1970.4141.2741.6910.417-0.0030.0000090.003D-E1.7941.3780.4161.3891.8010.4120.0040.0000160.004E-F1.7851.3820.4031.441.8400.40.0030.0000090.003F-G1.8421.3990.4431.411.8560.446-0.0030.0000090.003G-H1.6461.2780.3681.2851.6550.37-0.0020.0000040.002H-I1.651.2250.4251.2431.6710.428-0.0030.0000090.003I-J1.5791.1490.431.1491.580.431-0.0010.0000010.001J-K00000K-L00000L-M00000M-N000000.023Suma de erroresPUNTOS DISTANCIA V.ATRS HV.ADELANTECOTAD. ACUMULADACOMPENSACIN COTA COMPENSADA A01.539100.00000.00000100.00000B201.610101.5391.129100.410200.00006100.41006C201.611102.0201.218100.802400.00011100.80211D201.794102.4131.197101.216600.00017101.21617E201.785103.0101.378101.632800.00022101.63222F201.842103.4171.382102.0351000.00028102.03528G201.646103.8771.399102.4781200.00033102.47833H201.650104.1241.278102.8461400.00039102.84639I201.579104.4961.225103.2711600.00044103.27144J201.149104.8501.149103.7011800.00050103.70150I201.243104.8501.580103.2702000.00056103.27056H201.285104.5131.671102.8422200.00061102.84261G201.410104.1271.655102.4722400.00067102.47267F201.440103.8821.856102.0262600.00072102.02672E201.389103.4661.840101.6262800.00078101.62678D201.274103.0151.801101.2143000.00083101.21483C201.223102.4881.691100.7973200.00089100.79789B201.153102.0201.613100.4073400.00094100.40794A20101.5601.56199.9993600.00100100.00000suma36026.62226.6230.0010.001