copia de sbtpo_mayo_2015_a (4) (autoguardado).xls
TRANSCRIPT
SOBRETIEMPOS DEPARTAMENTO MANTENIMIENTO EQUIPO REMOLCADO
CARROCERIA UN MAESTRANZA UN
MATR PATERNO MATERNO NOMBRE BASICO FECHA OS
18647 Choqueticlla Mallco Juan 3,997.99
18647
18647
18647
18647
18647
18647
Total 18647 Jchoqueticlla
13278 Coa Choque Mario 3,047.38
13278
13278
13278
13278
13278
13278
Total 13278 Mcoa
60395 Yucra Choque Wenceslao 3,299.46
60395
60395
60395
60395
60395
60395
Total 60395 WChoque
23382 Mamani Cristian 1,966.89
23382
23382
23382
23382
23382
23382
Total 23382 CMamani
23416 Zuazo Murillo Eliseo 1,951.29
23416
23416
23416
23416
23416
23416
Total 23416 EZuazo
23384 Tancara Alba Matin 2,005.49
23384
23384
23384
23384
23384
23384
Total 23384 MTancara
23340 Segovia Aguilar Marco Antonio 2,109.48
23340
23340
23340
23340
23340
23340
Total 23340 Msegovia
23349 Gutierrez Alfaro Sergio G. 2,509.00
23349
23349
23349
23349
23349
23349
Total 23340 Sgutierrez
23396 Huayta Choque Benjamin 2,005.49
23396
23396
23396
23396
23396
23396
Total 18815
18406 Martinez Arias Luis 3,199.00
18406
18406
18406
18406
18406
18406
Total 18891
23050 Villca Alanoca Desiderio 3,299.46
23050
23050
23050
23050
23050
Total 19548
23427 Quispe Cruz Oscar 1,951.29
23427
23427
23427
23427
23427
23427 2,958.17
Total 20565
23407 Montoya Osorio Edmundo 1,951.29
23407
23407
23407
23407
23407
23407
Total 20943
23054 Ricaldi FernandeEliodoro 2,998.09
23054
23054
23054
23054
23054
23054
Total 23054
23289 Tito Cordova Marcos 2,247.88
23289
23289
23289
23289
23289
23289
Total 23157
23071 Ramos Colque German 3,099.17
23071
23071
23071
23071
23071
23071
Total 23218
23251 Choque Quispe Juan Manuel 2,240.37
23251
23251
23251
23251
23251
23251
Total 23221
23104 Valeriano Heredia Rene 2,890.80
Total 23222
60219 Parina Aguilar Victor 3,100.10
60219
60219
60219
60219
60219
60219
Total 23225
23354 Choqueticlla Zarate Luis Miguel 1,951.29
23354
23354
23354
23354
23354
23354
Total 23226
16007 Aguilar Heredia Galo 3,676.19
16007
16007
16007
16007
16007
16007
Total 23228
13231 Heredia Mamani Miguel Angel 3,698.18
13231
13231
13231
13231
13231
13231
Total 23229
23488 Mamani Callpa Gonzalo 1,800.00
23488
23488
23488
23488
23488
23488
Total 23233
23356 Mendoza Montoya Marcelo E. 1,951.29
23356
23356
23356
23356
23356
23356
23356
23356
23356
23356
23356
23356
23356
Total 23234
50226 Juchazara Copa Luciano 2,398.48
50226
50226
50226
50226
50226
50226
Total 23293
23451 Mamani Cabello Marco 1,800.00
23451
23451
23451
23451
23451
23451
Total 23362
4920 Huaylla Ramos German 3,199.00
4920
4920
4920
4920
4920
4920
Total 23376
90343 Velazques Carlos Alfredo 2,000.00
90343
90343
90343
90343
90343
90343
90343
Total 23377
90344 Ramirez Pinto Juan 2,000.00
90344
90344
90344
90344
90344
90344
Total 23378
23497 Cruz Condori Rudy 1,800.00
23497
23497
23497
23497
23497
23497
Total 23380
90334 Cumaly Jusue 1,800.00
90334 1,800.00
90334 1,800.00
90334 1,800.00
90334 1,800.00
90334 1,800.00
Total 23385
23393 Viscarra Aquino David Mamerto 1,782.00
23393 1,782.00
23393 1,782.00
23393 1,782.00
23393 1,782.00
23393 1,782.00
23393 1,782.00
Total 23393
23397 Cojintos 1,782.00
23397 Autorizado R. Tovar 1,782.00
23397 Autorizo R. Tovar 1,782.00
23397 Autorizo R. Tovar 1,782.00
Total 23397
23402 Quispe Cabas Luis Alberto 1,782.00
23402 1,782.00
23402 Autorizado C. Giraldez 1,782.00
23402 1,782.00
23402 Autorizado C. Giraldez 1,782.00
23402 Autorizado C.Giraldez 1,782.00
23402 1,782.00
23402 Autorizado C.Giraldez 1,782.00
23402 Autorizo V. Beltran 1,782.00
Total 23402
23434 José Luis Canaviri Mondaca 1,540.00
23434 Autorizado C.Giraldez 1,540.00
23434 Autorizo C. Giraldez 1,540.00
23434 1,540.00
Total 23434
23471 Colque Aguilar Nelson 1,350.00
23471 Autorizo C. Giraldez 1,350.00
23471 Autorizado C.Giraldez 1,350.00
23471 Autorizado C.Giraldez 1,350.00
23471 Autorizo C. Giraldez 1,350.00
23471 Autorizo C. Giraldez 1,350.00
23471 Autorizo C. Giraldez 1,350.00
Total 23471
60032 Torrez Quispe Juan Carlos 3,195.28
60032 Autorizo C. giraldez 3,195.28
60032 Autorizo V. Beltran 3,195.28
60032 Autorizo V. Beltran 3,195.28
60032 Autorizo V. Beltran 3,195.28
60032 Autorizo V. Beltran 3,195.28
60032 Autorizo V. Beltran 3,195.28
60032 Autorizo C. giraldez 3,195.28
Total 60032
23482 Jesus Alberto PairumanEspinoza 1440
23482 Autorizado C.Giraldez 1440
23482 Autorizado C.Giraldez 1440
23482 Autorizo C. Giraldez 1440
23482 Autorizado C.Giraldez 1440
Total 2348223483 Rodrigo Limachi Poma 1440
23483 Autorizado C. Giraldez 1440
23483 Autorizado C.Giraldez 1440
23483 1440
23483 1440
23483 Autorizado C.Giraldez 1440
23483 1440
23483 Autorizo V. Beltran 1440
23483 1440
Total 2348323489 Luis B. Perez Gutierrez 1440
23489 Autorizo R. Tovar 1440
23489 Autorizo C. Giraldez 1440
23489 Autorizo V. Beltran 1440
23489 Autorizo V. Beltran 1440
Total 2348950924 Limachi Jimenez Elias 2,156.00
50924 Autorizo C. Giraldez 2,156.00
50924 2,156.00
Total 50924
90338 Rodriguez Quiróz Oliver 1440
90338 Autorizo R. Tovar 1440
Total 90338
90339 Quispe Laura Juan José 1440
90339 Autorizo V. Beltran 1440
90339 Autorizo V. Beltran 1440
90339 Autorizo V. Beltran 1440
90339 Autorizo C. giraldez 1440
Total 90339
90340 Jimenez Callisaya Cesar 1440
90340 Autorizo R. Tovar 1440
Total 90340
Total general
SOBRETIEMPOS DEPARTAMENTO MANTENIMIENTO EQUIPO REMOLCADO
CARROCERIA AV CARROCERIA OR CARROCERIA VZ
by DSanchez
TRABAJO REALIZADO AUTORIZO A HRS TOTAL Bs.
17:00 21:00 4:00 133.27
17:00 22:00 5:00 0.00
17:00 21:00 4:00 0.00
17:00 21:00 4:00 0.00
17:00 133.27
16:30 18:30 2:00 50.79
16:30 19:30 3:00 0.00
5:00 50.79
16:30 18:00 1:30 41.24
1:30 41.24
16:30 21:30 5:00 81.95
16:30 0:00 7:30 0.00
16:30 23:30 7:00 0.00
16:30 21:30 5:00 0.00
8:00 14:00 6:00 0.00
16:30 20:30 4:00 0.00
16:30 18:00 1:30 0.00
36:00 81.95
16:30 18:00 1:30 24.39
16:30 18:30 2:00 0.00
DE HRS TOTAL HRS
16:30 20:00 3:30 0.00
16:30 20:30 4:00 0.00
11:00 24.39
16:30 20:00 3:30 58.49
16:30 20:00 3:30 0.00
16:30 20:30 4:00 0.00
11:00 58.49
16:30 18:30 2:00 35.16
16:30 18:30 2:00 0.00
16:30 18:30 2:00 0.00
16:30 18:30 2:00 0.00
16:30 18:00 1:30 0.00
9:30 35.16
16:30 19:30 3:00 62.73
16:30 19:30 3:00 0.00
16:30 20:00 3:30 0.00
16:30 20:00 3:30 0.00
9:00 11:00 2:00 0.00
16:30 19:30 3:00 0.00
11:30 14:00 2:30 0.00
20:30 62.73
8:00 13:00 5:00 83.56
16:30 21:30 5:00 0.00
16:30 21:30 5:00 0.00
16:30 20:30 4:00 0.00
16:30 19:30 3:00 0.00
22:00 83.56
16:30 20:00 3:30 93.30
16:30 19:30 3:00 0.00
16:30 19:30 3:00 0.00
9:30 93.30
16:30 19:30 3:00 82.49
16:30 19:30 3:00 0.00
16:30 19:30 3:00 0.00
18:00 23:00 5:00 0.00
16:30 19:30 3:00 0.00
7:00 13:30 6:30 0.00
23:30 82.49
16:30 0:00 7:30 121.96
0:00 1:30 1:30 36.98
9:00 158.93
16:30 21:00 4:30 73.17
16:30 19:30 3:00 0.00
16:30 19:45 3:15 0.00
16:30 19:30 3:00 0.00
16:30 18:30 2:00 0.00
16:30 20:30 4:00 0.00
8:15 13:30 5:15 0.00
25:00 73.17
16:30 19:30 3:00 74.95
16:30 19:30 3:00 0.00
16:30 19:30 3:00 0.00
16:30 19:30 3:00 0.00
8:00 10:00 2:00 0.00
14:00 18:00 4:00 0.00
16:30 19:30 3:00 0.00
21:00 74.95
16:30 19:55 3:25 64.00
16:30 20:05 3:35 0.00
16:30 20:00 3:30 0.00
16:30 19:30 3:00 0.00
16:30 20:30 4:00 0.00
16:30 20:00 3:30 0.00
22:00 23:00 1:00 0.00
22:00 64.00
16:30 19:30 3:00 77.48
16:30 19:40 3:10 0.00
19:00 20:00 1:00 0.00
5:00 22:00 17:00 0.00
16:30 19:30 3:00 0.00
16:30 20:00 3:30 0.00
30:40 77.48
18:00 20:30 2:30 46.67
5:00 23:00 18:00 0.00
20:30 46.67
16:30 21:30 5:00 120.45
5:00 120.45
17:30 19:30 2:00 51.67
16:30 19:30 3:00 0.00
16:30 19:30 3:00 0.00
16:30 20:00 3:30 0.00
16:30 20:00 3:30 0.00
16:30 20:00 3:30 0.00
8:00 14:00 6:00 0.00
24:30 51.67
21:40 22:40 1:00 16.26
16:30 19:30 3:00 0.00
16:30 19:30 3:00 0.00
7:00 16.26
16:30 18:30 2:00 61.27
7:45 12:15 4:30 0.00
16:30 18:30 2:00 0.00
8:30 61.27
20:00 0:00 4:00 123.27
0:00 3:00 3:00 0.00
10:00 14:00 4:00 0.00
16:30 20:00 3:30 0.00
16:30 20:00 3:30 0.00
16:30 20:00 3:30 0.00
16:30 21:00 4:30 0.00
26:00 123.27
20:00 0:00 4:00 60.00
0:00 3:20 3:20 0.00
18:30 22:00 3:30 0.00
16:30 19:00 2:30 0.00
16:30 22:10 5:40 0.00
16:30 18:00 1:30 0.00
16:30 20:00 3:30 0.00
24:00 60.00
16:30 20:00 3:30 56.91
16:30 19:30 3:00 0.00
16:30 20:00 3:30 0.00
16:30 20:00 3:30 0.00
16:30 19:30 3:00 0.00
16:30 19:30 3:00 0.00
16:30 21:30 5:00 0.00
8:30 13:00 4:30 0.00
17:00 20:00 3:00 0.00
16:30 19:30 3:00 0.00
16:30 20:00 3:30 0.00
16:30 19:30 3:00 0.00
16:30 20:00 3:30 0.00
16:30 18:30 2:00 0.00
47:00 56.91
16:30 18:30 2:00 39.97
0:30 8:00 7:30 0.00
16:30 22:00 5:30 0.00
16:30 19:30 3:00 0.00
18:00 39.97
21:40 22:40 1:00 15.00
16:30 21:30 5:00 0.00
16:30 18:30 2:00 0.00
14:30 15:30 1:00 0.00
16:30 18:30 2:00 0.00
16:30 21:30 5:00 0.00
16:00 15.00
20:00 0:00 4:00 106.63
0:00 3:00 3:00 0.00
18:00 18:00 0:00 0.00
21:30 22:30 1:00 0.00
16:30 19:30 3:00 0.00
16:30 19:30 3:00 0.00
16:30 19:30 3:00 0.00
17:00 106.63
16:30 18:30 2:00 33.33
16:30 19:00 2:30 0.00
22:00 23:00 1:00 0.00
18:00 23:00 5:00 0.00
16:30 19:30 3:00 0.00
16:30 21:30 5:00 0.00
18:30 33.33
16:30 18:30 2:00 33.33
16:30 21:30 5:00 0.00
7:00 33.33
8:40 15:10 6:30 97.50
22:00 23:00 1:00 0.00
7:30 97.50
16:30 21:30 5:00 75.00
16:30 20:30 4:00 60.00
16:30 18:30 2:00 30.00
16:30 19:30 3:00 45.00
14:00 210.00
16:30 21:30 5:00 74.25
16:30 0:00 7:30 111.38
0:00 2:30 2:30 37.13
5:00 8:00 3:00 44.55
18:20 20:05 1:45 25.99
16:30 20:30 4:00 59.40
16:30 20:30 4:00 59.40
27:45 412.09
16:30 21:30 5:00 74.25
16:30 20:30 4:00 59.40
16:30 18:30 2:00 29.70
16:30 18:30 2:00 29.70
13:00 193.05
10:30 14:00 3:30 51.98
21:30 22:30 1:00 14.85
16:30 20:00 3:30 51.98
21:30 22:00 0:30 7.43
16:30 20:00 3:30 51.98
16:30 20:00 3:30 51.98
16:30 17:30 1:00 14.85
16:30 21:00 4:30 66.83
16:30 19:30 3:00 44.55
24:00 356.40
16:30 21:30 5:00 64.17
16:30 18:30 2:00 25.67
16:30 18:30 2:00 25.67
16:30 21:30 5:00 64.17
14:00 179.67
16:30 21:00 4:30 50.63
16:30 21:30 5:00 56.25
16:30 20:00 3:30 39.38
16:30 19:30 3:00 33.75
16:30 20:00 3:30 39.38
16:30 20:30 4:00 45.00
8:00 14:30 6:30 73.13
30:00 337.50
16:30 18:25 1:55 51.04
9:00 11:20 2:20 62.13
16:30 19:30 3:00 79.88
8:15 12:30 4:15 113.17
13:00 16:20 3:20 88.76
8:20 12:00 3:40 97.63
13:00 16:30 3:30 93.20
9:30 11:30 2:00 53.25
24:00 639.06
16:30 19:30 3:00 36.00
16:30 19:30 3:00 36.00
16:30 19:30 3:00 36.00
16:30 19:30 3:00 36.00
7:00 10:00 3:00 36.00
15:00 180.00
16:30 20:00 3:30 42.00
16:30 20:00 3:30 42.00
16:30 20:00 3:30 42.00
23:30 0:00 0:30 6.00
0:00 1:00 1:00 12.00
16:30 21:00 4:30 54.00
22:00 0:00 2:00 24.00
16:30 19:30 3:00 36.00
19:00 20:00 1:00 12.00
22:30 270.00
16:30 20:00 3:30 42.00
16:30 18:30 2:00 24.00
16:30 18:30 2:00 24.00
16:30 19:30 3:00 36.00
16:30 20:00 3:30 42.00
14:00 168.00
16:30 19:00 2:30 44.92
16:30 21:30 5:00 89.83
16:30 20:00 3:30 62.88
11:00 197.63
16:30 20:00 3:30 42.00
16:30 20:30 4:00 48.00
7:30 90.00
16:30 19:30 3:00 36.00
16:30 18:30 2:00 24.00
16:30 19:30 3:00 36.00
16:30 18:30 2:00 24.00
16:30 19:30 3:00 36.00
13:00 156.00
16:30 20:00 3:30 42.00
16:30 20:30 4:00 48.00
7:30 90.00
757:55 5537.59
OS HRS BS
BM 0:00 0.00
LDE-955 0:00 0.00
LDE-962 0:00 0.00
FERRO-337 0:00 0.00
RE-MT 0:00 #VALUE!
RA-10123 0:00 0.00
MN-FB341 0:00 0.00
| MANT-LDEs 0:00 0.00
MN-GEWAR 0:00 0.00
MN-VIACHA 0:00 0.00TOTAL 0:00 #VALUE!
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
BM LDE-
955
LDE-962 FERRO-
337
RE-MT
RA-10123 MN-
FB341
MANT-LDE
s
MN-GEWAR MN-
VI-ACHA
0.00
0.10
0.20
0.30
0.40
0.50
0.60
0.70
0.80
0.90
1.00
RESUMEN SBTPO MAYO 2015
BS
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
BM LDE-
955
LDE-962 FERRO-
337
RE-MT
RA-10123 MN-
FB341
MANT-LDE
s
MN-GEWAR MN-
VI-ACHA
0.00
0.10
0.20
0.30
0.40
0.50
0.60
0.70
0.80
0.90
1.00
RESUMEN SBTPO MAYO 2015
BS
FECHAS PROCESOS CARROCEROS
4 22-jun-15 22-jul-15 22-ago-15 22-sep-15 22-oct-15 22-nov-15 730 23-jun-15 23-jul-15 23-ago-15 23-sep-15 23-oct-15 23-nov-15 424 24-jun-15 24-jul-15 24-ago-15 24-sep-15 24-oct-15 24-nov-15 722 25-jun-15 25-jul-15 25-ago-15 25-sep-15 25-oct-15 25-nov-15 7
5 26-jun-15 26-jul-15 26-ago-15 26-sep-15 26-oct-15 26-nov-15 56 27-jun-15 27-jul-15 27-ago-15 27-sep-15 27-oct-15 27-nov-15 6
21 28-jun-15 28-jul-15 28-ago-15 28-sep-15 28-oct-15 28-nov-15 98 29-jun-15 29-jul-15 29-ago-15 29-sep-15 29-oct-15 29-nov-15 59 30-jun-15 30-jul-15 30-ago-15 30-sep-15 30-oct-15 30-nov-15 8
20 1-jul-15 31-jul-15 31-ago-15 1-oct-15 31-oct-15 1-dic-15 65 2-jul-15 01-ago-15 1-sep-15 2-oct-15 1-nov-15 2-dic-15 35 3-jul-15 02-ago-15 2-sep-15 3-oct-15 2-nov-15 3-dic-15 4
22 4-jul-15 03-ago-15 3-sep-15 4-oct-15 3-nov-15 4-dic-15 512 5-jul-15 04-ago-15 4-sep-15 5-oct-15 4-nov-15 5-dic-15 1129 6-jul-15 05-ago-15 5-sep-15 6-oct-15 5-nov-15 6-dic-15 1525 7-jul-15 06-ago-15 6-sep-15 7-oct-15 6-nov-15 7-dic-15 1617 8-jul-15 07-ago-15 7-sep-15 8-oct-15 7-nov-15 8-dic-15 1718 9-jul-15 08-ago-15 8-sep-15 9-oct-15 8-nov-15 9-dic-15 1819 10-jul-15 09-ago-15 9-sep-15 10-oct-15 9-nov-15 10-dic-15 1215 11-jul-15 10-ago-15 10-sep-15 11-oct-15 10-nov-15 11-dic-15 414 12-jul-15 11-ago-15 11-sep-15 12-oct-15 11-nov-15 12-dic-15 3
5 13-jul-15 12-ago-15 12-sep-15 13-oct-15 12-nov-15 13-dic-15 422 14-jul-15 13-ago-15 13-sep-15 14-oct-15 13-nov-15 14-dic-15 520 15-jul-15 14-ago-15 14-sep-15 15-oct-15 14-nov-15 15-dic-15 228 16-jul-15 15-ago-15 15-sep-15 16-oct-15 15-nov-15 16-dic-15 1116 17-jul-15 16-ago-15 16-sep-15 17-oct-15 16-nov-15 17-dic-15 2627 18-jul-15 17-ago-15 17-sep-15 18-oct-15 17-nov-15 18-dic-15 2728 19-jul-15 18-ago-15 18-sep-15 19-oct-15 18-nov-15 19-dic-15 2829 20-jul-15 19-ago-15 19-sep-15 20-oct-15 19-nov-15 20-dic-15 1211 21-jul-15 20-ago-15 20-sep-15 21-oct-15 20-nov-15 21-dic-15 614 21-ago-15 21-sep-15 21-nov-15 3
4 410 224 311 1127
1214 6
6 35 58 57 2
18 115
PROCESOS CARROCEROS PROCESOS MAESTRANZA
Atencion Trenes Nocturno 0Atencion Trenes Tardero 2Atencion descarrilamineto Vagones 3Atencion descarrilamiento LDEs 4Reemplazo carroceros Avaroa 5Reempplazo carrocero MSC 6Reemmplazo carrocero Villazon 7Remplazo carrocero Agua Castilla 8Reemplazo carrocero Potosí 9Reemplazo carrocero Rio Mulatos 10Reemplazo carroceros Viacha 11Mantenimiento MP 12
13141516171819202122232425262728293031323334353637383940414243444546
PROCESOS MAESTRANZA AUTORIZA
Torneado de ruedas 2 R ChoqueribeRellenado de pestañas 2 D. SanchezCalado de ruedas 1 M. CarreteroTorneado de piezas 2 M. HerediaAjuste de ruedas 2 J. ChoqueticllaInspeccion por Ultrasonido 1
721
Soldar planchas abatibles gondolas 2Soldar planchas laterales bodega 2Cortar ruedas con oxigeno 1Amolar plachas 1Soldar la vigas, perfiles 2
3
Rellenado de piezas de timoneria B 1Rellenado de piezas de timoneria PPC 3
12221
Reparacion ollas MSC 1Reparacion PPC FCAB 3Reparacion bodegas FCAB 2Reparacion Balasteros 1Reparacion Tankes 1Maniobras Tracmovil 2Mantenimiento de maquinas herramientas equipos 3Limpieza de maq. Herra Equipos
Reparacion de valvulas de control 1Reparacion de Cilindros de freno 3Cambio de Valvulas de 3/4 2Prueba de aire 1Hermetizacion de Cañerias y acces 1Doblado de cañerias 1Colocado de mangueras 3