Download - hoja de calculo de PI Y PT de carreteras
-
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
""'