7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 1/96
FACTORES CORRECCION HUACRAPUQUIOMES LIGEROS PESADOS
ENERO 1.14591 1.131484
FEBRERO 1.126689 1.098464
MARZO 1.098177 1.031785
ABRIL 1.093328 0.987853MAYO 0.926289 0.946586
JUNIO 0.996977 0.99949
JULIO 0.855816 1.008644
AGOSTO 0.971175 0.951954
SETIEMBRE 0.987818 0.939329
OCTUBRE 0.94422 0.953955
NOVIEMBRE 1.018335 1.008979
DICIEMBRE 0.937517 0.984842
TOTAL 1 1
FCEL=0.937517FCEP=0.984842
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 2/96
RAMO DE LA CARRETERA
SENTIDO
UBICACIÓN
DIA 1
HORA AUTO STATION WAGON
CAMI
PICK UP
Lu!" D# I$%!&'() * D# P(+," 161 25 63
12-10-2012D# P(+," * I$%!&'() 187 38 57
T,() 348 /3 120
M(&!" D# I$%!&'() * D# P(+," 125 27 60
12-11-2012D# P(+," * I$%!&'() 161 32 58
T,() 28/ 59 118
M'&,)!" D# I$%!&'() * D# P(+," 147 21 59
12-12-2012D# P(+," * I$%!&'() 168 27 73
T,() 315 48 132
u!#!" D# I$%!&'() * D# P(+," 165 28 51
12-13-2012D# P(+," * I$%!&'() 169 24 71
T,() 334 52 122'!&!" D# I$%!&'() * D# P(+," 189 25 63
12-14-2012D# P(+," * I$%!&'() 216 43 86
T,() 405 /8 149S(6, D# I$%!&'() * D# P(+," 175 38 47
12-15-2012 D# P(+," * I$%!&'() 171 39 49T,() 34/ 77 9/
D,$', D# I$%!&'() * D# P(+," 151 27 33
12-1/-2012D# P(+," * I$%!&'() 158 24 48
T,() 309 51 81
PARCIAL: 2343 418 818
SENTIDO
DIAGRA.VEH.
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 3/96
RAMO DE LA CARRETERA
SENTIDO
UBICACIÓN
DIA 1
HORA AUTO STATION WAGON
CAMI
PICK UP
Lu!" D# I$%!&'() * D# P(+," 172 20 70
12-10-2012D# P(+," * I$%!&'() 175 16 50
T,() 347 3/ 120
M(&!" D# I$%!&'() * D# P(+," 146 23 51
12-11-2012D# P(+," * I$%!&'() 156 22 48
T,() 302 45 99
M'&,)!" D# I$%!&'() * D# P(+," 141 17 43
12-12-2012D# P(+," * I$%!&'() 142 18 40
T,() 283 35 83
u!#!" D# I$%!&'() * D# P(+," 156 26 43
12-13-2012D# P(+," * I$%!&'() 145 19 51
T,() 301 45 94'!&!" D# I$%!&'() * D# P(+," 178 22 54
12-14-2012D# P(+," * I$%!&'() 188 38 47
T,() 3// /0 101S(6, D# I$%!&'() * D# P(+," 165 27 51
12-15-2012D# P(+," * I$%!&'() 170 27 44
T,() 335 54 95
D,$', D# I$%!&'() * D# P(+," 152 25 39
12-1/-2012D# P(+," * I$%!&'() 162 28 30
T,() 314 53 /9
PARCIAL: 2248 328 661
SENTIDO
DIAGRA.VEH.
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 4/96
FORMATO DE CLASIFICACION VEHI
ESTUDIO DE TRAFICO
DV IMPERIAL - PAMPAS
E S
NETAS
MICRO
US CAMION
2 E - 3 !"3 E 2 E 3 E
3 4 14 33 7
6 1 15 43 4
9 5 29 0 7/ 11
2 3 16 1 40 8
2 1 18 51 8
4 4 34 1 91 1/
5 1 22 46 8
6 2 15 75 17
11 3 37 0 121 25
8 4 21 1 33 9
3 5 17 1 53 9
11 9 38 2 8/ 188 3 21 1 36 13
8 8 24 66 13
1/ 11 45 1 102 2/10 1 20 22 13
8 3 18 48 2218 4 38 0 70 35
6 5 23 22 6
5 2 21 38 10
11 7 44 0 /0 1/
8# 43 26$ 4 6#6 14%
RURALC&'()
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 5/96
DESV PAZOS - PAMPAS
E S
NETAS
MICRO
US CAMION
2 E - 3 !"3 E 2 E 3 E
8 3 19 67 4
9 3 18 59 8
17 / 37 0 12/ 12
6 1 19 2 90 106 4 9 41 10
12 5 28 2 131 20
5 2 22 72 14
7 2 15 76 7
12 4 37 0 148 21
8 6 17 1 56 15
8 1 17 1 64 9
1/ 7 34 2 120 2410 1 22 1 55 17
10 5 22 2 67 12
20 / 44 3 122 2915 3 18 1 67 13
14 1 19 1 86 8
29 4 37 2 153 21
15 6 29 57 11
14 5 13 2 70 10
29 11 42 2 127 21
13$ 43 2$* 11 *2% 148
RURALC&'()
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 6/96
ULAR
ESTACION
CODIGO DE LA ESTACION
DIA Y FECHA
SEMI TRA+LER
4 E 2S1,2S2 2S3 3S1,3S2 !" 3S3 2T2
2 4
2 4 1 17
0 2 / 1 21 0
2 1 1 7
1 1 3 1 20
1 3 4 2 27 0
5 3 3 12
1 2 20
5 4 5 0 32 0
1 3 7
5 2 2 14
/ 2 5 0 21 03 15
2 1 2 8
0 5 1 2 23 02 2 4
3 1 2 175 1 4 0 21 0
2 16
1 2 12
1 0 4 0 28 0
18 1% 2* $ 1%3 #
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 7/96
ESTACION
CODIGO DE LA ESTACION
DIA Y FECHA
SEMI TRA+LER
4 E 2S1,2S2 2S3 3S1,3S2 !" 3S3 2T2
3 5 1 13
2 2 4 11
5 2 9 1 24 0
1 0 1 2 63 0 1 1 22
4 0 2 3 28 0
5 0 3 1 14
1 0 3 16
/ 0 / 1 30 0
3 3 5
1 0 3 16
4 0 / 0 21 03 0 2 10
3 0 1 1 8
/ 0 3 1 18 06 0 1 3
3 0 3 17
9 0 3 1 20 0
3 1 7 15
1 0 10
4 0 1 7 25 0
38 2 3# 14 166 #
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 8/96
FORMATO N 1
DV - IMPERIAL
E-1
TRA+LER
TOTAL LIGEROS
2T3 3T2 !"3T3
256 60
289 86
0 0 0 545 14/
1 217 77
254 103
0 0 1 471 180
233 99
276 130
0 0 0 509 229
1 256 76
3 272 106
0 0 4 528 182288 89
361 116
0 0 0 /49 205271 63
270 1110 0 0 541 174
222 69
237 84
0 0 0 459 153
# # $ 3702 12/9
TOTAL
PESADOS
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 9/96
PAMPAS
E-2
TRA+LER
TOTAL LIGEROS
2T3 3T2 !"3T3
273 112
253 104
0 0 0 52/ 21/
227 131236 87
0 0 0 4/3 218
208 131
209 118
0 0 0 417 249
239 100
224 111
0 0 0 4/3 211265 110
288 116
0 0 0 553 22/261 109
256 137
0 0 0 517 24/
237 123
239 106
0 0 0 47/ 229
# # # 3415 1595
TOTALPESADOS
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 10/96
TOTAL
316
375
/91
294
357
/51
332
406
738
332
378
710377
477
854334
381715
291
321
/12
4971
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 11/96
TOTAL
385
357
742
358323
/81
339
327
///
339
335
/74375
404
779370
393
7/3
360
345
7055010
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 12/96
FACTOR CORRECCION EST 1
DIA
LUNES 691 1.027703MARTES 651 1.090849
MIERCOLES 738 0.962253
JUEVES 710 1.000201
VIERNES 854 0.831549
SABADO 715 0.993207
DOMINGO 612 1.160364
ROMEDIO 710 1.000000
FACTOR CORRECCION EST 2
DIA
LUNES 742 0.964575
MARTES 681 1.090849
MIERCOLES 666 0.962253
JUEVES 674 1.000201
VIERNES 779 0.831549
SABADO 763 0.993207
DOMINGO 705 1.160364
ROMEDIO 716 1.000000
OLUMENPROMEDIO
FACTOR DECORRECCION
OLUMENPROMEDIO
FACTOR DECORRECCION
1
2
3
7
60
62
64
66
68
70
72
74
76
78
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 13/96
LUNES MARTES MIERCOLES JUEVES VIERNES SABADO DOMINGO ROMEDIO0
00
00
00
00
00
00
0000
00
691 651
738
710
854
715612
710.14285714
ARIACIN HORARIA
LUNES MARTES MIERCOLES JUEVES VIERNES S ABADO DOMINGO ROMEDIO
742
681
666 674
779
763
705
715.7142857
ARIACIN HORARIA
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 15/96
HORA AUTO
CAMIO
PICK UP
IMD
D# I$%!&'() * D# P(+," 159.0 27.3 53.7
D# P(+," * I$%!&'() 175.7 32.4 63.1
T,() 335 /0 117
IMD(
D# I$%!&'() * D# P(+," 149.1 25.6 50.4
D# P(+," * I$%!&'() 164.7 30.4 59.2T,() 314 5/ 110
D# I$%!&'() * D# P(+," 149 26 50
D# P(+," * I$%!&'() 165 30 59
T,() 314 5/ 109
FACTOR VE". LIGERO 0.937517FACTOR VE". ESADO 0.984842
HORA AUTO
CAMIO
PICK UP
IMD
D# I$%!&'() * D# P(+," 158.6 22.9 50.1
D# P(+," * I$%!&'() 162.6 24.0 44.3
T,() 321 47 94
IMD(
D# I$%!&'() * D# P(+," 148.7 21.4 47.0
D# P(+," * I$%!&'() 152.4 22.5 41.5
T,() 301 44 89D# I$%!&'() * D# P(+," 149 21 47
D# P(+," * I$%!&'() 152 23 42
T,() 301 44 89
SENTIDO
STATIONWAGON
DIAGRA.VEH.
IMD(E!&,:
SENTIDO
STATIONWAGON
DIAGRA.VEH.
IMD(E!&,:
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 16/96
VOLUMEN + CLASIFICACION VEHICULAR - IMDA VEH.ESTUDIO DE TRAFICO
NETAS
MICRO
US CAMION
2 E - 3 !"3 E 2 E 3 E 4 E
6.0 3.0 19.6 0.4 33.1 9.1 1.1
5.4 3.1 18.3 0.1 53.4 11.9 1.4
11 / 38 1 87 21 35.6 2.8 19.3 0.4 32.6 9.0 1.1
5.1 2.9 18.0 0.1 52.6 11.7 1.411 / 37 1 85 21 3
6 3 19 0 33 9 1
5 3 18 0 53 12 1
11 / 37 0 8/ 21 2
VOLUMEN + CLASIFICACION VEHICULAR - IMDA VEH.ESTUDIO DE TRAFICO
NETAS
MICRO
US CAMION
2 E - 3 !"3 E 2 E 3 E 4 E
9.6 3.1 20.9 0.7 66.3 12.0 3.4
9.7 3.0 16.1 0.9 66.1 9.1 2.0
19 / 37 2 132 21 59.0 2.9 20.5 0.7 65.3 11.8 3.4
9.1 2.8 15.9 0.8 65.1 9.0 2.0
18 / 3/ 2 130 21 59 3 21 1 65 12 3
9 3 16 1 65 9 2
18 / 37 2 130 21 5
RURALC&'()
RURALC&'()
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 17/96
FORMATO N
DIA/ - EST 1
SEMI TRA+LER
2S1,2S2 2S3 3S1,3S2 !" 3S3 2T2 2T3
1.1 1.9 0.1 9.3 0.0 0.0
1.3 2.3 0.6 15.4 0.0 0.0
2 4 1 25 0 01.1 1.8 0.1 9.1 0.0 0.0
1.3 2.3 0.6 15.2 0.0 0.02 4 1 24 0 01 2 0 9 0 0
1 2 1 15 0 0
2 4 1 24 0 0
DIA/ - EST 2
SEMI TRA+LER
2S1,2S2 2S3 3S1,3S2 !" 3S3 2T2 2T3
0.0 2.1 1.7 9.4 0.0 0.0
0.3 2.1 0.3 14.3 0.0 0.0
0 4 2 24 0 00.0 2.1 1.7 9.3 0.0 0.0
0.3 2.1 0.3 14.1 0.0 0.0
0 4 2 23 0 00 2 2 9 0 0
0 2 0 14 0 0
0 4 2 23 0 0
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 18/96
1
RA+LER
TOTAL
3T2 !"3T3
0.0 0.3 249.0 76.1 325.1
0.0 0.4 279.9 105.1 385.0
0 1 529 181 7100.0 0.3 233.4 75.0 308.4
0.0 0.4 262.4 103.5 365.90 1 49/ 179 /740 0 233 74 307
0 0 262 103 365
0 0 49/ 177 /73
RA+LER
TOTAL
3T2 !"3T3
0.0 0.0 244.3 116.6 360.9
0.0 0.0 243.6 111.3 354.9
0 0 488 228 71/0.0 0.0 229.0 114.8 343.8
0.0 0.0 228.4 109.6 338.0
0 0 457 224 /820 0 229 115 344
0 0 229 109 338
0 0 458 224 /82
TOTALLIGEROS
TOTALPESADOS
TOTALLIGEROS
TOTALPESADOS
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 19/96
INCIDENCIA O*D TRANSPORTE DE PASAEROS
O&'!-D!"', C('6(6 ;"#$%&$'()$*+$, -/&,$ 378 70.7
"#$%&$'()C(&$$*$ -/&,$ 39 7.3
"#$%&$'()C(/$ -/&,$ 20 3.7
O(, -"$&/$ &%(, +($(, 98 18.3 535
F#% E%&#,$,
INCIDENCIA O*D TRANSPORTE DE CARGAO&'!-D!"', C('6(6 ;
"#$%&$'()$*+$, -/&,$ 84 25.0
"#$%&$'()C(&$$*$ -/&,$ 120 35.7
"#$%&$'()C(/$ -/&,$ 28 8.3
O(, -"$&/$ &%(, +($(, 104 31.0 336
F#% E%&#,$,
_
;
_
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 20/96
PARTICIPACION DE LAS REGIONES ENCUESTA * DES
TIPO DE EHICULOINTER REGIONAL
A<ACUCHO CUCO HUANCAELICA HUANUCOA#(<S=<C$*/(%$ 0.40> 0.20> 44.50> 0.20>
C.R#$ < M/&( 33.30>
O*%/#, 29.80>
C$*/%/(% U%/$/( 2.10> 54.40>
C$*/(% A/&#$( 61.80>
PERIODO2013)2020
F#% MTC)$% I
T$,$ &&/*/%( $%#$ ?@&#(, /(, &$*/(%$ #$
T$,$ &&/*/%( $%#$ *%/#,
T$,$ &&/*/%( $%#$ +($&/(%$ -)
T$,$ &&/*/%( $%#$ BI +)&+/$
T$,$ &&/*/%( $%#$ ?@&#(, &$$
T$,$ &&/*/%( BI
E$,/&/$ $ *$%$ &( ?@&#(, /(, &$*/(
E$,/&/$ $ *$%$ &( *%/#,
E$,/&/$ $ *$%$ &( ?@&#(, &$$
-1 -1 +_ +_á :1×_
; ; × 0
; ; ×
_
;0_
_á
_
_
_
_
_
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 21/96
TINO
DESCRIPCIN
UNIN LIMA TOTAL52.90> 1.80> 100.00>
63.00> 3.70> 100.00>
59.60> 10.60> 100.00>
38.80> 4.70> 100.00>
12.70> 25.50> 100.00>
PASAEROS CARGA1 1
%*($ T$%,+(, 2004)2013 PERIODO2013)2034
*/&(,
%$ #$ ' ((,
INDICADORESMACROECONOMICOS
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 22/96
INDICADORES MACROECONOMICOS
REGIN
A>(u?, 1.02> 6.00>Cu+, 0.52> 7.49>
Hu((#!)'( 0.62> 1.51>
Huu, 0.62> 2.91>
u@ 0.65> 3.75>
L'$( 1.49> 4.97>
Au," P'Bu% C($ C.R.M'&, O$'u"3.50> 3.70> 4.20>
INEI POLACIONDEPARTAMENTAL
PRO<ECTADA
INEI PI PERCAPITA
PROMEDIO 2001*2010
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 23/96
7.40>8.40>
2.40>
3.90>
4.60>
6.60>
C($', U'(&', C($', A&'u)(6,3.60> 3.80>
PI DEPARTAMENTALPROMEDIO 2001*2010
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 24/96
PRO<EC
HORA AUTO STATION WAGON
CAMIONETAS
MICROPICK UP
2012 314 5/ 109 11 /2#13 325 58 113 11 6
2014 336 60 117 12 6
2015 38 62 121 12 7
2#16 360 6 125 13 7
2017 373 67 12! 13 7
2018 386 6! 13 1 7
2#1* 3!! 71 13! 1 8
2020 13 7 1 15 8
2021 28 76 1! 15 82#22 3 7! 15 16 !
2023 58 82 15! 16 !
2024 7 85 165 17 !
2#2$ !1 88 170 18 10
202/ 508 !1 176 18 10
2#2% 526 ! 183 1! 10
2028 5 !7 18! 20 11
2029 56 101 1!6 20 11
2#3# 583 10 202 21 12
2031 60 108 210 22 122032 625 111 217 23 12
2#33 67 115 22 2 13
2034 66! 11! 232 2 13
PRO<
HORA AUTO STATION WAGON
CAMIONETAS
MICROPICK UP
2012 301 44 89 18 /2#13 312 6 !2 1! 6
2014 322 7 !5 1! 6
2015 33 ! !! 20 7
2#16 35 50 102 21 7
2017 357 52 106 22 7
RURALC&'()
DIAGRA.
VEH.
RURALC&'()
DIAGRA.VEH.
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 25/96
2018 370 5 10! 22 7
2#1* 383 56 113 23 8
2020 3!6 58 117 2 8
2021 10 60 121 25 8
2#22 25 62 126 26 !
2023 3! 6 130 27 !
2024 55 66 13 28 !2#2$ 71 6! 13! 2! 10
202/ 87 71 1 30 10
2#2% 50 7 1! 31 10
2028 522 76 15 32 11
2029 50 7! 160 33 11
2#3# 55! 82 165 35 12
2031 57! 85 171 36 12
2032 5!! 88 177 37 12
2#33 620 !1 183 3! 13
203462 ! 1!0 0 13
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 26/96
ION DEL TRAFICO NORMAL 2013*2034 * TRAMO 1 D. IMPUS CAMION
2 E - 3 !"3 E 2 E 3 E 4 E 2S1,2S2
37 8/ 21 2 23! 8! 22 2 2
0 !2 23 2 2
2 !6 23 2 2
!! 2 2 2
5 103 25 2 2
7 106 26 2 3
! 110 27 3 3
51 11 28 3 3
5 118 2! 3 356 122 30 3 3
58 127 31 3 3
61 131 32 3 3
63 136 33 3 3
66 11 3 3 3
6! 16 36 3 3
71 151 37
7 157 38
78 163 0
81 168 1 8 17 3
88 181
!1 187 6 5
CCION DEL TRAFICO NORMAL 2013*2034 * TRAMO 2 D. PUS CAMION
2 E - 3 !"3 E 2 E 3 E 4 E 2S1,2S2
37 2 130 21 5 03! 2 135 22 5 0
0 2 10 23 5 0
2 2 15 23 6 0
2 150 2 6 0
5 2 155 25 6 0
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 27/96
7 3 161 26 6 0
! 3 167 27 6 0
51 3 173 28 7 0
5 3 17! 2! 7 0
56 3 185 30 7 0
58 3 1!2 31 7 0
61 3 1!! 32 8 063 3 206 33 8 0
66 213 3 8 0
6! 221 36 8 0
71 22! 37 ! 0
7 237 38 ! 0
78 26 0 ! 0
81 255 1 10 0
8 5 26 3 10 0
88 5 273 11 0
!1 5 283 6 11 0
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 28/96
RIAL * D* PAOSSEMI TRA+LER
TOTAL LIGEROS2S3 3S1,3S2 !" 3S3
4 24 496 176
25 513 183
26 531 189
27 550 197
5 28 569 204
5 2! 589 212
5 30 610 220
5 31 631 228
5 32 653 236
6 3 676 2456 35 700 255
6 36 725 264
6 38 750 274
6 3! 776 285
7 0 804 295
7 2 832 306
7 861 318
8 5 891 330
8 7 922 342
8 ! 955 3558 51 988 369
! 53 1023 383
! 55 1059 397
OS * PAMPASSEMI TRA+LER
TOTAL LIGEROS2S3 3S1,3S2 !" 3S3
4 2 23 458 224
2 2 474 232
2 25 491 241
2 26 508 250
5 2 27 526 259
5 2 28 544 269
TOTALPESADOS
TOTALPESADOS
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 29/96
5 3 2! 563 279
5 3 30 583 289
5 3 31 604 300
6 3 32 625 312
6 3 33 647 323
6 3 35 669 335
6 3 36 693 3486 3 37 717 361
7 3 3! 742 374
7 3 0 768 388
7 2 795 403
8 3 823 418
8 5 852 433
8 7 882 450
8 8 913 466
! 50 945 484
! 5 52 978 502
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 30/96
TOTAL
672
696
721
747
773
801
830
859
890
922955
989
1024
1061
1099
1138
1179
1221
1265
13101357
1405
1456
TOTAL
682
706
732
758
785
813
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 31/96
842
873
904
936
970
1005
10411078
1117
1157
1198
1241
1286
1332
1380
1429
1480
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 32/96
PRO<ECCI
HORA AUTO STATION WAGON
CAMIONETAS
MICROPICK UP
20122#13 /5 12 23 2 12014 /7 12 23 2 12015 70 12 24 2 12#16 72 13 25 3 12017 75 13 2/ 3 12018 77 14 27 3 12#1* 80 14 28 3 22020 83 15 29 3 2
2021 8/ 15 30 3 22#22 89 1/ 31 3 22023 92 1/ 32 3 22024 95 17 33 3 22#2$ 98 18 34 4 2202/ 102 18 35 4 22#2% 105 19 37 4 22028 109 19 38 4 22029 113 20 39 4 22#3# 117 21 40 4 22031 121 22 42 4 22032 125 22 43 5 22#33 129 23 45 5 32034 134 24 4/ 5 3
PRO<E
HORA AUTO STATION WAGON
CAMIONETAS
MICROPICK UP
2012 /0 9 18 4 12#13 /2 9 18 4 12014 /4 9 19 4 12015 /7 10 20 4 12#16 /9 10 20 4 12017 71 10 21 4 1
RURALC&'()
DIAGRA.
VEH.
RURALC&'()
DIAGRA.VEH.
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 33/96
2018 74 11 22 4 12#1* 77 11 23 5 22020 79 12 23 5 22021 82 12 24 5 22#22 85 12 25 5 22023 88 13 2/ 5 2
2024 91 13 27 / 22#2$ 94 14 28 / 2202/ 97 14 29 / 22#2% 101 15 30 / 22028 104 15 31 / 22029 108 1/ 32 7 22#3# 112 1/ 33 7 22031 11/ 17 34 7 22032 120 18 35 7 22#33 124 18 37 8 3
2034 128 19 38 8 3
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 34/96
N DEL TRAFICO GENERADO 2013*2034 * TRAMO 1 D. IMUS CAMION
2 E - 3 !"3 E 2 E 3 E 4 E 2S1,2S2
8 18 4 0 08 18 5 0 08 19 5 0 09 20 5 0 09 21 5 0 09 21 5 0 1
10 22 5 1 110 23 / 1 1
11 24 / 1 111 24 / 1 112 25 / 1 112 2/ / 1 113 27 7 1 113 28 7 1 114 29 7 1 114 30 7 1 115 31 8 1 11/ 33 8 1 11/ 34 8 1 117 35 9 1 118 3/ 9 1 118 37 9 1 1
CION DEL TRAFICO GENERADO 2013*2034 * TRAMO 2 D.US CAMION
2 E - 3 !"3 E 2 E 3 E 4 E 2S1,2S2
7 0 2/ 4 1 08 0 27 4 1 08 0 28 5 1 08 0 29 5 1 09 0 30 5 1 09 0 31 5 1 0
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 35/96
9 1 32 5 1 010 1 33 5 1 010 1 35 / 1 011 1 3/ / 1 011 1 37 / 1 012 1 38 / 1 0
12 1 40 / 2 013 1 41 7 2 013 1 43 7 2 014 1 44 7 2 014 1 4/ 7 2 015 1 47 8 2 01/ 1 49 8 2 01/ 1 51 8 2 017 1 53 9 2 018 1 55 9 2 0
18 1 57 9 2 0
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 36/96
ERIAL * D* PAOSSEMI TRA+LER
TOTAL LIGEROS2S3 3S1,3S2 !" 3S3
0 0
1 5 103 37
1 5 106 38
1 5 110 39
1 / 114 41
1 / 118 42
1 / 122 44
1 / 126 46
1 / 131 47
1 7 135 491 7 140 51
1 7 145 53
1 8 150 55
1 8 155 57
1 8 161 59
1 8 166 61
1 9 172 64
2 9 178 66
2 9 184 68
2 10 191 712 10 198 74
2 11 205 77
2 11 212 79
AOS * PAMPASSEMI TRA+LER
TOTAL LIGEROS2S3 3S1,3S2 !" 3S3
1 0 5 92 45
1 0 5 95 46
1 0 5 98 48
1 0 5 102 50
1 0 5 105 52
1 0 / 109 54
TOTALPESADOS
TOTALPESADOS
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 37/96
1 1 / 113 56
1 1 / 117 58
1 1 / 121 60
1 1 / 125 62
1 1 7 129 65
1 1 7 134 67
1 1 7 139 701 1 7 143 72
1 1 8 148 75
1 1 8 154 78
1 1 8 159 81
2 1 9 165 84
2 1 9 170 87
2 1 9 176 90
2 1 10 183 93
2 1 10 189 97
2 1 10 196 100
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 38/96
TOTAL
0
139
144
149
155
160
166
172
178
184191
198
205
212
220
228
236
244
253
262271
281
291
TOTAL
136
141
146
152
157
163
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 39/96
168
175
181
187
194
201
208216
223
231
240
248
257
266
276
286
296
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 40/96
PRO<EC
HORA AUTO STATION WAGON
CAMIONETAS
MICROPICK UP
2012 314 5/ 109 11 /2#13 390 70 135 14 72014 404 72 140 14 82015 418 75 145 15 82#16 432 77 150 15 82017 448 80 155 1/ 92018 4/3 83 1/1 1/ 92#1* 479 85 1// 17 92020 49/ 88 172 18 10
2021 514 92 178 18 102#22 532 95 185 19 102023 550 98 191 20 112024 5/9 102 198 20 112#2$ 589 105 205 21 12202/ /10 109 212 22 122#2% /31 113 219 23 122028 /53 117 227 24 132029 /7/ 121 235 24 132#3# 700 125 243 25 14
2031 724 129 251 2/ 142032 750 134 2/0 27 152#33 77/ 138 2/9 28 152034 803 143 279 29 1/
PRO
HORA AUTO STATION WAGON
CAMIONETAS
MICROPICK UP
2012 3/1 53 107 22 72#13 374 55 111 22 72014 387 57 114 23 82015 400 59 118 24 82#16 414 /1 123 25 82017 429 /3 127 2/ 92018 444 /5 131 27 92#1* 4/0 /7 13/ 28 9
2020 47/ 70 141 29 102021 492 72 14/ 30 10
RURALC&'()
DIAGRA.
VEH.
RURALC&'()
DIAGRA.VEH.
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 41/96
2023 527 77 15/ 32 112024 54/ 80 1/1 33 112#2$ 5/5 83 1/7 35 12202/ 585 85 173 3/ 122#2% /05 88 179 37 122028 /2/ 92 185 39 13
2029 /48 95 192 40 132#3# /71 98 198 42 142031 /94 102 205 43 142032 719 105 213 45 152#33 744 109 220 4/ 152034 770 113 228 48 1/
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 42/96
CION DEL TRAFICO TOTAL 2013*2034 * TRAMO 1 D. IMPEUS CAMION
2 E - 3 !"3 E 2 E 3 E 4 E 2S1,2S2
37 8/ 21 2 24/ 107 2/ 2 248 111 27 3 350 115 28 3 352 119 29 3 355 123 30 3 357 128 31 3 359 132 32 3 3/2 137 33 3 3
/4 142 35 3 3/7 147 3/ 3 370 152 37 4 473 158 39 4 47/ 1/3 40 4 479 1/9 41 4 482 175 43 4 48/ 182 44 4 489 188 4/ 4 593 195 48 5 5
97 202 49 5 5101 209 51 5 5105 217 53 5 5110 225 55 5 5
ECCION DEL TRAFICO TOTAL 2013*2034 * TRAMO 2 D. PAUS CAMION
2 E - 3 !"3 E 2 E 3 E 4 E 2S1,2S2
44 2 15/ 25 / 04/ 3 1/2 2/ / 0
48 3 1/7 27 / 0
50 3 173 28 7 0
52 3 180 29 7 0
55 3 18/ 30 7 0
57 3 193 31 7 0
59 3 200 32 8 0
/2 3 207 33 8 0/4 3 214 35 8 0
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 43/96
70 4 230 37 9 0
73 4 238 39 9 0
7/ 4 247 40 10 0
79 4 25/ 41 10 0
82 4 2/5 43 10 0
8/ 5 275 44 11 0
89 5 285 4/ 11 093 5 295 48 11 0
97 5 305 49 12 0
101 5 31/ 51 12 0
105 / 328 53 13 0
110 / 340 55 13 0
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 44/96
IAL * D* PAOSSEMI TRA+LER
TOTAL LIGEROS2S3 3S1,3S2 !" 3S3
4 24 496 176
5 30 616 219
5 31 638 227
5 32 660 236
/ 33 683 245
/ 35 707 254
/ 3/ 732 264
/ 37 758 274
/ 39 784 284
7 40 812 2947 42 840 306
7 43 870 317
8 45 900 329
8 47 932 341
8 49 964 354
8 50 998 368
9 52 1033 381
9 54 1069 396
9 5/ 1107 411
10 58 1146 42610 /1 1186 442
11 /3 1228 459
11 /5 1271 476
OS * PAMPASSEMI TRA+LER
TOTAL LIGEROS2S3 3S1,3S2 !" 3S3
5 2 28 550 269
5 2 29 569 279
5 3 30 589 289
5 3 31 610 300
/ 3 32 631 311
/ 3 33 653 323
/ 3 35 676 335
/ 3 3/ 700 347
/ 3 37 724 3607 3 39 750 374
TOTALPESADOS
TOTAL
PESADOS
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 45/96
7 4 42 803 402
8 4 43 832 417
8 4 45 861 433
8 4 47 891 449
8 4 48 922 466
9 4 50 955 483
9 5 52 988 5019 5 54 1023 520
10 5 5/ 1059 540
10 5 58 1096 560
11 5 /0 1134 581
11 5 /3 1174 602
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 46/96
TOTAL
672
835
865
896
928
961
996
1031
1068
11061146
1187
1229
1273
1319
1366
1415
1465
1518
15721628
1687
1747
TOTAL
818
848
878
910
942
976
1011
1047
10851124
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 47/96
1206
1249
1294
1340
1388
1438
14891543
1598
1656
1715
1776
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 48/96
ELOCIDAD PROMEDIO DE LA ONA DEL
SENTIDOTIEMPO DE DEMORA H,&(
TIPOS DE EHICULOSAu," O$'u" C($',
"$&/$ "#$%&$'( -*/% 049 106 129
"$&/$ $*+$, -*/% 044 100 105
(*/( -*/% 046 103 117V(&/$ -*? 49 36 29
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 49/96
PRO<ECTO":
L,'u6 $A&'u)(6,"
146 37<400
145 37<400
146 37<40021 37<400
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 50/96
C&'!&, %(&( C()u), EE
EH R#$ S/*+
EH R#$ D(
EH T$%*
EH T/*
FACTORES DESTRU
S!'6, T'%, !?'u),P!"," %,& E! P!"," 6E1 E2 E1
1 B2 5690 8690 100
1 B2 8330 12620 100
1 B2 7530 10530 100
1 B2 6870 10870 90
1 B2 7490 10100 1001 B2 7480 11230 100
1 B2 5930 11640 90
1 B2 7430 10290 90
1 B2 6010 11340 90
1 B2 7270 13000 100
1 B2 7860 12700 90
1 B2 6970 10890 90
1 B2 6780 10360 90
S!'6, T'%, !?'u),P!"," %,& E! P!"," 6E1 E2 E1
2 B2 3680 5680 100
2 B2 7800 10880 90
2 B2 7190 9600 110
2 B2 6870 10220 90
2 B2 7010 10450 110
2 B2 7010 10290 100
2 B2 7070 10660 90
2 B2 6550 11050 110
〖 6600(
〗4〖 ( 8160 〗4〖 ( 15100 〗
4〖
( 22900 〗4
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 51/96
CTIOS * FACTOR DE CARGA PRESION DE LLANTAS * US 2E
L)((" P. L)((" 0.9 F(,& 6! P&!"', F(,& 6! C(&( F(,& RE2 E1 E2 E1 E2 E1 E2 E1100 90 90 1.34 1.34 0.55242 1.28623 0.74025
100 90 90 1.34 1.34 2.53749 5.72106 3.40024
100 90 90 1.34 1.34 1.69435 2.77302 2.27043
90 81 81 1.14 1.14 1.17395 3.14889 1.33831
100 90 90 1.34 1.34 1.65864 2.34706 2.22257100 90 90 1.34 1.34 1.64980 3.58722 2.21073
90 81 81 1.14 1.14 0.65169 4.14049 0.74293
90 81 81 1.14 1.14 1.60613 2.52872 1.83098
90 81 81 1.14 1.14 0.68758 3.72985 0.78384
100 90 90 1.34 1.34 1.47218 6.44188 1.97273
90 81 81 1.14 1.14 2.01147 5.86752 2.29308
90 81 81 1.14 1.14 1.24381 3.17213 1.41795
90 81 81 1.14 1.14 1.11364 2.59823 1.26954
1.73028
L)((" P. L)((" 0.9 F(,& 6! P&!"', F(,& 6! C(&( F(,& RE2 E1 E2 E1 E2 E1 E2 E1100 90 90 1.3400 1.3400 0.09665 0.23476 0.12952
90 81 81 1.1400 1.1400 1.95075 3.16049 2.22386
110 99 99 1.5540 1.5540 1.40844 1.91569 2.18872
90 81 81 1.1400 1.1400 1.17395 2.46061 1.33831
110 99 99 1.5540 1.5540 1.27261 2.68970 1.97764
100 90 90 1.3400 1.3400 1.27261 2.52872 1.70530
90 81 81 1.1400 1.1400 1.31675 2.91252 1.50109
110 99 99 1.5540 1.5540 0.97004 3.36270 1.50744
1.57149
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 52/96
"u)(!F(,& T,()
E21.72355 2.46380
7.66623 11.06646
3.71585 5.98628
3.58974 4.92804
3.14507 5.367644.80688 7.01761
4.72015 5.46308
2.88274 4.71372
4.25203 5.03587
8.63212 10.60485
6.68897 8.98205
3.61623 5.03418
2.96199 4.23153
4.49243 /.22270
"u)(!F(,& T,()
E20.31458 0.44410
3.60296 5.82682
2.97698 5.16570
2.80510 4.14340
4.17980 6.15744
3.38849 5.09379
3.32027 4.82136
5.22564 6.73308
3.22/73 4.79821
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 53/96
C&'!&, %(&( C()u), EE
EH R#$ S/*+
EH R#$ D(
EH T$%*
EH T/*
FACT
S!'6, T'%, !?'u),P!"," %,& E!
E1 E21 C2 2360 2150
1 C2 2670 6390
1 C2 2800 4520
1 C2 3820 3620
1 C2 2950 38101 C2 3300 2940
1 C2 3790 13600
1 C2 2840 3250
1 C2 3470 5910
1 C2 4900 12920
1 C2 3390 3010
1 C2 2780 3520
1 C2 2070 2020
1 C2 4690 13090
1 C2 3340 7150
1 C2 5680 13290
1 C2 3810 3850
1 C2 2410 1980
1 C2 2870 2190
1 C2 3050 2680
1 C2 2840 2490
S!'6, T'%, !?'u),
P!"," %,& E!
E1 E22 C2 3150 3660
2 C2 4440 9550
2 C2 2910 2940
2 C2 3320 3490
2 C2 3210 2540
2 C2 3170 6940
2 C2 3640 5640
〖 6600(
〗4〖 ( 8160 〗4〖 ( 15100 〗
4〖 ( 22900 〗4
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 54/96
2 C2 2310 2420
2 C2 2750 2510
2 C2 4510 10220
2 C2 3710 6310
2 C2 2360 2450
2 C2 3260 2720
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 55/96
RES DESTRUCTIOS * FACTOR DE CARGA PRESION DE LLANTAS * CAMION
P!"," 6! L)((" P. L)((" 0.9 F(,& 6! P&!"',E1 E2 E1 E2 E1 E290 90 81 81 1.1400 1.1400
90 90 81 81 1.1400 1.1400
100 100 90 90 1.3400 1.3400
100 100 90 90 1.3400 1.3400
100 100 90 90 1.3400 1.340090 90 81 81 1.1400 1.1400
90 90 81 81 1.1400 1.1400
90 90 81 81 1.1400 1.1400
90 90 81 81 1.1400 1.1400
100 100 90 90 1.3400 1.3400
110 110 99 99 1.5540 1.5540
110 110 99 99 1.5540 1.5540
100 100 90 90 1.3400 1.3400
90 90 81 81 1.1400 1.1400
110 110 99 99 1.5540 1.5540
90 90 81 81 1.1400 1.1400
90 90 81 81 1.1400 1.1400
110 110 99 99 1.5540 1.5540
100 100 90 90 1.3400 1.3400
90 90 81 81 1.1400 1.1400
90 90 81 81 1.1400 1.1400
P!"," 6! L)((" P. L)((" 0.9 F(,& 6! P&!"',
E1 E2 E1 E2 E1 E2100 100 90 90 1.3400 1.3400
100 100 90 90 1.3400 1.3400
90 90 81 81 1.1400 1.1400
90 90 81 81 1.1400 1.1400
110 110 99 99 1.5510 1.5510
100 100 90 90 1.3400 1.3400
100 100 90 90 1.3400 1.3400
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 56/96
100 100 90 90 1.3400 1.3400
100 100 90 90 1.3400 1.3400
90 90 81 81 1.1400 1.1400
100 100 90 90 1.3400 1.3400
100 100 90 90 1.3400 1.3400
100 100 90 90 1.3400 1.3400
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 57/96
2 EES
F(,& 6! C(&( F(,& R!"u)(!F(,& T,()
E1 E2 E1 E20.01635 0.00482 0.01864 0.00549 0.02413
0.02678 0.37605 0.03053 0.42869 0.45923
0.03239 0.09414 0.04341 0.12615 0.16956
0.11222 0.03873 0.15038 0.05190 0.20228
0.03991 0.04753 0.05348 0.06369 0.117170.06250 0.01685 0.07125 0.01921 0.09046
0.10874 7.71605 0.12396 8.79630 8.92026
0.03428 0.02516 0.03908 0.02869 0.06777
0.07641 0.27516 0.08711 0.31369 0.40079
0.30381 6.28477 0.40711 8.42159 8.82870
0.06960 0.01851 0.10816 0.02877 0.13693
0.03148 0.03463 0.04892 0.05381 0.10273
0.00968 0.00376 0.01297 0.00503 0.01800
0.25499 6.62213 0.29068 7.54923 7.83992
0.06559 0.58947 0.10192 0.91604 1.01796
0.54855 7.03622 0.62535 8.02129 8.64664
0.11105 0.04955 0.12660 0.05649 0.18309
0.01778 0.00347 0.02763 0.00539 0.03301
0.03576 0.00519 0.04791 0.00695 0.05487
0.04561 0.01164 0.05199 0.01326 0.06526
0.03428 0.00867 0.03908 0.00988 0.04897
0.1179/ 1.//293 1.78089
F(,& 6! C(&( F(,& R!"u)(!
F(,& T,()E1 E2 E1 E20.05189 0.04047 0.06953 0.05423 0.12376
0.20481 1.87609 0.27445 2.51396 2.78840
0.03779 0.01685 0.04308 0.01921 0.06229
0.06403 0.03346 0.07299 0.03815 0.11114
0.05596 0.00939 0.08679 0.01456 0.10135
0.05322 0.52321 0.07131 0.70110 0.77242
0.09252 0.22822 0.12398 0.30582 0.42979
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 58/96
0.01501 0.00774 0.02011 0.01037 0.03047
0.03014 0.00895 0.04039 0.01200 0.05238
0.21804 2.46061 0.24856 2.80510 3.05366
0.09984 0.35757 0.13379 0.47914 0.61293
0.01635 0.00813 0.02191 0.01089 0.03280
0.05952 0.01235 0.07976 0.01654 0.09631
0.09897 0.53700 0./3598
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 59/96
C&'!&, %(&( C()u), EE
EH R#$ S/*+
EH R#$ D(
EH T$%*
EH T/*
S!'6, T'%, !?'u),P!"," %,& E!
E1 E2 E31 4E 7840 14620 14670
1 4E 8590 17620 17110
S!'6, T'%, !?'u),P!"," %,& E!
E1 E2 E32
2
〖 6600(
〗4〖 ( 8160 〗4〖 ( 15100 〗
4〖 ( 22900 〗4
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 60/96
FACTORES DESTRUCTIOS * FACTOR DE CARGA
P!"," 6! L)((" P. L)((" 0.9E4 E1 E2 E3 E4 E1 E2 E3
4520 100 100 100 100 90 90 90
670 100 100 100 100 90 90 90
P!"," 6! L)((" P. L)((" 0.9E4 E1 E2 E3 E4 E1 E2 E3
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 61/96
PRESION DE LLANTAS * CAMION 4 EES
F(,& 6! P&!"',E4 E1 E2 E3 E4 E1E2E3:-390 1.3400 1.3400 1.3400 1.3400 1.3400
90 1.3400 1.3400 1.3400 1.3400 1.3400
F(,& 6! P&!"',E4 E1 E2 E3 E4 E1E2E3:-3
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 62/96
F(,& 6! C(&( F(,& R!"u)(!F(,& T,()
E1 E2 E1 E241.99108 4.75159 2.66805 6.36713 9.03517
2.86944 5.71046 3.84505 7.65202 11.49706
3.25/55 7.00957 10.2//12
F(,& 6! C(&( F(,& R!"u)(!F(,& T,()
E1 E2 E1 E23
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 63/96
C&'!&, %(&( C()u), EE
EH R#$ S/*+
EH R#$ D(
EH T$%*
EH T/*
S!'6, T'%, !?'u),P!"," %,& E!
E1 E2 E31 2S2 5880 11530 10730
S!'6, T'%, !?'u),P!"," %,& E!
E1 E2 E32
2
〖 6600(
〗4〖 ( 8160 〗4〖 ( 15100 〗
4〖 ( 22900 〗4
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 64/96
FACTORES DESTRUCTIOS * FACTOR DE CAR
P!"," 6! L)((" P. L)((" 0.9E4 E1 E2 E3 E4 E1 E2 E3
7490 100 100 100 100 90 90 90
P!"," 6! L)((" P. L)((" 0.9E4 E1 E2 E3 E4 E1 E2 E3
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 65/96
GA PRESION DE LLANTAS * SEMITRAILER 2S2
F(,& 6! P&!"',E4 E1 E2 E3 E4 E1E2E3:-390 1.3400 1.3400 1.3400 1.3400 1.3400
F(,& 6! P&!"',E4 E1 E2 E3 E4 E1E2E3:-3
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 66/96
F(,& 6! C(&( F(,& R!"u)(!F(,& T,()
E1*S'$%)! E2*S'$%)! E1*T(6!$ E1 E230.62999 3.98618 2.11976 0.84419 5.34148 6.18566
0.84419 5.34148 /.185//
F(,& 6! C(&( ,& 6! C(& F(,& R!"u)(!F(,& T,()
E1 E2 E1 E1 E23
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 68/96
C&'!&, %(&( C()u), EE
EH R#$ S/*+
EH R#$ D(
EH T$%*
EH T/*
S!'6, T'%, !?'u),P!"," %,& E
E1 E2 E31 2S3 6750 13910 6740
S!'6, T'%, !?'u), P!"," %,& EE1 E2 E32 2S3 4660 5360 2560
2 2S3 3250 4890 1360
2 2S3 4680 6980 880
〖 6600(
〗4〖 ( 8160 〗4〖 ( 15100 〗
4〖 ( 22900 〗4
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 69/96
FACTORES DESTRUCTIOS * FACTO
! P!"," 6! L)((" P. L)(("E4 E5 E1 E2 E3 E4 E5 E1 E2 E3
12690 12280 100 100 100 100 100 90 90 90
! P!"," 6! L)((" P. L)(("E4 E5 E1 E2 E3 E4 E5 E1 E2 E32870 3010 90 90 90 90 90 81 81 81
1350 1420 90 90 90 90 90 81 81 81
2160 2450 110 110 110 110 110 99 99 99
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 70/96
DE CARGA PRESION DE LLANTAS * SEMITRAILER 2S3
0.9 F(,& 6! P&!"',E4 E5 E1 E2 E3 E4 E5 E3E4E5:-390 90 1.3400 1.3400 1.3400 1.3400 1.3400 1.3400
0.9 F(,& 6! P&!"',E4 E5 E1 E2 E3 E4 E5 E3E4E5:-381 81 1.1400 1.1400 1.1400 1.1400 1.1400 1.1400
81 81 1.1400 1.1400 1.1400 1.1400 1.1400 1.1400
99 99 1.5540 1.5540 1.5540 1.5540 1.5540 1.5540
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 71/96
F(,& 6! C(&( F(,& R!"u)(!E1*S'$%)! E2*S'$%)! E345 E1 E2 E345
1.09406 8.44399 3.67657 1.46603 11.31495 4.92661
1.4//03 11.31495 4.92//1
F(,& 6! C(&( F(,& R!"u)(!E1*S'$%)! E2*S'$%)! E345 E1 E2 E3450.24852 0.18617 0.01845 0.28332 0.21223 0.02103
0.05880 0.12897 0.00106 0.06703 0.14702 0.00121
0.25282 0.53538 0.00330 0.39288 0.83198 0.00513
0.24774 0.39708 0.00912
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 72/96
F(,& T,()
17.70759
17.70759
F(,& T,()
0.51658
0.21526
1.22999
0./5394
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 73/96
C&'!&, %(&( C()u), EE
EH R#$ S/*+
EH R#$ D(
EH T$%*
EH T/*
S!'6, T'%, !?'u),P!"," %,& E
E1 E2 E3
1 3S2 4640 3770 4440
1 3S2 5870 2980 2900
1 3S2 6310 4970 5440
1 3S2 5670 4270 4240
S!'6, T'%, !?'u),P!"," %,& E
E1 E2 E3
2 3S2 4560 3690 3580
2 3S2 7210 8260 7960
2 3S2 6870 10080 9760
〖 6600(
〗4〖 ( 8160 〗4〖 ( 15100 〗
4〖 ( 22900 〗4
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 74/96
FACTORES DESTRUCTIOS * F
! P!"," 6! L)((" P. L)(("
E4 E5 E1 E2 E3 E4 E5 E1 E2 E3
4430 3640 90 90 90 90 90 1.14 1.14 1.14
2600 2880 90 90 90 90 90 1.14 1.14 1.14
7710 5930 100 100 100 100 100 1.34 1.34 1.34
4180 4250 100 100 100 100 100 1.34 1.34 1.34
! P!"," 6! L)((" P. L)(("
E4 E5 E1 E2 E3 E4 E5 E1 E2 E3
1750 1870 90 90 90 90 90 81 81 81
9290 9840 110 110 110 110 110 81 81 81
14540 12340 100 100 100 100 100 99 99 99
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 75/96
CTOR DE CARGA PRESION DE LLANTAS * SEMITRAILER 3S2
0.9 F(,& 6! P&!"',
E4 E5 E1 E2 E3 E23:-2 E4 E5
1.14 1.14 1.1400 1.1400 1.1400 1.1400 1.1400 1.1400
1.14 1.14 1.1400 1.1400 1.1400 1.1400 1.1400 1.1400
1.34 1.34 1.3400 1.3400 1.3400 1.3400 1.3400 1.3400
1.34 1.34 1.3400 1.3400 1.3400 1.3400 1.3400 1.3400
0.9 F(,& 6! P&!"',
E4 E5 E1 E2 E3 E23:-2 E4 E5
81 81 1.1400 1.1400 1.1400 1.1400 1.1400 1.1400
81 81 1.5540 1.5540 1.5540 1.5540 1.5540 1.5540
99 99 1.3400 1.3400 1.3400 1.3400 1.3400 1.3400
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 76/96
F(,& 6! C(&( F(,& R!"u)(
E4E5:-3 E1*S'$%)! E1 E23:-2
1.1400 0.24428 0.08739 0.08158 0.27848 0.09963
1.1400 0.62572 0.02299 0.01735 0.71332 0.02621
1.3400 0.83549 0.22589 0.66581 1.11956 0.30269
1.3400 0.54470 0.10088 0.09714 0.72990 0.13518
0.71031 0.14093
F(,& 6! C(&( F(,& R!"u)(
E4E5:-3 E1*S'$%)! E1 E23:-2
1.1400 0.22787 0.05373 0.00330 0.25977 0.06125
1.5540 1.42418 1.33136 2.57604 2.21318 2.06893
1.3400 1.17395 2.98029 10.04175 1.57310 3.99359
1.348/8 2.0412/
E23:-2(6!$
E45:-2(6!$
E23:-2(6!$
E45:-2(6!$
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 77/96
!F(,& T,()
E45:-2
0.09300 0.47111
0.01978 0.75930
0.89218 2.31443
0.13017 0.99525
0.28378 1.13502
!F(,& T,()
E45:-2
0.00377 0.32479
4.00316 8.28527
13.45594 19.02263
5.8209/ 9.21090
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 78/96
C&'!&, %(&( C()u), EE
EH R#$ S/*+
EH R#$ D(
EH T$%*
EH T/*
S!'6, T'%, !?'u),P!","
E1 E2 E3
1 3S3 6660 9900 8680
1 3S3 5960 9650 9530
1 3S3 7160 9030 8460
1 3S3 6710 10650 9910
1 3S3 5210 8210 8160
1 3S3 5600 8060 8060
1 3S3 5150 6480 8550
S!'6, T'%, !?'u),P!","
E1 E2 E3
2 3S3 7140 9980 9510
2 3S3 4670 9090 97902 3S3 7030 8090 8070
2 3S3 5980 3750 3360
2 3S3 7120 9580 9410
2 3S3 6140 9640 93.6
2 3S3 7380 9120 8860
2 3S3 7150 9480 9360
2 3S3 3890 3160 3140
2 3S3 6860 9350 8730
2 3S3 6740 9150 9220
2 3S3 7150 9940 98702 3S3 6020 10200 9730
2 3S3 7120 8870 8570
2 3S3 4680 9130 8950
2 3S3 4390 3460 3980
2 3S3 4250 3260 3140
〖 6600(
〗4〖 ( 8160 〗4〖 ( 15100 〗
4〖 ( 22900 〗4
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 79/96
FACTO
,& E! P!"," 6! L)(("
E4 E5 E/ E1 E2 E3 E4 E5 E/
5710 5930 7530 100 100 100 100 100 100
11340 13880 950 100 100 100 100 100 100
10790 9670 10600 100 100 100 100 100 100
1590 13300 12360 110 110 110 110 110 110
9710 9690 8490 100 100 100 100 100 100
10460 7260 6680 100 100 100 100 100 100
5870 5480 5330 110 110 110 110 110 110
,& E! P!"," 6! L)(("
E4 E5 E/ E1 E2 E3 E4 E5 E/
10160 12720 12720 100 100 100 100 100 100
8440 12470 11000 110 110 110 110 110 11010500 9720 9360 110 110 110 110 110 110
2320 2010 9260 100 100 100 100 100 100
8680 8250 8360 100 100 100 100 100 100
6870 10790 10260 100 100 100 100 100 100
4690 12520 11740 110 110 110 110 110 110
8150 8290 8510 100 100 100 100 100 100
2580 2740 2550 100 100 100 100 100 100
8440 10110 8990 100 100 100 100 100 100
8150 9250 9110 100 100 100 100 100 100
8350 8020 8450 100 100 100 100 100 1006030 11460 11870 100 100 100 100 100 100
8360 8340 8120 100 100 100 100 100 100
10860 10440 9580 100 100 100 100 100 100
1690 1850 1720 100 100 100 100 100 100
1720 1870 1780 100 100 100 100 100 100
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 80/96
ES DESTRUCTIOS * FACTOR DE CARGA PRESION DE LLANTAS * SEMITRAI
P. L)((" 0.9
E1 E2 E3 E4 E5 E/ E1 E2 E3
90 90 90 90 90 90 1.3400 1.3400 1.3400
90 90 90 90 90 90 1.3400 1.3400 1.3400
90 90 90 90 90 90 1.3400 1.3400 1.3400
99 99 99 99 99 99 1.5540 1.5540 1.5540
90 90 90 90 90 90 1.3400 1.3400 1.3400
90 90 90 90 90 90 1.3400 1.3400 1.3400
90 90 90 90 90 90 1.5540 1.5540 1.5540
P. L)((" 0.9
E1 E2 E3 E4 E5 E/ E1 E2 E3
90 90 90 90 90 90 1.3400 1.3400 1.3400
99 99 99 99 99 99 1.5540 1.5540 1.554099 99 99 99 99 99 1.5540 1.5540 1.5540
90 90 90 90 90 90 1.3400 1.3400 1.3400
90 90 90 90 90 90 1.3400 1.3400 1.3400
90 90 90 90 90 90 1.3400 1.3400 1.3400
99 99 99 99 99 99 1.5540 1.5540 1.5540
90 90 90 90 90 90 1.3400 1.3400 1.3400
90 90 90 90 90 90 1.3400 1.3400 1.3400
90 90 90 90 90 90 1.3400 1.3400 1.3400
90 90 90 90 90 90 1.3400 1.3400 1.3400
90 90 90 90 90 90 1.3400 1.3400 1.340090 90 90 90 90 90 1.3400 1.3400 1.3400
90 90 90 90 90 90 1.3400 1.3400 1.3400
90 90 90 90 90 90 1.3400 1.3400 1.3400
90 90 90 90 90 90 1.3400 1.3400 1.3400
90 90 90 90 90 90 1.3400 1.3400 1.3400
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 81/96
ER 3S3
F(,& 6! P&!"', F(,& 6! C(&
E23:-2 E4 E5 E/ E4E5:-3 E1*S'$%)!
1.3400 1.3400 1.3400 1.3400 1.3400 1.03686 2.29232
1.3400 1.3400 1.3400 1.3400 1.3400 0.66498 2.60307
1.3400 1.3400 1.3400 1.3400 1.3400 1.38508 1.79991
1.5540 1.5540 1.5540 1.5540 1.5540 1.06835 3.43704
1.3400 1.3400 1.3400 1.3400 1.3400 0.38831 1.38130
1.3400 1.3400 1.3400 1.3400 1.3400 0.51829 1.29883
1.5540 1.5540 1.5540 1.5540 1.5540 0.37073 0.98159
F(,& 6! P&!"', F(,& 6! C(&
E23:-2 E4 E5 E/ E4E5:-3 E1*S'$%)!
1.3400 1.3400 1.3400 1.3400 1.3400 1.36967 2.77549
1.5540 1.5540 1.5540 1.5540 1.5540 0.25066 2.443991.5540 1.5540 1.5540 1.5540 1.5540 1.28720 1.31177
1.3400 1.3400 1.3400 1.3400 1.3400 0.67395 0.04916
1.3400 1.3400 1.3400 1.3400 1.3400 1.35439 2.50145
1.3400 1.3400 1.3400 1.3400 1.3400 0.74903 0.17266
1.5540 1.5540 1.5540 1.5540 1.5540 1.56333 2.01025
1.3400 1.3400 1.3400 1.3400 1.3400 1.37736 2.42335
1.3400 1.3400 1.3400 1.3400 1.3400 0.12068 0.03030
1.3400 1.3400 1.3400 1.3400 1.3400 1.16713 2.05535
1.3400 1.3400 1.3400 1.3400 1.3400 1.08759 2.19043
1.3400 1.3400 1.3400 1.3400 1.3400 1.37736 2.962311.3400 1.3400 1.3400 1.3400 1.3400 0.69217 3.03474
1.3400 1.3400 1.3400 1.3400 1.3400 1.35439 1.77942
1.3400 1.3400 1.3400 1.3400 1.3400 0.25282 2.05535
1.3400 1.3400 1.3400 1.3400 1.3400 0.19574 0.05894
1.3400 1.3400 1.3400 1.3400 1.3400 0.17194 0.03227
E23:-2(6!$
E23:-2(6!$
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 82/96
( F(,& R!"u)(!F(,& T,()
E1 E23:-2 E45/:-2
0.49107 1.38940 3.07171 0.65804 5.11914
1.70558 0.89107 3.48812 2.28548 6.66468
3.38426 1.85601 2.41188 4.53491 8.80281
2.00504 1.66022 5.34116 3.11584 10.11722
2.20015 0.52033 1.85094 2.94820 5.31947
1.28889 0.69451 1.74043 1.72712 4.16207
0.28148 0.57611 1.52538 0.43741 2.53891
1.08395 2./8084 2.2438/ /.008/5
( F(,& R!"u)(!F(,& T,()
E1 E23:-2 E45/:-2
5.84061 1.83536 3.71916 7.82641 13.38093
3.77021 0.38953 3.79797 5.85890 10.046402.78388 2.00031 2.03849 4.32615 8.36495
0.12403 0.90310 0.06587 0.16620 1.13517
1.48749 1.81488 3.35194 1.99323 7.16006
2.20963 1.00370 0.23136 2.96091 4.19596
2.55418 2.42941 3.12393 3.96920 9.52255
1.40909 1.84567 3.24729 1.88819 6.98114
0.01395 0.16171 0.04060 0.01869 0.22100
2.09177 1.56396 2.75417 2.80297 7.12110
1.79596 1.45737 2.93517 2.40659 6.79913
1.37996 1.84567 3.96949 1.84914 7.664302.70198 0.92750 4.06655 3.62065 8.61471
1.37996 1.81488 2.38442 1.84914 6.04845
3.30649 0.33878 2.75417 4.43070 7.52364
0.00278 0.26229 0.07897 0.00373 0.34500
0.00302 0.23040 0.04324 0.00405 0.27770
1.22497 2.45708 2.71939 /.40144
E45/:-2&'6!$
E45/:-2&'6!$
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 83/96
0.51 0.38
0.49 0.62
E*1AJO US 2E US 3E C2
SENTIDO 1 D. IMPERIAL * D. PAOS
IMD TOTAL*2014 25 43!?. AK, 2014 9036 15513
TASA CREC 4.20> 4.20> 3.60>
FAC DESTR. 6.2245 1.7809
2014 56243 27628
2015 114848 56250
201/ 175914 85903
2017 239546 116624
2018 305850 148450
2019 374938 1814222020 446928 215581
2021 521942 250970
2022 600107 287632
2023 681554 325615
2024 766422 364965
2025 854855 405732
202/ 947002 447966
2027 1043019 491720
2028 1143068 537050
2029 1247320 584012
2030 1355951 632664
2031 1469143 683068
2032 1587090 735286
2033 1709991 789384
2034 1838053 845430
SENTIDO 2 D. PAOS * D. IMPERIALIMD TOTAL*2014 23 68
!?. AK, 2014 8560 24915
TASA CREC 4.20> 4.20> 3.60>
FAC DESTR. 4.7982 0.6360
2014 41073 15846
2015 83872 32263
201/ 128468 49271
2017 174937 66891
2018 223358 85145
2019 273812 104056
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 84/96
2020 326385 123649
2021 381167 143946
2022 438249 164975
2023 497729 186760
2024 559707 209330
2025 624288 232712
202/ 691582 2569362027 761702 282032
2028 834766 308031
2029 910900 334966
2030 990231 362871
2031 1072894 391781
2032 1159029 421731
2033 1248782 452760
2034 1342304 484906
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 85/96
0.43 0.50 0.50 0.50 0.38
0.57 0.50 0.50 0.50 0.63
C3 C4 T2S2 T2S3 T3S2 T3S3
12 1 1 3 124231 470 472 944 4247
3.60> 3.60> 3.80> 3.80> 3.80> 3.80>
22.8143 10.2878 9.0261 17.7076 6.0086
96526 4836 4260 16713 25520
196526 9847 8681 34061 52010
300127 15038 13271 52069 79507
407458 20415 18034 70761 108048
518652 25987 22979 90163 137674
633849 31758 28112 110302 168426753193 37738 33440 131207 200347
876834 43933 38970 152906 233480
1004926 50351 44711 175429 267873
1137629 57000 50669 198809 303572
1275109 63888 56854 223077 340628
1417539 71024 63275 248267 379092
1565096 78418 69939 274414 419018
1717966 86077 76856 301555 460461
1876338 94012 84036 329727 503478
2040412 102233 91489 358970 548131
2210393 110750 99225 389324 594480
2386493 119573 107255 420831 642591
2568932 128714 115591 453536 692529
2757939 138184 124243 487484 744366
2953751 147995 133223 522721 798172
15 1 1 3 19
5641 470 472 944 7079
3.60> 3.60> 3.80> 3.80> 3.80> 3.80>
3.2800 2.8800 6.5700 5.9800 5.3000 4.7000
18503 1354 3101 5644 33270
37673 2757 6319 11503 67805
57532 4210 9659 17584 103652
78107 5715 13127 23896 140861
99422 7275 16726 30449 179484
121504 8891 20463 37250 219575
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 86/96
144382 10565 24341 44310 261189
168083 12299 28366 51638 304385
192637 14095 32545 59244 349222
218075 15957 36882 67139 395763
244429 17885 41384 75335 444072
271732 19883 46057 83842 494217
300017 21952 50908 92672 546268329321 24097 55943 101838 600297
359680 26318 61169 111352 656378
391132 28619 66594 121227 714591
423716 31004 72225 131478 775016
457473 33474 78070 142118 837737
492445 36033 84137 153163 902841
528677 38684 90435 164627 970420
566212 41430 96972 176527 1040566
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 87/96
TOTAL TOTAL EAL
9634913
231725.83 231726
472224.24 472224
721828.74 721829
980885.59 980886
1249754.27 1249754
1528807.98 15288081818434.22 1818434
2119035.24 2119035
2431028.71 2431029
2754848.24 2754848
3090944.04 3090944
3439783.51 3439784
3801851.95 3801852
4177653.20 4177653
4567710.41 4567710
4972566.71 4972567
5392786.04 5392786
5828953.94 5828954
6281678.33 6281678
6751590.44 6751590
723934/
132
48082
118792 118792
242191 242191
370376 370376
503534 503534
641859 641859
785551 785551
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 88/96
934820 934820
1089883 1089883
1250967 1250967
1418305 1418305
1592142 1592142
1772731 1772731
1960335 19603352155228 2155228
2357694 2357694
2568030 2568030
2786541 2786541
3013547 3013547
3249380 3249380
3494384 3494384
3748917 3748917
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 89/96
0.57 0.50 0.50
0.43 0.50 0.50
E*2AJO US 2E US 3E C2
SENTIDO 1 D. PAOS * PAMPAS
IMD TOTAL*2014 27 84!?. AK, 2014 9987 30557
TASA CREC 4.20> 4.20> 3.60>
FAC DESTR. 6.2245 1.7809
2014 62163 54418
2015 126937 110796
201/ 194432 169203
2017 264761 229713
2018 338044 292401
2019 414405 3573462020 493974 424629
2021 576884 494334
2022 663276 566549
2023 753297 641363
2024 847098 718871
2025 944840 799168
202/ 1046686 882357
2027 1152810 968540
2028 1263391 1057826
2029 1378617 1150326
2030 1498682 1246157
2031 1623790 1345437
2032 1754152 1448291
2033 1889990 1554848
2034 2031533 1//5241
SENTIDO 2 PAMPAS * D. PAOSIMD TOTAL*2014 21 1 84
!?. AK, 2014 7609 476 30557
TASA CREC 4.20> 4.20> 3.60>
FAC DESTR. 4.7982 4.7982 0.6360
2014 36510 2282 19434
2015 74553 4660 39568
201/ 114194 7137 60426
2017 155499 9719 82036
2018 198540 12409 104423
2019 243388 15212 127616
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 90/96
2020 290120 18133 151645
2021 338815 21176 176538
2022 389555 24347 202327
2023 442426 27652 229045
2024 497518 31095 256725
2025 554923 34683 285401
202/ 614739 38421 3151102027 677068 42317 345888
2028 742015 46376 377774
2029 809689 50606 410808
2030 880206 55013 445031
2031 953684 59605 480486
2032 1030248 64391 517218
2033 1110028 69377 555272
2034 1193159 74572 594696
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 91/96
0.57 0.60 0.50 0.50 0.39
0.43 0.40 0.50 0.50 0.61
C3 C4 T2S2 T2S3 T3S2 T3S3
15 4 3 125641 1410 0 944 4247
3.60> 3.60> 3.80> 3.80> 3.80> 3.80>
22.8143 10.2878 9.0261 17.7076 6.0086
128701 14509 0 16713 25520
262035 29540 0 34061 52010
400170 45113 0 52069 79507
543277 61246 0 70761 108048
691536 77960 0 90163 137674
845132 95275 0 110302 1684261004258 113214 0 131207 200347
1169112 131799 0 152906 233480
1339901 151053 0 175429 267873
1516839 170999 0 198809 303572
1700146 191664 0 223077 340628
1890052 213073 0 248267 379092
2086795 235253 0 274414 419018
2290621 258231 0 301555 460461
2501784 282036 0 329727 503478
2720549 306699 0 358970 548131
2947190 332249 0 389324 594480
3181990 358719 0 420831 642591
3425243 386142 0 453536 692529
3677252 414552 0 487484 744366
3938335 443985 0 522721 798172
12 3 3 18
4231 940 944 6607
3.60> 3.60> 3.80> 3.80> 3.80> 3.80>
3.2800 2.8800 6.5700 5.9800 5.3000 4.7000
13877 2708 5644 31052
28255 5513 11503 63285
43149 8419 17584 96742
58580 11430 23896 131470
74566 14550 30449 167519
91128 17781 37250 204937
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 92/96
108286 21129 44310 243777
126062 24597 51638 284093
144478 28191 59244 325941
163556 31913 67139 369379
183322 35770 75335 414467
203799 39766 83842 461270
225013 43905 92672 509850246991 48193 101838 560277
269760 52636 111352 612620
293349 57239 121227 666952
317787 62007 131478 723348
343105 66947 142118 781888
369334 72065 153163 842652
396507 77367 164627 905725
424659 82860 176527 971195
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 93/96
TOTAL TOTAL EAL
14552786
302025.10 302025
615380.55 615381
940493.12 940493
1277805.72 1277806
1627778.01 1627778
1990887.06 19908872367627.98 2367628
2758514.64 2758515
3164080.34 3164080
3584878.59 3584879
4021483.86 4021484
4474492.38 4474492
4944522.97 4944523
5432217.87 5432218
5938243.71 5938244
6463292.34 6463292
7008081.87 7008082
7573357.62 7573358
8159893.18 8159893
8768491.48 8768491
939998/
141
51363
111507 111507
227335 227335
347652 347652
472631 472631
602455 602455
737313 737313
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 94/96
877399 877399
1022919 1022919
1174083 1174083
1331111 1331111
1494232 1494232
1663683 1663683
1839710 18397102022571 2022571
2212532 2212532
2409869 2409869
2614870 2614870
2827833 2827833
3049070 3049070
3278904 3278904
3517669 3517669
7/17/2019 excel PAMPAS.xlsx
http://slidepdf.com/reader/full/excel-pampasxlsx 95/96
E*1AJO US 2E US 3E C2
SENTIDO 1 D. IMPERIAL * D. PAOSFAC DESTR. 6.2245 1.7809
SENTIDO 2 D. PAOS * D. IMPERIALFAC DESTR. 4.7982 0.6360
E*2AJO US 2E US 3E C2
SENTIDO 1 D. PAOS * PAMPASFAC DESTR. 6.2245 1.7809
SENTIDO 2 PAMPAS * D. PAOS
FAC DESTR. 4.7982 4.7982 0.6360
Top Related