7/25/2019 hoja de calculo de PI Y PT de carreteras

1/8

Coordenadas UTM eje de la carretera tomados en c

Punto UTM cota progresiva pendiente Eclimet

1 89!"## "$"! #%## # &$1'"

$ 89!$9" "1"( #%$# ) &$1'

" 89!$8( "1"* #%# ) &"$'

89!$*! "1"9 #%(# ) &"$'$

! 89!$(* "1$ #%8# ) &9'"

( 89!$!* "1 #%1## ) &!8'"

* 89!$ "1! #%1$# ) &"*'!

8 89!$"$ "19 #%1# ) &$8'

9 89!$$! "1!# #%1(# ) &('"

1# 89!$#$ "19 #%18# ) &"1'$

11 89!18" "1!1 #%$## ) &$$'"

1$ 89!1*1 "1!$ #%$$# ) ""'1

1" 89!1* "1!* #%$# ) &""'$

1 89!1$$ "1!* #%$(# ) &$"'"

1! 89!1#1 "1(# #%$8# ) &"'!

1( 89!#81 "1(" #%"## ) &$1'$

1* 89!#!* "1(* #%"$# ) &!*'1

18 89!#$ "1(9 #%"# ) &"#

19 89!#$ "1*# #%"(# ) &$1'$

$# 89!## "1*" #%"8# ) &('"

$1 8999# "1*( #%## ) &"'!

$$ 8998 "1** #%$# ) &18'"

$" 8998$ "18# #%# ) &$#'"

$ 8998* "18# #%(# ) &1$'

$! 899*# "18" #%8# ) &$"'

$( 899( "18( #%!## ) &('$

$* 899(( "18* #%!$# ) &$1'$

$8 899*$ "19" #%!# ) &$9'

$9 8998 "19" #%!(# ) &$8'!

"# 89999 "19( #%!8# ) &$('

"1 89!#$# "199 #%(## ) &$#

"$ 89!#$$ "19* #%($# ) &!'"

"" 89!#"1 "$#" #%(# ) &"8'

" 89!#1* "$#$ #%((# ) &$!'"

"! 8999! "$# #%(8# ) &"1'"

"( 899*9 "$#" #%*## ) &"*'

"* 89!" "$# #%*$# ) &$'

"8 899"! "$#8 #%*# ) &"8'

"9 8991( "$#8 #%*(# ) &8'"

# 8989( "$1# #%*8# ) &"#'8

1 898*8 "$11 #%8## ) &'

$ 898( "$11 #%8$# ) &$!'

" 898!( "$1! #%8# ) &"8'

898* "$18 #%8(# ) &("'!! 898" "$1 #%88# ) &("'!

( 898"" "$18 #%9## ) '"

7/25/2019 hoja de calculo de PI Y PT de carreteras

2/8

* 898"" "$1 #%9$# &$) &"9'"

8 898"# "$1$ #%9# &$) &"9'"

9 898"" "$1 #%9(# &") &!#

!# 8981# "$1# #%98# &) &$$'"

!1 89*89 "$# #%1### ) &$$'

!$ 89**$ "$#* #%1#$# $) &"1'"

!" 89*!1 "$#" #%1## &) &1#

! 89*$ "$#* #%1#(# &) &'"

!! 89*$ "$#* #%1#8# ) &9'!

!( 89(!1 "$#$ #%111# &$) &1$'

!* 89("1 "$#! #%11$# &) &$#

!8 89(1 "$#1 #%11# ) #'"

!9 89!9# "$#" #%11(# ) &11'"

7/25/2019 hoja de calculo de PI Y PT de carreteras

3/8

mpo

ro SECCIONAMIENTO

11'$

$!'!

$*'$

*#

"'!

$$'!

'"

19'"

$"'"

"8'

$"'1

$1'!

$!'$

$$'"

!"'"

"'"

"!'"

$*'$

"8'$

1!'1

$!'!

1!'!

19'$

9'9

$1'"

$"'!

1*'"

1!'"

"#'

$$'"

1*'!

"#'"

!"'

$8'"

"1'"

1*'"

$$'$

$#'"

1'!

"#'"

' +OCA SUE,TA

$"'

"8'

("'!("'!

"8'"

7/25/2019 hoja de calculo de PI Y PT de carreteras

4/8

"9'"

"9'"

$'"

$$'"

18'

$#

1#

'"

9'!

1$'

$#

#'"PUENTE

""'

7/25/2019 hoja de calculo de PI Y PT de carreteras

5/8

Coordenadas UTM eje de la carretera tomados en campo

Punto NO+TE ESTE cota progresiva pendiente Eclimetro SECCI

1 #%### # &$1'"

$ 8-9-(!#-!!1 $$1-##8-81 "-1"!-9" #%#$# ) &$1'

" 8-9-*$"-(!8 $$1-#-19* "-$#(-!*9 #%## ) &"$'

8-9-*!#-8(! $$1-#!9-$8$ "-$#"-$1 #%#(# ) &"$'$

! 8-9-**$-1$* $$1-#(9-!1$ "-$#*-*81 #%#8# ) &9'"

( 8-9-*89-""* $$1-#8"-**8 "-$#-1( #%1## ) &!8'"

* 8-9-81#-#$ $$1-#9(-1* "-$#9-9 #%1$# ) &"*'!

8 8-9-8""-$#8 $$1-11"-$8# "-$1-*!# #%1# ) &$8'

9 8-9-8"#-#** $$1-1#-"*! "-$1$-8$8 #%1(# ) &('"

1# 8-9-8"$-8"" $$1-1(1-9$# "-$1"-#(8 #%18# ) &"1'$

11 8-9-8"$-9$ $$1-18-""1 "-$19-"1( #%$## ) &$$'"

1$ 8-9-8!(-19# $$1-$($-8#( "-$1!-*1 #%$$# ) ""'1

1" 8-9-8(-$$8 $$1-$*9-9"8 "-$1$-8$8 #%$# ) &""'$

1 8-9-89!-!"* $$1-$9#-$!$ "-$1#-9#! #%$(# ) &$"'"

1! 8-9-9"-("* $$1-$*8-9*# "-$#8-#$1 #%$8# ) &"'!

1( 8-9-9*-!1" $$1-$(1-"! "-$#"-9"! #%"## ) &$1'$

1* 8-9-99!-#8( $$1-$$9-189 "-$#"-(9! #%"$# ) &!*'1

18 8-9!-#1(-*8* $$1-$1-!"( "-$#$-#1$ #%"# ) &"#

19 8-9!-#$1-(#" $$1-$1$-"## "-19(-*$! #%"(# ) &$1'$

$# 8-9!-#19-9# $$1-$$8-$98 "-199-1$8 #%"8# ) &('"

$1 8-9-998-8*! $$1-$"-(*" "-19(-$! #%## ) &"'!

$$ 8-9-98"-9"( $$1-$(8-$8( "-19$-"99 #%$# ) &18'"

$" 8-9-9*$-19 $$1$9"'** "-19$-88# #%# ) &$#'"

$ 8-9-9(!-*!9 $$1-"18-1" "-18(-"91 #%(# ) &1$'

$! 8-9-9(-#!! $$1-"(-"!9 "-18(-8*$ #%8# ) &$"'

$( 8-9-9(9-9!" $$1-"*1-$( "-181-8$! #%!## ) &('$

$* 8-9-98(-8$$ $$1-"91-#! "-1*9-9#$ #%!$# ) &$1'$

$8 8-9-98$-#"$ $$1-"((-!#" "-181-!8 #%!# ) &$9'

$9 8-9-98#-#" $$1-"!-!# "-1**-*# #%!(# ) &$8'!

"# 8-9-989-!!8 $$1-"$!-$$ "-1*(-$9* #%!8# ) &$('

"1 8-9!-##-1*9 $$1-"#"-9$9 "-1*"-1*" #%(## ) &$#

"$ 8-9!-#$"-9#8 $$1-$*9-*"$ "-1*#-**# #%($# ) &!'"

"" 8-9!-#1-(1# $$1-$("-*( "-1(9-!(8 #%(# ) &"8'

" 8-9!-#!(-9(* $$1-$9-$9( "-1(*-1(! #%((# ) &$!'"

"! 8-9!-#81-1(1 $$1-$("-19 "-1($-!99 #%(8# ) &"1'"

"( 8-9!-1#1-1*8 $$1-$(8-$"! "-1(#-91* #%*## ) &"*'

"* 8-9!-1$$-"*" $$1-$*#-!9" "-1!(-11# #%*$# ) &$'

"8 8-9!-1(-91( $$1-$*#-"8 "-1!(-11# #%*# ) &"8'

"9 8-9!-1*#-*! $$1-$*1-"!$ "-1!$-#$ #%*(# ) &8'"

# 8-9!-18$-(*" $$1-$"-* "-1!#-"$ #%*8# ) &"#'8

1 8-9!-$#1-*(" $$1-$"9-(1 "-18-$# #%8## ) &'

$ 8-9!-$$!-$1# $$1-$"(-(" "-1!#-1#$ #%8$# ) &$!'

" 8-9!-$"1-*#* $$1-$9-*$( "-18-9## #%8# ) &"8'

8-9!-$-198 $$1-$(!-(19 "-1-#9 #%8(# ) &("'!! 8-9!-$!(-(*" $$1-$81-8"! "-1!-#!! #%88# ) &("'!

( 8-9!-$((-8$# $$1-$9(-*(1 "-1$-(!$ #%9## ) '"

7/25/2019 hoja de calculo de PI Y PT de carreteras

6/8

* 8-9!-$*-**8 $$1-"1#-!88 "-1#-89 #%9$# &$) &"9'"

8 8-9!-$8!-($" $$1-""$-19 "-1"(-#" #%9# &$) &"9'"

9 8-9!-$9"-#!9 $$1-"9-"$ "-1"(-#" #%9(# &") &!#

!# 8-9!-$99-8*9 $$1-"(-8*9 "-1"*-1$ #%98# &) &$$'"

!1 8-9!-"!!-89! $$1-"(1-8" "-1$-(!$ 1%### ) &$$'

!$ 8-9!-$-198 $$1-$(!-(19 "-1-#9 1%#$# $) &"1'"

!" 8-9!-$!(-(*" $$1-$81-8"! "-1!-#!! 1%## &) &1#

! 8-9!-$((-8$# $$1-$9(-*(1 "-1$-(!$ 1%#(# &) &'"

!! 8-9!-$*-**8 $$1-"1#-!88 "-1#-89 1%#8# ) &9'!

!( 8-9!-$8!-($" $$1-""$-19 "-1"(-#" 1%1## &$) &1$'

!* 8-9!-$9"-#!9 $$1-"9-"$ "-1"(-#" 1%1$# &) &$#

!8 8-9!-"##-9! $$1-"((-(*# "-1"(-#" 1%1# &) &$*'(

!8 8-9!-$99-8*9 $$1-"(-8*9 "-1"*-1$ 1%1(# ) #'"

!9 8-9!-"!!-89! $$1-"(1-8" "-1(*-(!$ 1%18# $) &11'"

7/25/2019 hoja de calculo de PI Y PT de carreteras

7/8

ONAMIENTO

11'$

$!'!

$*'$

*#

"'!

$$'!

'"

19'"

$"'"

"8'

$"'1

$1'!

$!'$

$$'"

!"'"

"'"

"!'"

$*'$

"8'$

1!'1

$!'!

1!'!

19'$

9'9

$1'"

$"'!

1*'"

1!'"

"#'

$$'"

1*'!

"#'"

!"'

$8'"

"1'"

1*'"

$$'$

$#'"

1'!

"#'"

' +OCA SUE,TA

$"'

"8'

("'!("'!

"8'"

7/25/2019 hoja de calculo de PI Y PT de carreteras

8/8

"9'"

"9'"

$'"

$$'"

18'

$#

1#

'"

9'!

1$'

$#

$*'(

#'"PUENTE

""'