Calculo Nivelacion Geometrica
Calculo Nivelacion Geometrica
Calculo Nivelacion Geometrica
1
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
4 BM-1+000 1.3730 3575.2933 -0.0001 BM-1+000 1.3731 3575.2933
1 3.1050 0.2950 3576.3713 -0.0001 1 3.1051 0.2949 3576.3716
2 P-02 0.7870 0.7870 3578.6893 -0.0001 2 P-02 0.7871 0.7869 3578.6898
3 0.3680 3.1790 3576.2973 -0.0001 3 0.3681 3.1789 3576.2981
4 BM-1+000 1.3730 3575.2923 -0.0001 4 BM-1+000 1.3729 3575.2933
CALC. EXCEL 5.6330 5.6340 -0.0010 -0.0010 CALC. EXCEL 5.6335 5.6335 0.0000
CALC. LIBRETA 5.6330 5.6340 -0.0010 -0.0006 CALC. LIBRETA 5.6335 5.6335 0.0000
2
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
9 P-05 0.4300 3587.5243 0.0002 P-05 0.4298 3587.5243
1 0.3220 4.0050 3583.9493 0.0002 1 0.3218 4.0052 3583.9489
2 0.2310 4.4000 3579.8713 0.0002 2 0.2308 4.4002 3579.8705
3 0.3330 4.8930 3575.2093 0.0002 3 0.3328 4.8932 3575.2081
4 0.7190 4.7200 3570.8223 0.0002 4 0.7188 4.7202 3570.8207
5 BM-2+000 2.8240 2.8240 3568.7173 0.0002 5 BM-2+000 2.8238 2.8242 3568.7153
6 4.7280 0.7250 3570.8163 0.0002 6 4.7278 0.7252 3570.8139
7 4.9690 0.4090 3575.1353 0.0002 7 4.9688 0.4092 3575.1325
8 4.2390 0.0700 3580.0343 0.0002 8 4.2388 0.0702 3580.0311
9 4.2920 0.6070 3583.6663 0.0002 9 4.2918 0.6072 3583.6627
10 P-05 0.4300 3587.5283 0.0002 10 P-05 0.4302 3587.5243
CALC. EXCEL 23.0870 23.0830 0.0040 0.0040 CALC. EXCEL 23.0850 23.0850 0.0000
CALC. LIBRETA 23.0870 23.0830 0.0040 0.0022 CALC. LIBRETA 23.0850 23.0850 0.0000
3
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
12 P-06 4.7640 3606.9743 0.0001 P-06 4.7639 3606.9743
1 4.9300 0.5000 3611.2383 0.0001 1 4.9299 0.5001 3611.2381
2 1.9990 0.6700 3615.4983 0.0001 2 1.9989 0.6701 3615.4980
3 P-07 1.2540 1.2540 3616.2433 0.0001 3 P-07 1.2539 1.2541 3616.2428
4 0.6010 1.9300 3615.5673 0.0001 4 0.6009 1.9301 3615.5666
5 0.4960 4.9250 3611.2433 0.0001 5 0.4959 4.9251 3611.2425
6 P-06 4.7640 3606.9753 0.0001 6 P-06 4.7641 3606.9743
CALC. EXCEL 14.0440 14.0430 0.0010 0.0010 CALC. EXCEL 14.0435 14.0435 0.0000
CALC. LIBRETA 14.0440 14.0430 0.0010 0.0006 CALC. LIBRETA 14.0435 14.0435 0.0000
4
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
16 BM-4+000 1.7620 3632.6078 0.0001 BM-4+000 1.7619 3632.6078
1 1.4810 1.9590 3632.4108 0.0001 1 1.4809 1.9591 3632.4107
2 3.9510 3.7770 3630.1148 0.0001 2 3.9509 3.7771 3630.1146
3 4.3570 0.1350 3633.9308 0.0001 3 4.3570 0.1351 3633.9305
4 3.3550 0.0850 3638.2028 0.0001 4 3.3549 0.0851 3638.2024
5 BM-4+500 1.1490 1.1490 3640.4088 0.0001 5 BM-4+500 1.1489 1.1491 3640.4083
6 0.1570 3.4270 3638.1308 0.0001 6 0.1569 3.4271 3638.1302
7 0.0970 4.3190 3633.9688 0.0001 7 0.0969 4.3191 3633.9681
8 3.7480 3.9220 3630.1438 0.0001 8 3.7480 3.9221 3630.1430
9 2.0600 1.5810 3632.3108 0.0001 9 2.0599 1.5811 3632.3099
10 BM-4+000 1.7620 3632.6088 0.0001 10 BM-4+000 1.7621 3632.6078
CALC. EXCEL 22.1170 22.1160 0.0010 0.0010 CALC. EXCEL 22.1165 22.1165 0.0000
CALC. LIBRETA 22.1170 22.1160 0.0010 0.0006 CALC. LIBRETA 22.1165 22.1165 0.0000
5
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
20 PB-01 BM 5+500 0.6180 3637.7628 -0.0001 PB-01 BM 5+500 0.6181 3637.7628
1 1.1320 4.7580 3633.6228 -0.0001 1 1.1321 4.7579 3633.6231
2 4.8060 0.3390 3634.4158 -0.0001 2 4.8061 0.3389 3634.4163
3 4.3650 0.1590 3639.0628 -0.0001 3 4.3651 0.1589 3639.0636
4 AZ-01 BM 6+000 1.8050 1.8050 3641.6228 -0.0001 4 AZ-01 BM 6+000 1.8051 1.8049 3641.6238
5 0.1920 4.4000 3639.0278 -0.0001 5 0.1921 4.3999 3639.0291
6 0.2250 4.6930 3634.5268 -0.0001 6 0.2251 4.6929 3634.5283
7 4.9670 1.3400 3633.4118 -0.0001 7 4.9671 1.3399 3633.4136
8 PB-01 BM 5+500 0.6180 3637.7608 -0.0001 8 PB-01 BM 5+500 0.6179 3637.7628
CALC. EXCEL 18.1100 18.1120 -0.0020 -0.0020 CALC. EXCEL 18.1110 18.1110 0.0000
CALC. LIBRETA 18.1100 18.1120 -0.0020 -0.0011 CALC. LIBRETA 18.1110 18.1110 0.0000
6
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
24 BM-7+500 0.7050 3668.6718 0.0000 BM-7+500 0.7050 3668.6718
1 4.7320 0.4050 3668.9718 0.0000 1 4.7321 0.4050 3668.9719
2 3.7090 0.2550 3673.4488 0.0000 2 3.7091 0.2550 3673.4490
3 4.4890 0.6790 3676.4788 0.0000 3 4.4891 0.6790 3676.4791
4 4.1790 0.2220 3680.7458 0.0000 4 4.1791 0.2220 3680.7462
5 P-09 3.0680 3.0680 3681.8568 0.0000 5 P-09 3.0681 3.0680 3681.8573
6 0.3770 4.3340 3680.5908 0.0000 6 0.3770 4.3340 3680.5914
7 0.6800 4.4900 3676.4778 0.0000 7 0.6800 4.4900 3676.4785
8 0.2250 3.6790 3673.4788 0.0000 8 0.2250 3.6790 3673.4796
9 0.2200 4.5480 3669.1558 0.0000 9 0.2200 4.5480 3669.1567
10 BM-7+500 0.7050 3668.6708 0.0000 10 BM-7+500 0.7050 3668.6718
CALC. EXCEL 22.3840 22.3850 -0.0010 -0.0010 CALC. EXCEL 22.3845 22.3845 0.0000
CALC. LIBRETA 22.3840 22.3850 -0.0010 -0.0005 CALC. LIBRETA 22.3845 22.3845 0.0000
7
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
28 P-10 3.1050 3736.7743 -0.0002 P-10 3.1052 3736.7743
1 4.9680 0.0360 3739.8433 -0.0002 1 4.9682 0.0358 3739.8437
2 4.4030 0.1150 3744.6963 -0.0002 2 4.4032 0.1148 3744.6971
3 4.0640 0.2400 3748.8593 -0.0002 3 4.0642 0.2398 3748.8604
4 BM-9+000 3.7490 3.7490 3749.1743 -0.0002 4 BM-9+000 3.7492 3.7488 3749.1758
5 0.1160 3.9410 3748.9823 -0.0002 5 0.1162 3.9408 3748.9842
6 0.0380 4.3280 3744.7703 -0.0002 6 0.0382 4.3278 3744.7726
7 0.0300 4.9620 3739.8463 -0.0002 7 0.0302 4.9618 3739.8489
8 P-10 3.1050 3736.7713 -0.0002 8 P-10 3.1048 3736.7743
CALC. EXCEL 20.4730 20.4760 -0.0030 -0.0030 CALC. EXCEL 20.4745 20.4745 0.0000
CALC. LIBRETA 20.4730 20.4760 -0.0030 -0.0017 CALC. LIBRETA 20.4745 20.4745 0.0000
8
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
32 P-11 3.6210 3798.8028 -0.0002 P-11 3.6212 3798.8028
1 4.1420 0.1780 3802.2458 -0.0002 1 4.1422 0.1778 3802.2462
2 3.8610 0.2230 3806.1648 -0.0002 2 3.8612 0.2228 3806.1656
3 3.2870 0.6270 3809.3988 -0.0002 3 3.2872 0.6268 3809.3999
4 P-12 0.5810 0.5810 3812.1048 -0.0002 4 P-12 0.5812 0.5808 3812.1063
5 0.5360 3.1960 3809.4898 -0.0002 5 0.5362 3.1958 3809.4917
6 0.1370 3.7770 3806.2488 -0.0002 6 0.1372 3.7768 3806.2511
7 0.2240 4.1890 3802.1968 -0.0002 7 0.2242 4.1888 3802.1994
8 P-11 3.6210 3798.7998 -0.0002 8 P-11 3.6208 3798.8028
CALC. EXCEL 16.3890 16.3920 -0.0030 -0.0030 CALC. EXCEL 16.3905 16.3905 0.0000
CALC. LIBRETA 16.3890 16.3920 -0.0030 -0.0017 CALC. LIBRETA 16.3905 16.3905 0.0000
9
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
35 PB-02 BM 11+000 3.4440 3829.4298 -0.0001 PB-02 BM 11+000 3.4441 3829.4298
1 4.7860 1.3410 3831.5328 -0.0001 1 4.7861 1.3409 3831.5330
2 4.8830 0.1250 3836.1938 -0.0001 2 4.8831 0.1249 3836.1942
3 4.8020 0.3290 3840.7478 -0.0001 3 4.8021 0.3289 3840.7484
4 4.8100 0.1760 3845.3738 -0.0001 4 4.8101 0.1759 3845.3746
5 4.9490 0.2400 3849.9438 -0.0001 5 4.9491 0.2399 3849.9448
6 4.9900 0.1800 3854.7128 -0.0001 6 4.9901 0.1799 3854.7140
7 4.8100 0.2250 3859.4778 -0.0001 7 4.8101 0.2249 3859.4792
8 1.2530 0.3520 3863.9358 -0.0001 8 1.2531 0.3519 3863.9374
9 1.6170 0.8320 3864.3568 -0.0001 9 1.6171 0.8319 3864.3586
10 AZ-02 BM 11+500 0.7540 0.7540 3865.2198 -0.0001 10 AZ-02 BM 11+500 0.7541 0.7539 3865.2218
11 1.3020 2.0870 3863.8868 -0.0001 11 1.3021 2.0869 3863.8890
12 0.5130 1.4140 3863.7748 -0.0001 12 0.5131 1.4139 3863.7772
13 0.3610 4.9470 3859.3408 -0.0001 13 0.3611 4.9469 3859.3434
14 0.1370 4.9490 3854.7528 -0.0001 14 0.1371 4.9489 3854.7556
15 0.1460 4.8550 3850.0348 -0.0001 15 0.1461 4.8549 3850.0378
16 0.1780 4.8120 3845.3688 -0.0001 16 0.1781 4.8119 3845.3720
17 0.3090 4.7820 3840.7648 -0.0001 17 0.3091 4.7819 3840.7682
18 0.0160 4.7750 3836.2988 -0.0001 18 0.0161 4.7749 3836.3024
19 1.2280 4.6730 3831.6418 -0.0001 19 1.2281 4.6729 3831.6456
20 PB-02 BM 11+000 3.4440 3829.4258 -0.0001 20 PB-02 BM 11+000 3.4439 3829.4298
CALC. EXCEL 45.2880 45.2920 -0.0040 -0.0040 CALC. EXCEL 45.2900 45.2900 0.0000
CALC. LIBRETA 45.2880 45.2920 -0.0040 -0.0021 CALC. LIBRETA 45.2900 45.2900 0.0000
10
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
38 BM-12+000 2.5230 3879.4228 0.0002 BM-12+000 2.5228 3879.4228
1 0.7460 4.6190 3877.3268 0.0002 1 0.7458 4.6192 3877.3264
2 0.6730 4.7120 3873.3608 0.0002 2 0.6728 4.7122 3873.3599
3 0.4120 4.7350 3869.2988 0.0002 3 0.4118 4.7352 3869.2975
4 1.4180 2.7120 3866.9988 0.0002 4 1.4178 2.7122 3866.9971
5 0.7770 3.9480 3864.4688 0.0002 5 0.7768 3.9482 3864.4667
6 1.9410 4.7900 3860.4558 0.0002 6 1.9408 4.7902 3860.4532
7 BM-12+500 0.8850 0.8850 3861.5118 0.0002 7 BM-12+500 0.8848 0.8852 3861.5088
8 4.7690 1.9190 3860.4778 0.0002 8 4.7688 1.9192 3860.4744
9 3.9050 0.7350 3864.5118 0.0002 9 3.9048 0.7352 3864.5079
10 2.5590 1.2610 3867.1558 0.0002 10 2.5588 1.2612 3867.1515
11 4.4620 0.1390 3869.5758 0.0002 11 4.4618 0.1392 3869.5711
12 4.5750 0.5350 3873.5028 0.0002 12 4.5748 0.5352 3873.4977
13 4.7290 0.8550 3877.2228 0.0002 13 4.7288 0.8552 3877.2172
14 BM-12+000 2.5230 3879.4288 0.0002 14 BM-12+000 2.5232 3879.4228
CALC. EXCEL 34.3740 34.3680 0.0060 0.0060 CALC. EXCEL 34.3710 34.3710 0.0000
CALC. LIBRETA 34.3740 34.3680 0.0060 0.0032 CALC. LIBRETA 34.3710 34.3710 0.0000
11
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
42 BM-13+500 0.8850 3833.0188 0.0001 BM-13+500 0.8849 3833.0188
1 2.2890 4.3640 3829.5398 0.0001 1 2.2890 4.3641 3829.5397
2 0.8670 4.8980 3826.9308 0.0001 2 0.8669 4.8981 3826.9306
3 0.1610 4.8550 3822.9428 0.0001 3 0.1609 4.8551 3822.9425
4 1.5710 4.0140 3819.0898 0.0001 4 1.5709 4.0141 3819.0894
5 BM-14+000 0.3460 0.3460 3820.3148 0.0001 5 BM-14+000 0.3459 0.3461 3820.3143
6 3.9340 1.4910 3819.1698 0.0001 6 3.9340 1.4911 3819.1692
7 4.7600 0.0660 3823.0378 0.0001 7 4.7600 0.0661 3823.0371
8 4.9000 0.8680 3826.9298 0.0001 8 4.9000 0.8681 3826.9290
9 4.3240 2.2490 3829.5808 0.0001 9 4.3240 2.2491 3829.5799
10 BM-13+500 0.8850 3833.0198 0.0001 10 BM-13+500 0.8851 3833.0188
CALC. EXCEL 24.0370 24.0360 0.0010 0.0010 CALC. EXCEL 24.0365 24.0365 0.0000
CALC. LIBRETA 24.0370 24.0360 0.0010 0.0006 CALC. LIBRETA 24.0365 24.0365 0.0000
12
CALC. EXCEL 12.6660 12.6670 -0.0010 -0.0010 CALC. EXCEL 12.6665 12.6665 0.0000
CALC. LIBRETA 12.6660 12.6670 -0.0010 -0.0006 CALC. LIBRETA 12.6665 12.6665 0.0000
13
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
47 P-16 1.3200 3798.4108 0.0001 P-16 1.3199 3798.4108
1 1.1480 2.7220 3797.0088 0.0001 1 1.1479 2.7221 3797.0086
2 BM-15+500 1.3730 1.3730 3796.7838 0.0001 2 BM-15+500 1.3729 1.3731 3796.7833
3 2.7020 1.1270 3797.0298 0.0001 3 2.7019 1.1271 3797.0291
4 P-16 1.3200 3798.4118 0.0001 4 P-16 1.3201 3798.4108
CALC. EXCEL 6.5430 6.5420 0.0010 0.0010 CALC. EXCEL 6.5425 6.5425 0.0000
CALC. LIBRETA 6.5430 6.5420 0.0010 0.0006 CALC. LIBRETA 6.5425 6.5425 0.0000
14
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
51 AZ-03 BM 17+000 1.0590 3815.6378 -0.0002 AZ-03 BM 17+000 1.0592 3815.6378
1 3.5850 3.4020 3813.2948 -0.0002 1 3.5852 3.4018 3813.2952
2 4.9450 0.3580 3816.5218 -0.0002 2 4.9452 0.3578 3816.5226
3 4.7590 0.2600 3821.2068 -0.0002 3 4.7592 0.2598 3821.2080
4 4.1560 0.6510 3825.3148 -0.0002 4 4.1562 0.6508 3825.3164
5 P-17 2.8240 2.8240 3826.6468 -0.0002 5 P-17 2.8242 2.8238 3826.6488
6 0.5870 4.0930 3825.3778 -0.0002 6 0.5872 4.0928 3825.3802
7 0.0910 4.5900 3821.3748 -0.0002 7 0.0912 4.5898 3821.3776
8 0.2110 4.8000 3816.6658 -0.0002 8 0.2112 4.7998 3816.6690
9 3.2150 3.3990 3813.4778 -0.0002 9 3.2152 3.3988 3813.4814
10 AZ-03 BM 17+000 1.0590 3815.6338 -0.0002 10 AZ-03 BM 17+000 1.0588 3815.6378
CALC. EXCEL 25.4320 25.4360 -0.0040 -0.0040 CALC. EXCEL 25.4340 25.4340 0.0000
CALC. LIBRETA 25.4320 25.4360 -0.0040 -0.0022 CALC. LIBRETA 25.4340 25.4340 0.0000
15
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
54 BM-18+000 2.6260 3868.1268 -0.0001 BM-18+000 2.6261 3868.1268
1 4.6550 0.3180 3870.4348 -0.0001 1 4.6551 0.3179 3870.4351
2 4.8390 0.0440 3875.0458 -0.0001 2 4.8391 0.0439 3875.0463
3 4.6670 0.0980 3879.7868 -0.0001 3 4.6671 0.0979 3879.7876
4 4.8350 0.0780 3884.3758 -0.0001 4 4.8351 0.0779 3884.3768
5 4.9800 0.1070 3889.1038 -0.0001 5 4.9801 0.1069 3889.1051
6 4.1330 0.1240 3893.9598 -0.0001 6 4.1331 0.1239 3893.9613
7 2.1620 0.1590 3897.9338 -0.0001 7 2.1621 0.1589 3897.9356
8 BM-18+500 2.3960 2.3960 3897.6998 -0.0001 8 BM-18+500 2.3961 2.3959 3897.7018
9 0.2060 2.2090 3897.8868 -0.0001 9 0.2061 2.2089 3897.8891
10 0.1050 4.1150 3893.9778 -0.0001 10 0.1051 4.1149 3893.9803
11 0.0480 4.9210 3889.1618 -0.0001 11 0.0481 4.9209 3889.1646
12 0.0910 4.8490 3884.3608 -0.0001 12 0.0911 4.8489 3884.3638
13 0.0340 4.6040 3879.8478 -0.0001 13 0.0341 4.6039 3879.8511
14 0.0840 4.8790 3875.0028 -0.0001 14 0.0841 4.8789 3875.0063
15 0.2780 4.6160 3870.4708 -0.0001 15 0.2781 4.6159 3870.4746
16 BM-18+000 2.6260 3868.1228 -0.0001 16 BM-18+000 2.6259 3868.1268
CALC. EXCEL 36.1390 36.1430 -0.0040 -0.0040 CALC. EXCEL 36.1410 36.1410 0.0000
CALC. LIBRETA 36.1390 36.1430 -0.0040 -0.0021 CALC. LIBRETA 36.1410 36.1410 0.0000
16
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
59 BM-19+000 3.3400 3911.0098 -0.0001 BM-19+000 3.3401 3911.0098
1 4.9370 0.8710 3913.4788 -0.0001 1 4.9371 0.8709 3913.4790
2 4.8350 0.2010 3918.2148 -0.0001 2 4.8351 0.2009 3918.2152
3 4.1930 0.3250 3922.7248 -0.0001 3 4.1931 0.3249 3922.7255
4 4.4130 0.1600 3926.7578 -0.0001 4 4.4131 0.1599 3926.7587
5 4.5120 0.1560 3931.0148 -0.0001 5 4.5121 0.1559 3931.0159
6 4.9230 0.1680 3935.3588 -0.0001 6 4.9231 0.1679 3935.3601
7 4.9420 0.2530 3940.0288 -0.0001 7 4.9421 0.2529 3940.0304
8 2.8840 0.4750 3944.4958 -0.0001 8 2.8841 0.4749 3944.4976
9 BM-19+500 0.7160 0.7160 3946.6638 -0.0001 9 BM-19+500 0.7161 0.7159 3946.6658
10 0.3500 2.7590 3944.6208 -0.0001 10 0.3501 2.7589 3944.6230
11 0.1470 4.8370 3940.1338 -0.0001 11 0.1471 4.8369 3940.1362
12 0.1830 4.9390 3935.3418 -0.0001 12 0.1831 4.9389 3935.3445
13 0.1750 4.5310 3930.9938 -0.0001 13 0.1751 4.5309 3930.9967
14 0.1120 4.3650 3926.8038 -0.0001 14 0.1121 4.3649 3926.8069
15 0.2480 4.1170 3922.7988 -0.0001 15 0.2481 4.1169 3922.8021
16 0.1660 4.8010 3918.2458 -0.0001 16 0.1661 4.8009 3918.2494
17 0.6710 4.7370 3913.6748 -0.0001 17 0.6711 4.7369 3913.6786
18 BM-19+000 3.3400 3911.0058 -0.0001 18 BM-19+000 3.3399 3911.0098
CALC. EXCEL 41.7470 41.7510 -0.0040 -0.0040 CALC. EXCEL 41.7490 41.7490 0.0000
CALC. LIBRETA 41.7470 41.7510 -0.0040 -0.0021 CALC. LIBRETA 41.7490 41.7490 0.0000
17
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
62 BM-20+000 1.1000 3948.4498 0.0000 BM-20+000 1.1000 3948.4498
1 0.2690 4.5680 3944.9818 0.0000 1 0.2690 4.5680 3944.9817
2 0.7190 4.7740 3940.4768 0.0000 2 0.7190 4.7740 3940.4767
3 0.5650 4.5190 3936.6768 0.0000 3 0.5650 4.5190 3936.6766
4 0.2450 4.8720 3932.3698 0.0000 4 0.2450 4.8720 3932.3696
5 0.3100 4.9530 3927.6618 0.0000 5 0.3100 4.9530 3927.6615
6 0.5580 4.7790 3923.1928 0.0000 6 0.5580 4.7790 3923.1924
7 0.4730 4.5800 3919.1708 0.0000 7 0.4730 4.5800 3919.1704
8 P-22 4.9800 4.9800 3914.6638 0.0000 8 P-22 4.9800 4.9800 3914.6633
9 4.1970 0.0890 3919.5548 0.0000 9 4.1970 0.0890 3919.5542
10 4.7260 0.5040 3923.2478 0.0000 10 4.7260 0.5040 3923.2472
11 4.8210 0.1780 3927.7958 0.0000 11 4.8210 0.1780 3927.7951
12 4.7850 0.1570 3932.4598 0.0000 12 4.7850 0.1570 3932.4591
13 4.2100 0.2560 3936.9888 0.0000 13 4.2100 0.2560 3936.9880
14 4.6330 0.5790 3940.6198 0.0000 14 4.6330 0.5790 3940.6189
15 4.4220 0.1240 3945.1288 0.0000 15 4.4220 0.1240 3945.1279
16 BM-20+000 1.1000 3948.4508 0.0000 16 BM-20+000 1.1000 3948.4498
CALC. EXCEL 41.0130 41.0120 0.0010 0.0010 CALC. EXCEL 41.0125 41.0125 0.0000
CALC. LIBRETA 41.0130 41.0120 0.0010 0.0005 CALC. LIBRETA 41.0125 41.0125 0.0000
18
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
66 BM-21+500 1.4680 3874.0098 0.0001 BM-21+500 1.4679 3874.0098
1 1.0390 4.0300 3871.4478 0.0001 1 1.0389 4.0301 3871.4477
2 0.1170 4.7690 3867.7178 0.0001 2 0.1169 4.7691 3867.7176
3 0.2620 4.8380 3862.9968 0.0001 3 0.2619 4.8381 3862.9965
4 0.8150 4.4420 3858.8168 0.0001 4 0.8149 4.4421 3858.8164
5 PB-04 BM 22+000 0.3630 0.3630 3859.2688 0.0001 5 PB-04 BM 22+000 0.3629 0.3631 3859.2683
6 4.5130 0.8860 3858.7458 0.0001 6 4.5130 0.8861 3858.7452
7 4.7760 0.2010 3863.0578 0.0001 7 4.7760 0.2011 3863.0571
8 4.8420 0.1890 3867.6448 0.0001 8 4.8420 0.1891 3867.6440
9 3.9010 0.9090 3871.5778 0.0001 9 3.9010 0.9091 3871.5769
10 BM-21+500 1.4680 3874.0108 0.0001 10 BM-21+500 1.4681 3874.0098
CALC. EXCEL 22.0960 22.0950 0.0010 0.0010 CALC. EXCEL 22.0955 22.0955 0.0000
CALC. LIBRETA 22.0960 22.0950 0.0010 0.0006 CALC. LIBRETA 22.0955 22.0955 0.0000
19
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
70 BM-23+000 0.3500 3893.9878 0.0002 BM-23+000 0.3498 3893.9878
1 0.2910 3.0740 3891.2638 0.0002 1 0.2908 3.0742 3891.2635
2 0.2760 4.7320 3886.8228 0.0002 2 0.2758 4.7322 3886.8222
3 0.2660 4.7650 3882.3338 0.0002 3 0.2658 4.7652 3882.3329
4 0.6820 4.2340 3878.3658 0.0002 4 0.6818 4.2342 3878.3646
5 0.3450 4.6770 3874.3708 0.0002 5 0.3448 4.6772 3874.3692
6 0.2300 4.8610 3869.8548 0.0002 6 0.2298 4.8612 3869.8529
7 0.0700 4.5100 3865.5748 0.0002 7 0.0698 4.5102 3865.5726
8 BM-23+500 3.6110 3.6110 3862.0338 0.0002 8 BM-23+500 3.6108 3.6112 3862.0313
9 4.4590 0.0190 3865.6258 0.0002 9 4.4588 0.0192 3865.6230
10 4.7280 0.0950 3869.9898 0.0002 10 4.7278 0.0952 3869.9867
11 4.5690 0.2360 3874.4818 0.0002 11 4.5688 0.2362 3874.4784
12 4.0900 0.5390 3878.5118 0.0002 12 4.0898 0.5392 3878.5081
13 4.7240 0.2240 3882.3778 0.0002 13 4.7238 0.2242 3882.3737
14 4.6520 0.1940 3886.9078 0.0002 14 4.6518 0.1942 3886.9034
15 3.1470 0.3640 3891.1958 0.0002 15 3.1468 0.3642 3891.1911
16 BM-23+000 0.3500 3893.9928 0.0002 16 BM-23+000 0.3502 3893.9878
CALC. EXCEL 36.4900 36.4850 0.0050 0.0050 CALC. EXCEL 36.4875 36.4875 0.0000
CALC. LIBRETA 36.4900 36.4850 0.0050 0.0027 CALC. LIBRETA 36.4875 36.4875 0.0000
20
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
73 BM-24+500 0.4000 3835.5403 0.0001 BM-24+500 0.3999 3835.5403
1 0.1530 4.5230 3831.4173 0.0001 1 0.1529 4.5231 3831.4171
2 1.3150 2.6220 3828.9483 0.0001 2 1.3149 2.6221 3828.9480
3 P-24 2.6690 2.6690 3827.5943 0.0001 3 P-24 2.6689 2.6691 3827.5938
4 1.9490 0.6420 3829.6213 0.0001 4 1.9489 0.6421 3829.6206
5 4.5220 0.1510 3831.4193 0.0001 5 4.5219 0.1511 3831.4185
6 BM-24+500 0.4000 3835.5413 0.0001 6 BM-24+500 0.4001 3835.5403
CALC. EXCEL 11.0080 11.0070 0.0010 0.0010 CALC. EXCEL 11.0075 11.0075 0.0000
CALC. LIBRETA 11.0080 11.0070 0.0010 0.0006 CALC. LIBRETA 11.0075 11.0075 0.0000
21
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
77 P-26 0.7780 3796.1708 0.0000 P-26 0.7780 3796.1708
1 0.8910 4.8090 3792.1398 0.0000 1 0.8910 4.8090 3792.1399
2 0.6830 4.9200 3788.1108 0.0000 2 0.6830 4.9200 3788.1110
3 0.5900 4.8560 3783.9378 0.0000 3 0.5900 4.8560 3783.9381
4 0.2590 4.8040 3779.7238 0.0000 4 0.2590 4.8040 3779.7242
5 0.7300 2.9090 3777.0738 0.0000 5 0.7300 2.9090 3777.0743
6 0.4390 3.0520 3774.7518 0.0000 6 0.4390 3.0520 3774.7524
7 0.1800 4.0280 3771.1628 0.0000 7 0.1800 4.0280 3771.1635
8 0.5770 4.8980 3766.4448 0.0000 8 0.5770 4.8980 3766.4456
9 0.3340 4.9100 3762.1118 0.0000 9 0.3340 4.9100 3762.1127
10 BM-25+500 2.5380 2.5380 3759.9078 0.0000 10 BM-25+500 2.5380 2.5380 3759.9088
11 4.9220 0.3450 3762.1008 0.0000 11 4.9221 0.3450 3762.1019
12 4.7840 0.4630 3766.5598 0.0000 12 4.7841 0.4630 3766.5610
13 4.1020 0.2550 3771.0888 0.0000 13 4.1021 0.2550 3771.0901
14 2.9780 0.3650 3774.8258 0.0000 14 2.9781 0.3650 3774.8272
15 2.9990 0.8190 3776.9848 0.0000 15 2.9991 0.8190 3776.9863
16 4.8250 0.2800 3779.7038 0.0000 16 4.8251 0.2800 3779.7054
17 4.8690 0.6050 3783.9238 0.0000 17 4.8691 0.6050 3783.9255
18 4.7060 0.4690 3788.3238 0.0000 18 4.7061 0.4690 3788.3256
19 4.4350 0.5180 3792.5118 0.0000 19 4.4350 0.5180 3792.5137
20 P-26 0.7780 3796.1688 0.0000 20 P-26 0.7780 3796.1708
CALC. EXCEL 46.6190 46.6210 -0.0020 -0.0020 CALC. EXCEL 46.6200 46.6200 0.0000
CALC. LIBRETA 46.6190 46.6210 -0.0020 -0.0010 CALC. LIBRETA 46.6200 46.6200 0.0000
22
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
79 BM-26+000 0.4590 3722.4903 0.0002 BM-26+000 0.4588 3722.4903
1 0.5250 4.9410 3718.0083 0.0002 1 0.5248 4.9412 3718.0080
2 0.4700 4.8700 3713.6633 0.0002 2 0.4698 4.8702 3713.6627
3 0.1790 4.6650 3709.4683 0.0002 3 0.1788 4.6652 3709.4674
4 0.4640 4.6810 3704.9663 0.0002 4 0.4638 4.6812 3704.9651
5 1.1150 4.6880 3700.7423 0.0002 5 1.1148 4.6882 3700.7407
6 2.0410 1.3270 3700.5303 0.0002 6 2.0408 1.3272 3700.5284
7 1.6310 0.7690 3701.8023 0.0002 7 1.6308 0.7692 3701.8001
8 BM-26+500 1.5540 1.5540 3701.8793 0.0002 8 BM-26+500 1.5538 1.5542 3701.8768
9 0.8360 1.6980 3701.7353 0.0002 9 0.8358 1.6982 3701.7325
10 1.3100 2.0230 3700.5483 0.0002 10 1.3098 2.0232 3700.5452
11 4.7600 1.1870 3700.6713 0.0002 11 4.7598 1.1872 3700.6679
12 4.7490 0.5310 3704.9003 0.0002 12 4.7488 0.5312 3704.8966
13 4.6220 0.1350 3709.5143 0.0002 13 4.6218 0.1352 3709.5102
14 4.8580 0.4570 3713.6793 0.0002 14 4.8578 0.4572 3713.6749
15 4.6920 0.2750 3718.2623 0.0002 15 4.6918 0.2752 3718.2576
16 BM-26+000 0.4590 3722.4953 0.0002 16 BM-26+000 0.4592 3722.4903
CALC. EXCEL 34.2650 34.2600 0.0050 0.0050 CALC. EXCEL 34.2625 34.2625 0.0000
CALC. LIBRETA 34.2650 34.2600 0.0050 0.0027 CALC. LIBRETA 34.2625 34.2625 0.0000
23
CALCULOS DE NIVELACION CERRADA
INGRESO DATA Y CALCULO INICIAL AJUSTE CALCULO AJUSTADO
HITO VISTA VISTA Difer COTA POR HITO VISTA VISTA Difer COTA
N° PUNTO ATRÁS ADEL. Nivel PUNTO N° PUNTO ATRÁS ADEL. Nivel
82 PB-05 BM 27+000 2.9810 3679.4188 0.0001 PB-05 BM 27+000 2.9809 3679.4188
1 0.3080 4.5470 3677.8528 0.0001 1 0.3079 4.5471 3677.8526
2 0.1200 4.8350 3673.3258 0.0001 2 0.1199 4.8351 3673.3253
3 0.6320 4.9510 3668.4948 0.0001 3 0.6319 4.9511 3668.4941
4 0.3760 4.8840 3664.2428 0.0001 4 0.3759 4.8841 3664.2418
5 0.0720 4.6560 3659.9628 0.0001 5 0.0719 4.6561 3659.9616
6 0.3480 4.7660 3655.2688 0.0001 6 0.3479 4.7661 3655.2673
7 0.1670 4.8510 3650.7658 0.0001 7 0.1669 4.8511 3650.7641
8 0.6270 3.6120 3647.3208 0.0001 8 0.6269 3.6121 3647.3188
9 0.4560 3.9480 3643.9998 0.0001 9 0.4559 3.9481 3643.9976
83 10 AZ-05 BM 27+500 2.2090 2.2090 3642.2468 0.0001 10 AZ-05 BM 27+500 2.2089 2.2091 3642.2443
11 3.8530 0.3610 3644.0948 0.0001 11 3.8529 0.3611 3644.0921
12 3.6300 0.6440 3647.3038 0.0001 12 3.6299 0.6441 3647.3008
13 4.9050 0.2200 3650.7138 0.0001 13 4.9049 0.2201 3650.7106
14 4.6610 0.2420 3655.3768 0.0001 14 4.6609 0.2421 3655.3733
15 4.6890 0.1040 3659.9338 0.0001 15 4.6889 0.1041 3659.9301
16 4.8650 0.3570 3664.2658 0.0001 16 4.8649 0.3571 3664.2618
17 4.8480 0.5280 3668.6028 0.0001 17 4.8479 0.5281 3668.5986
18 4.8150 0.1000 3673.3508 0.0001 18 4.8149 0.1001 3673.3463
19 4.5540 0.3150 3677.8508 0.0001 19 4.5539 0.3151 3677.8461
20 PB-05 BM 27+000 2.9810 3679.4238 0.0001 20 PB-05 BM 27+000 2.9811 3679.4188
CALC. EXCEL 49.1160 49.1110 0.0050 0.0050 CALC. EXCEL 49.1135 49.1135 0.0000
CALC. LIBRETA 49.1160 49.1110 0.0050 0.0026 CALC. LIBRETA 49.1135 49.1135 0.0000
24
1 PB-00 BM 0+000 3532.7768 PB-00 BM 0+000 3532.7768
2 AZ-00 BM 0+500 3549.6353 AZ-00 BM 0+500 3549.6353
3 P-01 3559.4678 P-01 3559.4678
4 BM-1+000 3575.2933 BM-1+000 3575.2933
5 P-02 3578.6898 P-02 3578.6898
6 P-03 3587.0898 P-03 3587.0898
7 P-04 3592.4793 P-04 3592.4793
8 BM-1+500 3594.5758 BM-1+500 3594.5758
9 P-05 3587.5243 P-05 3587.5243
10 BM-2+000 3568.7153 BM-2+000 3568.7153
11 BM-2+500 3597.6493 BM-2+500 3597.6493
12 P-06 3606.9743 P-06 3606.9743
13 P-07 3616.2428 P-07 3616.2428
14 BM-3+000 3612.6848 BM-3+000 3612.6848
15 BM-3+500. 3628.1708 BM-3+500. 3628.1708
16 BM-4+000 3632.6078 BM-4+000 3632.6078
17 BM-4+500 3640.4083 BM-4+500 3640.4083
18 P-08 3640.4358 P-08 3640.4358
19 BM-5+000 3632.3563 BM-5+000 3632.3563
20 PB-01 BM 5+500 3637.7628 PB-01 BM 5+500 3637.7628
21 AZ-01 BM 6+000 3641.6238 AZ-01 BM 6+000 3641.6238
22 BM-6+500 3643.2618 BM-6+500 3643.2618
23 BM-7+000 3645.7653 BM-7+000 3645.7653
24 BM-7+500 3668.6718 BM-7+500 3668.6718
25 P-09 3681.8573 P-09 3681.8573
26 BM-8+000 3691.2343 BM-8+000 3691.2343
27 BM-8+500 3718.9483 BM-8+500 3718.9483
28 P-10 3736.7743 P-10 3736.7743
29 BM-9+000 3749.1758 BM-9+000 3749.1758
30 BM-9+500 3773.6203 BM-9+500 3773.6203
31 BM-10+000 3799.6443 BM-10+000 3799.6443
32 P-11 3798.8028 P-11 3798.8028
33 P-12 3812.1063 P-12 3812.1063
34 BM-10+500 3812.0068 BM-10+500 3812.0068
35 PB-02 BM 11+000 3829.4298 PB-02 BM 11+000 3829.4298
36 AZ-02 BM 11+500 3865.2218 AZ-02 BM 11+500 3865.2218
37 P-13 3884.5063 P-13 3884.5063
38 BM-12+000 3879.4228 BM-12+000 3879.4228
39 BM-12+500 3861.5088 BM-12+500 3861.5088
40 P-14 3847.0273 P-14 3847.0273
41 BM-13+000 3844.7078 BM-13+000 3844.7078
42 BM-13+500 3833.0188 BM-13+500 3833.0188
43 BM-14+000 3820.3143 BM-14+000 3820.3143
44 P-15 3814.5938 P-15 3814.5938
45 BM-14+500 3797.2683 BM-14+500 3797.2683
46 BM-15+000 3791.8753 BM-15+000 3791.8753
47 P-16 3798.4108 P-16 3798.4108
48 BM-15+500 3796.7833 BM-15+500 3796.7833
49 BM-16+000 3801.5918 BM-16+000 3801.5918
50 PB-03 BM 16+500 3814.1558 PB-03 BM 16+500 3814.1558
51 AZ-03 BM 17+000 3815.6378 AZ-03 BM 17+000 3815.6378
52 P-17 3826.6488 P-17 3826.6488
53 BM-17+500 3831.1473 BM-17+500 3831.1473
54 BM-18+000 3868.1268 BM-18+000 3868.1268
55 BM-18+500 3897.7018 BM-18+500 3897.7018
56 P-18 3899.3463 P-18 3899.3463
57 P-19 3901.9628 P-19 3901.9628
58 P-20 3912.2613 P-20 3912.2613
59 BM-19+000 3911.0098 BM-19+000 3911.0098
60 BM-19+500 3946.6658 BM-19+500 3946.6658
61 P-21 3956.7663 P-21 3956.7663
62 BM-20+000 3948.4498 BM-20+000 3948.4498
63 P-22 3914.6633 P-22 3914.6633
64 BM-20+500 3910.1968 BM-20+500 3910.1968
65 BM-21+000 3891.0593 BM-21+000 3891.0593
66 BM-21+500 3874.0098 BM-21+500 3874.0098
67 PB-04 BM 22+000 3859.2683 PB-04 BM 22+000 3859.2683
68 AZ-04 BM 22+500 3875.4833 AZ-04 BM 22+500 3875.4833
69 P-23 3884.9523 P-23 3884.9523
70 BM-23+000 3893.9878 BM-23+000 3893.9878
71 BM-23+500 3862.0313 BM-23+500 3862.0313
72 BM-24+000 3856.7468 BM-24+000 3856.7468
73 BM-24+500 3835.5403 BM-24+500 3835.5403
74 P-24 3827.5938 P-24 3827.5938
75 P-25 3803.2218 P-25 3803.2218
76 BM-25+000 3795.6753 BM-25+000 3795.6753
77 P-26 3796.1708 P-26 3796.1708
78 BM-25+500 3759.9088 BM-25+500 3759.9088
79 BM-26+000 3722.4903 BM-26+000 3722.4903
80 BM-26+500 3701.8768 BM-26+500 3701.8768
81 P-27 3708.8173 P-27 3708.8173
82 PB-05 BM 27+000 3679.4188 PB-05 BM 27+000 3679.4188
83 AZ-05 BM 27+500 3642.2468 AZ-05 BM 27+500 3642.2443