Excel Nivel
Excel Nivel
Excel Nivel
1 2 3 4 5
Est PV Lat Lad ∆p Cotas DH (Tramos DH (Acum) Pend.(%)
E1 A 1.254 187.523 0 0
1 3.248 -1.994 185.529 80 80 -2.49
E2 1 2.025
2 1.152 0.873 186.402 82.5 162.5 1.06
E3 2 2.354
3 3.527 -1.173 185.229 76.65 239.15 -1.53
E4 3 3.875
B 2.764 1.111 186.34 68.42 307.57 1.62
∑ 9.508 10.691 -1.183
-1.183 Cotas(Y) DHA (X)
187.523 0
185.529 80
186.402 162.5
185.229 239.15
186.34 307.57
187.5
187
186.5
186
185.5
185
184.5
187
186.5
186
185.5
185
184.5
184
0 80 162.5 239.15 307.57
COMPENSACIÓN PROPORCIONAL A LA DISTANCIA NIVELADA
Est PV DH (Tramos)
DH ACUM Lat Lint Lad Horizonte Cot Calcul.
A 0 0 0.865 187.526
E1 1 60 60 1.543 188.391 186.848
2 160 220 2.284 186.107
PC1 70 290 3.861 184.53
PC1 2.736
E2 3 40 330 2.043 187.266 185.223
4 150 480 1.638 185.628
PC2 50 530 0.937 186.329
PC2 1.625
E3 5 80 610 2.174 187.954 185.78
6 140 750 0.917 187.037
A 80 830 0.42 187.534
∑ 5.226 5.218
0.008 0.008
8
Tn 13.66565 mm
Tn>En
Est PV DH (Tramos)
DH ACUM Lat Lint Lad Comp Horizonte
A 0 0 0.865
E1 1 60 60 1.543 188.391
2 160 220 2.284
PC1 70 290 3.861 -0.004
PC1 2.736
E2 3 40 330 2.043 187.262
4 150 480 1.638
PC2 50 530 0.937 -0.004
PC2 1.625
E3 5 80 610 2.174 187.946
6 140 750 0.917
A 80 830 0.42
∑ 5.226 5.218
0.008
C -0.004
Est PV DH (Tramos)
DH ACUM Lat Lint Lad Comp Horizonte
A 0 0.865
E1 1 60 1.543
2 160 2.284
PC1 70 3.861
PC1 2.736
E2 3 40 2.043
4 150 1.638
PC2 50 0.937
PC2 1.625
E3 5 80 2.174
6 140 0.917
A 80 0.42
∑
0
C 0
Cot+Comp
Comp Cot Comp
187.526
186.848
186.107
-0.003 184.527
-0.003 185.220
-0.003 185.625
-0.005 186.324
C1 -0.003
-0.005 185.775 C2 -0.005
-0.005 187.032 C3 -0.008
-0.008 187.526
m
mm
Cota Comp
187.526
186.848
186.107
184.526
185.219
185.624
186.321
185.772
187.029
187.526
Cot+Comp
Comp Cot Comp
187.526
m
mm
Cota Comp
187.526
NIVELACIÓN COMPUESTA
+ -
Est Prog Vat Horiz Vad Cota AV
0+0 1.965 301.965 0 300
E1 0+10 2.065 303.475 0.555 301.41 1.41
E2 0+20 1.93 304.995 0.41 303.065 1.655
E3 0+30 1.87 306.36 0.505 304.49 1.425
E4 0+40 1.623 307.494 0.489 305.871 1.381
E5 0+50 0.761 306.733 0.862
9.453 2.72
6.733 6.733
0 300 P= (∆v/∆h)*100
10 301.41
20 303.065
30 304.49 300
40 305.871
50 306.733
DH Pendiente %
0 EV 1//10
10 14.1 7.05 EH 1//100
20 16.55 8.275
30 14.25 7.125
40 13.81 6.905
50 8.62 4.31
301.41
14.10% ∆v
0+0 ∆h 0+10
Prog AV
0 0
10 0
20 0
30 0
COMPENSACIÓN PROPORCIONAL A LA DISTANCIA
Tn 12.1213
CIONAL A LA DISTANCIA NIVELADA
Cot+Comp
Lad Horizonte Cot Calcul. Comp Cot Comp COTA X 50 Distancia
3202.25 3200 3200 160000.00 0
3200.10 3200.10 160004.90 20
3199.58 3199.58 159979.10 22
3199.84 3199.84 159991.90 20
1.850 3200.4 -0.985 3199.42 159970.75 28
3203.2 0.00
3199.745 -0.985 3198.760 159938.00 31
3200.725 -0.985 3199.740 159987.00 29
0.220 3203.005 -3.005 3200 160000.00 18
2.070
3.005 m
3005 mm C1
mm C2
Tn>En
Chart Title
160020.00
160000.00
159980.00
159960.00
159940.00
159920.00
159900.00
0 100 200 300 400 500 600 700
ai AUTOCAD
0 DH ACU Cot Comp*50 CotComp
20 20,160004,9 0 160000.00 3200
42 42,159979,1 20 160004.90 3200.10
62 62,159991,9 62 159979.10 3199.58
90 90,159970,75 124 159991.90 3199.84
214 159971.00 3199.42
121 121,159938 335 159938.00 3198.76
29 29,159987 485 159987.00 3199.74
139 139,160000 653 160000.00 3200
COTA COTA*50
-0.985 Max 3200.00 160000
-3.005 Min 3198.76 159938
-0.19