excel PAMPAS.xlsx

96
FACTORES CORRECCION HUACRAPUQUIO MES LIGEROS PESADOS ENERO 1.14591 1.131484 FEBRERO 1.126689 1.098464 MARZO 1.098177 1.031785 ABRIL 1.093328 0.987853 MA Y O 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  TOT AL 1 1 FCEL=0.937517 FCEP=0.984842

Transcript of excel PAMPAS.xlsx

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 14/96

9

143

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 67/96

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

7/17/2019 excel PAMPAS.xlsx

http://slidepdf.com/reader/full/excel-pampasxlsx 96/96

C3 C4 T2S2 T2S3 T3S2 T3S3

22.8143 10.2878 9.0261 17.7076 6.0086

3.2800 2.8800 6.5700 5.9800 5.3000 4.7000

C3 C4 T2S2 T2S3 T3S2 T3S3

22.8143 10.2878 9.0261 17.7076 6.0086

3.2800 2.8800 6.5700 5.9800 5.3000 4.7000