Spreadsheet: 49439d1248795612-help-with-advanced-filters-and-sumifs-example
Sheet: Sheet1

Clase orden | Orden | Notificación | Fecha contab. | Contador | Nº personal | Empleados | Hora inic.real | Hora fin real | Trabajo real | Texto notific. | Ubicac.técnica | Status sistema
PM99 | 83477372 | [PHONE] | 2008-07-04 00:00:00 | 00000002 | 00310667 | Employee name | 20:00:00 | 21:30:49 | 1.5 | Se endereza plataforma desalineada y se | 0380-EMPA | NOTP CTEC
PM99 | 83477372 | [PHONE] | 2008-07-04 00:00:00 | 00000001 | 00308350 | Employee name | 20:00:00 | 21:30:19 | 1.5 | Se endereza plataforma desalineada y se | 0380-EMPA | NOTP CTEC
PM99 | 83477373 | [PHONE] | 2008-07-04 00:00:00 | 00000001 | 00310667 | Employee name | 15:00:00 | 17:30:28 | 2.5 | se quita la camiza dañada para poder end | 0380-EMPA | NOTP CTEC
PM99 | 83477378 | [PHONE] | 2008-07-04 00:00:00 | 00000001 | 00308350 | Employee name | 18:00:00 | 18:30:20 | 0.5 | se [NAME] contactores y se lijaron | 0380-EMPA | NOTP CTEC
PM02 | 83400373 | [PHONE] | 2008-07-05 00:00:00 | 00000001 | 00313122 | Employee name | 02:00:38 | 04:00:15 | 2 | SE INSPECCIONO ELECTROMECANICANMENTE | 0380-EMPA | NOTP CTEC
PM02 | 83413016 | [PHONE] | 2008-07-05 00:00:00 | 00000001 | 00313122 | Employee name | 14:00:43 | 22:00:21 | 8 | SEINSPECCIONO LÍNEA EN GENERAL | 0380-EMPA | NOTP CTEC
PM01 | 83459414 | [PHONE] | 2008-07-05 00:00:00 | 00000018 | 00310101 | Employee name | 00:00:00 | 06:00:00 | 6 | SE ARREGLAN FALLAS VARIAS | 0380-EMPA | NOTP CTEC
PM01 | 83459414 | [PHONE] | 2008-07-05 00:00:00 | 00000020 | 00310101 | Employee name | 22:00:00 | 23:59:00 | 2 | SE ARREGLAN FALLAS VARIAS | 0380-EMPA | NOTP CTEC
PM01 | 83459414 | [PHONE] | 2008-07-05 00:00:00 | 00000017 | 00310498 | Employee name | 00:00:00 | 06:00:00 | 6 | [NAME]  FALLAS EN CORRECTIVO | 0380-EMPA | NOTP CTEC
PM01 | 83459414 | [PHONE] | 2008-07-05 00:00:00 | 00000019 | 00310498 | Employee name | 22:00:00 | 23:59:00 | 2 | SE CORRIGEN FALLAS VARIAS | 0380-EMPA | NOTP CTEC
PM01 | 83460756 | [PHONE] | 2008-07-05 00:00:00 | 00000007 | 00308350 | Employee name | 14:00:00 | 22:00:00 | 8 | SE APOYA EN EL AREA DE MANTENIMIENTO EMP | 0380-EMPA | NOTP CTEC
PM01 | 83462568 | [PHONE] | 2008-07-05 00:00:00 | 00000001 | 00308356 | Employee name | [NAME] | 14:00:28 | 8 | SE REPARA 5 VALVULAS Y SE COLOCAN EN EL | 0380-EMPA | NOTP CTEC
PM01 | 83465899 | [PHONE] | 2008-07-05 00:00:00 | 00000008 | 00310074 | Employee name | 06:00:00 | 14:00:00 | 7.5 | SE APOYO PARA CHECAR TRANSPORTADOR DE BO | 0380-EMPA | NOTP CTEC
PM01 | 83466368 | [PHONE] | 2008-07-05 00:00:00 | 00000007 | 00312994 | Employee name | 06:00:00 | 14:45:00 | 8 | se coordinó correctivo | 0380-EMPA | NOTP CTEC
PM01 | 83466372 | [PHONE] | 2008-07-05 00:00:00 | 00000006 | 00310353 | Employee name | 06:00:00 | 13:42:16 | 7.5 | FABRICO GUIA DE NAYLAMY PARA PAPEL METAL | 0380-EMPA | NOTP CTEC
PM01 | 83478224 | [PHONE] | 2008-07-05 00:00:00 | 00000001 | 00316386 | Employee name | 06:00:02 | 13:25:53 | 8 | Se reparan depositos de aceite y se rell | 0380-EMPA | NOTP CTEC
PM01 | 83459414 | [PHONE] | 2008-07-06 00:00:00 | 00000022 | 00310101 | Employee name | 00:00:00 | 06:00:00 | 6 | se arreglan faLLAS EN CORRECTIVO | 0380-EMPA | NOTP CTEC
PM01 | 83459414 | [PHONE] | 2008-07-06 00:00:00 | 00000021 | 00310498 | Employee name | 00:00:00 | 06:00:00 | 6 | [NAME] correctivos | 0380-EMPA | NOTP CTEC
PM01 | 83460756 | [PHONE] | 2008-07-06 00:00:00 | 00000008 | 00308350 | Employee name | 14:00:00 | [NAME] | 7 | SE APOYA EN EL AREA DE MANTENIMIENTO EMP | 0380-EMPA | NOTP CTEC
PM99 | 83476502 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00301953 | Employee name | 23:30:49 | 00:30:29 | 1 | se baja tubo y [NAME] mon | 0380-EMPA | NOTP CTEC
PM99 | 83476505 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00301953 | Employee name | 23:00:37 | 23:30:14 | 0.5 | [NAME] y paraemetro de reatardo | 0380-EMPA | NOTP CTEC
PM99 | 83476512 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00301953 | Employee name | 02:00:59 | 02:30:18 | 0.5 | se coloca y [NAME] insertador | 0380-EMPA | NOTP CTEC
PM99 | 83476514 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00301953 | Employee name | 03:00:38 | 03:30:21 | 0.5 | [NAME] y se ajus | 0380-EMPA | NOTP CTEC
PM99 | 83476518 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00301953 | Employee name | 04:30:32 | 06:00:03 | 1.5 | se reviza clucht y se baja [NAME] | 0380-EMPA | NOTP CTEC
PM01 | 83478522 | [PHONE] | 2008-07-06 00:00:00 | 00000010 | 00310101 | Employee name | 22:00:00 | 23:59:00 | 2 | SE ARREGLAN FALLAS VARIAS | 0380-EMPA | NOTP CTEC
PM01 | 83478522 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00310498 | Employee name | 22:00:00 | 23:59:00 | 2 | SE ARREGLA FALLAS VARIAS CORRECTIVAS | 0380-EMPA | NOTP CTEC
PM01 | 83478522 | [PHONE] | 2008-07-06 00:00:00 | 00000002 | 00310498 | Employee name | 00:00:00 | 06:00:00 | 6 | SE ARREGLAN FALLAS CORRECTIVAS | 0380-EMPA | NOTP CTEC
PM01 | 83478522 | [PHONE] | 2008-07-06 00:00:00 | 00000003 | 00310498 | Employee name | 22:00:00 | 23:59:00 | 2 | SE CORRIGEN FALLAS VARIAS | 0380-EMPA | NOTP CTEC
PM99 | 83479108 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00310529 | Employee name | 06:00:00 | 06:30:00 | 0.5 | SE CAMBIO CONECTOR DAÑADO DE MANGUERA D | 0380-EMPA | NOTP CTEC
PM99 | 83479109 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00310529 | Employee name | 11:00:00 | 14:00:00 | 3 | SE REVIZO CABLE USO RUDO ALIM. [NAME] | 0380-EMPA | NOTP CTEC
PM99 | 83479221 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00310529 | Employee name | 08:45:00 | 09:15:00 | 0.5 | SE RESTABLECE ARRANCADOR Y ALINEA FOTO | 0380-EMPA | NOTP CTEC
PM99 | 83479223 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00310529 | Employee name | 09:15:00 | 10:00:00 | 0.75 | SE REVIZO CONTROL ELECTRICO SE CAMBIO | 0380-EMPA | NOTP CTEC
PM99 | 83479281 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00310529 | Employee name | 10:00:00 | 10:45:00 | 0.75 | se checo electricamente , se [NAME] | 0380-EMPA | NOTP CTEC
PM99 | 83479283 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00310529 | Employee name | 10:00:00 | 10:45:00 | 0.75 | SE REPARO CABLE PELADO EN MORDAZA | 0380-EMPA | NOTP CTEC
PM99 | 83479688 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00310667 | Employee name | 16:00:00 | 16:30:58 | 0.5 | se [NAME] y se [NAME] | 0380-EMPA | NOTP CTEC
PM99 | 83479689 | [PHONE] | 2008-07-06 00:00:00 | 00000002 | 00308350 | Employee name | 18:00:00 | 20:06:17 | 2 | [NAME] no. 6 con la comput | 0380-EMPA | NOTP CTEC
PM99 | 83479689 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00310529 | Employee name | 06:30:00 | 07:30:00 | 1 | SE AJUSTAN PRESIONES DE AIRE PARA COMP | 0380-EMPA | NOTP CTEC
PM99 | 83479690 | [PHONE] | 2008-07-06 00:00:00 | 00000002 | 00310667 | Employee name | 16:00:39 | 17:04:57 | 1 | Se apoya en falla de temperaturas. | 0380-EMPA | NOTP CTEC
PM99 | 83479690 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00308350 | Employee name | 16:00:00 | [NAME] | 2 | Se revizan resistencias, termopares, fus | 0380-EMPA | NOTP CTEC
PM99 | 83479692 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00308350 | Employee name | 15:00:00 | [NAME] | 1 | se [NAME] y se encontro fusible quemado | 0380-EMPA | NOTP CTEC
PM99 | 83479693 | [PHONE] | 2008-07-06 00:00:00 | 00000001 | 00308350 | Employee name | 17:00:00 | 17:30:08 | 0.5 | [NAME] | 0380-EMPA | NOTP CTEC
PM02 | 82683280 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310134 | Employee name | 06:00:00 | 06:30:00 | 0.5 | [NAME] inspeccion de sistema electrico | 0380-EMPA | NOTP CTEC IMPR
PM02 | 83018557 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310134 | Employee name | 06:30:00 | 07:00:00 | 0 | Este trabajo se hara conla  O.T.83018566 | 0380-EMPA | NOTP CTEC
PM02 | 83018566 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310134 | Employee name | 06:00:00 | 06:30:00 | 0.5 | [NAME] inspeccion en [NAME] | 0380-EMPA | NOTP CTEC
PM01 | 83349945 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00313114 | Employee name | 06:00:00 | 14:00:00 | 8 | SE CAMBIO PIZARRON Y SE ADAPTO EN TRABA | 0380-EMPA | NOTP CTEC IMPR
PM02 | 83371049 | [PHONE] | 2008-07-07 00:00:00 | 00000004 | 00308349 | Employee name | 06:00:00 | 14:45:00 | 8.45 | [NAME] baleros a cubetas. Ok! | 0380-EMPA | NOTP CTEC IMPR
PM02 | 83372471 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310134 | Employee name | 06:30:00 | 06:30:00 | 0 | Se deja O.T.83018566 p/este trabajo | 0380-EMPA | NOTP CTEC
PM02 | 83414035 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00316386 | Employee name | 06:00:00 | 14:45:00 | 3.5 | Se realiza conforme a la OT | 0380-EMPA | NOTP CTEC
PM02 | 83432161 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310134 | Employee name | 06:30:00 | 06:30:00 | 0 | Se realiza inspeccion mecanismo en buen | 0380-EMPA | NOTP CTEC
PM02 | 83432211 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310081 | Employee name | 00:00:00 | 15:41:45 | 3 | SE DIO MTTO GENERAL BANDA ROD Y MOTOR OK | 0380-EMPA | NOTP CTEC IMPR
PM02 | 83432212 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310081 | Employee name | 00:00:00 | 15:40:13 | 3 | SE DIO MTTO GENERAL BANA ROD Y MOTOR OK | 0380-EMPA | NOTP CTEC IMPR
PM02 | 83432213 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310081 | Employee name | 00:00:00 | 15:38:16 | 3 | SE DIO MTTO GENERAL RODILLOS BANDA Y MOT | 0380-EMPA | NOTP CTEC IMPR
PM02 | 83432215 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00313114 | Employee name | 11:00:00 | 14:30:00 | 3.5 | SE CAMBIO FILTROS Y ESPREAS SE PURGO | 0380-EMPA | NOTP CTEC IMPR
PM02 | 83432216 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00313114 | Employee name | 06:00:00 | 11:00:00 | 5 | SE CAMBIO FILTROS, SE PURGO MANGUERA | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83452998 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310074 | Employee name | 09:00:00 | 19:19:11 | 8 | SE DIO APOYO ALMTTO DE LA 14A A A OS DEP | 0380-EMPA | NOTP CTEC
PM01 | 83460549 | [PHONE] | 2008-07-07 00:00:00 | 00000003 | 00316386 | Employee name | 17:00:00 | 22:00:00 | 5 | SE APOYÓ EN MANTENIMIENTO, SE CAMBIARON | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83460756 | [PHONE] | 2008-07-07 00:00:00 | 00000009 | 00308350 | Employee name | 14:00:00 | 21:00:16 | 7 | Se apoya en el area de mantenimiento con | 0380-EMPA | NOTP CTEC
PM01 | 83470770 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310134 | Employee name | 11:00:00 | 16:00:00 | 5 | [NAME] reductor HUB CITY [NAME] | 0380-EMPA | NOTP CTEC
PM01 | 83472561 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310134 | Employee name | 08:00:00 | 10:00:00 | 2 | [NAME] soporte de motor | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83475315 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00312630 | Employee name | 08:00:00 | 09:00:00 | 1 | [NAME] bandas | 0380-EMPA | NOTP CTEC
PM01 | 83478027 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310074 | Employee name | 06:00:00 | 09:00:00 | 3 | SE REALIZO CHECK LIST DEL ERLI MECANICO | 0380-EMPA | NOTP CTEC
PM01 | 83478341 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00312994 | Employee name | 18:00:00 | 22:00:00 | 4 | se realizó check list detectores [NAME] | 0380-EMPA | NOTP CTEC
PM01 | 83478343 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310353 | Employee name | 06:00:00 | 14:45:00 | 8.25 | SE FABRICO 4 POLEAS PARA VIBRADORES DE B | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83478344 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00311826 | Employee name | 06:00:06 | 16:59:34 | 9 | CORDINA  TRABAJOS DE MTTO PREVENTIVO | 0380-EMPA | NOTP CTEC
PM01 | 83478522 | [PHONE] | 2008-07-07 00:00:00 | 00000004 | 00310498 | Employee name | 22:00:00 | 23:59:00 | 6 | SE CORRIGEN FALLAS VARIAS | 0380-EMPA | NOTP CTEC
PM01 | 83478522 | [PHONE] | 2008-07-07 00:00:00 | 00000005 | 00310498 | Employee name | 22:00:00 | 23:59:00 | 2 | SE ARREGLAN FALLAS VARIAS | 0380-EMPA | NOTP CTEC
PM01 | 83478522 | [PHONE] | 2008-07-07 00:00:00 | 00000011 | 00310498 | Employee name | 00:00:00 | 06:00:00 | 6 | SE CORRIGEN FALLAS CORRECTIVAS | 0380-EMPA | NOTP CTEC
PM01 | 83480373 | [PHONE] | 2008-07-07 00:00:00 | 00000002 | 00313089 | Employee name | 06:00:23 | 09:00:52 | 3 | [NAME] cereal | 0380-EMPA | NOTP CTEC
PM01 | 83480373 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00312705 | Employee name | 06:00:16 | 09:00:23 | 3 | se realizo maniobras [NAME] vibrador | 0380-EMPA | NOTP CTEC
PM01 | 83480373 | [PHONE] | 2008-07-07 00:00:00 | 00000003 | 00313122 | Employee name | 06:00:52 | 09:05:28 | 3 | se relizo maniobras para bajar vibrador | 0380-EMPA | NOTP CTEC
PM01 | 83480432 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00312705 | Employee name | 09:00:00 | 14:00:00 | 5 | Se realizo mantenimiento a dos cabezales | 0380-EMPA | NOTP CTEC
PM01 | 83481023 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310529 | Employee name | 07:00:00 | 08:30:00 | 1.5 | APOYO ORDENES LEVES EMPAQUE. | 0380-EMPA | NOTP CTEC
PM01 | 83481023 | [PHONE] | 2008-07-07 00:00:00 | 00000002 | 00310529 | Employee name | 14:00:00 | 19:00:00 | 5 | SE APOYO EN FALLAS VARIAS LEVES . | 0380-EMPA | NOTP CTEC
PM99 | 83481357 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310529 | Employee name | 18:30:00 | 19:15:00 | 0.75 | SE CAMBIO CABLE TEMPOPAR | 0380-EMPA | NOTP CTEC
PM99 | 83481580 | [PHONE] | 2008-07-07 00:00:00 | 00000002 | 00310529 | Employee name | 20:45:00 | 21:15:00 | 0.5 | SE APOYO EN REVICION DEL PISTON DE FAJAS | 0380-EMPA | NOTP CTEC
PM99 | 83481583 | [PHONE] | 2008-07-07 00:00:00 | 00000002 | 00310529 | Employee name | 19:00:00 | 19:30:00 | 0.5 | SE AJUSTARON DISPAROS DE HOT MELT | 0380-EMPA | NOTP CTEC
PM99 | 83481584 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310529 | Employee name | 15:15:00 | 16:00:00 | 0.75 | SE AJUSTA POTENCIOMETRO DEL SPAN Y SE | 0380-EMPA | NOTP CTEC
PM99 | 83481585 | [PHONE] | 2008-07-07 00:00:00 | 00000002 | 00310529 | Employee name | 19:30:00 | 20:00:00 | 0.5 | SE CAMBIO MOTOR | 0380-EMPA | NOTP CTEC
PM02 | 83179369 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00310223 | Employee name | 06:00:00 | 18:45:00 | 12.75 | VER NOTA DE INFORMASION | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83205386 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00310223 | Employee name | 06:00:00 | 14:45:00 | 8.75 | VER NOTA DE INFORMASION | 0380-EMPA | NOTP CTEC IMPR
PM02 | 83241505 | [PHONE] | 2008-07-08 00:00:00 | 00000002 | 00310134 | Employee name | 06:00:00 | 06:30:00 | 0.5 | [NAME] inspeccion del sistema electrico | 0380-EMPA | NOTP CTEC IMPR
PM02 | 83298758 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00310134 | Employee name | 06:30:00 | 06:45:00 | 0.5 | [NAME] inspección a tablero electrico | 0380-EMPA | NOTP CTEC
PM02 | 83306465 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00310223 | Employee name | 06:00:00 | 14:45:00 | 8.75 | VER NOTA DE INFORMASION | 0380-EMPA | NOTP CTEC IMPR
PM02 | 83306480 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00316386 | Employee name | 06:00:56 | [NAME] | 8.5 | Se realiza conforme a la ot... | 0380-EMPA | NOTP CTEC IMPR
PM02 | 83336668 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00310134 | Employee name | 07:00:00 | 09:30:00 | 2.5 | Se lubricaron transportadores de bolsa(v | 0380-EMPA | NOTP CTEC
PM02 | 83371045 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00308349 | Employee name | 13:00:00 | 15:30:00 | 2.5 | Se reviza divertor, [NAME], | 0380-EMPA | NOTP CTEC IMPR
PM02 | 83380992 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00308356 | Employee name | 06:00:53 | 14:30:31 | 8.5 | se checa alimentador de de paquete, se e | 0380-EMPA | NOTP CTEC IMPR
PM02 | 83380993 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00312705 | Employee name | 10:00:00 | 17:00:00 | 7 | Se desmonto rodillo de transmición y un | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83387459 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00310223 | Employee name | 09:00:00 | 14:00:00 | 5 | VER NOTA DE INFORMASION | 0380-EMPA | NOTP CTEC IMPR
PM02 | 83400376 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00310134 | Employee name | 06:00:00 | 08:30:00 | 2.5 | Se relizo inspeccion de linea,mecanica y | 0380-EMPA | NOTP CTEC
PM01 | 83402895 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00310223 | Employee name | 06:00:00 | 10:00:00 | 4 | [NAME] a seguidor | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83452998 | [PHONE] | 2008-07-08 00:00:00 | 00000004 | 00310074 | Employee name | 06:00:00 | 15:00:00 | 8.25 | SE APOYO EN EL MTTO DE LA 11A CHECA TEMP | 0380-EMPA | NOTP CTEC
PM01 | 83460756 | [PHONE] | 2008-07-08 00:00:00 | 00000010 | 00308350 | Employee name | 14:00:16 | 21:00:20 | 7 | [NAME] las fallas de mantenimiento | 0380-EMPA | NOTP CTEC
PM01 | 83462565 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00310223 | Employee name | 06:00:00 | 09:00:00 | 3 | VER NOTA DE INFORMASION | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83462565 | [PHONE] | 2008-07-08 00:00:00 | 00000002 | 00310223 | Employee name | 06:00:00 | 09:00:00 | 3 | VER NOTA DE INFORMASION | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83469590 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00310223 | Employee name | 09:00:00 | 14:45:00 | 5.75 | VER NOTA DE INFORMASION | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83469591 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00313114 | Employee name | 08:00:00 | 14:30:00 | 6.5 | SE [NAME] | 0380-EMPA | NOTP CTEC IMPR
PM02 | 83476030 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00313114 | Employee name | 00:00:00 | 13:29:01 | 8 | [NAME] LISTADO DE REFACCIONES | 0380-EMPA | NOTP CTEC
PM01 | 83478340 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00312994 | Employee name | 06:00:00 | 08:30:00 | 2 | SE REALIZÓ REPORTE DE FALLAS | 0380-EMPA | NOTP CTEC
PM01 | 83478343 | [PHONE] | 2008-07-08 00:00:00 | 00000005 | 00310353 | Employee name | 06:00:00 | 14:45:00 | 8.25 | FABRICO VARIAS PZAS PARA EL MTTO DE LA 1 | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83478343 | [PHONE] | 2008-07-08 00:00:00 | 00000002 | 00310470 | Employee name | 06:00:00 | 14:45:39 | 8.5 | SE EMPESO A HACER LAS PIEZAS DEL MANTENI | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83478343 | [PHONE] | 2008-07-08 00:00:00 | 00000003 | 00310470 | Employee name | 06:00:39 | 14:45:05 | 8.5 | SE ESTA HACIENDO LOS TRABAJOS DE LA PIEZ | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83478344 | [PHONE] | 2008-07-08 00:00:00 | 00000002 | 00311826 | Employee name | 06:00:34 | 16:01:38 | 9 | CORDINA TRABAJOS DE MTTO PREVENTIVO | 0380-EMPA | NOTP CTEC
PM01 | 83478348 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00308349 | Employee name | 06:00:00 | 08:00:00 | 2 | Se checan insertadoras automáticas. | 0380-EMPA | NOTP CTEC
PM01 | 83478522 | [PHONE] | 2008-07-08 00:00:00 | 00000012 | 00310101 | Employee name | 22:00:00 | 23:59:00 | 2 | SE ARREGLA FALLAS VARIAS | 0380-EMPA | NOTP CTEC
PM01 | 83478522 | [PHONE] | 2008-07-08 00:00:00 | 00000013 | 00310101 | Employee name | 00:00:00 | 06:00:00 | 6 | SE ARREGLA  FALLAS VARIAS | 0380-EMPA | NOTP CTEC
PM01 | 83478522 | [PHONE] | 2008-07-08 00:00:00 | 00000014 | 00310101 | Employee name | 22:00:00 | 23:59:00 | 2 | SE ARREGLAN FALLAS VARIAS | 0380-EMPA | NOTP CTEC
PM01 | 83478522 | [PHONE] | 2008-07-08 00:00:00 | 00000006 | 00310498 | Employee name | 22:00:00 | 23:59:00 | 6 | SE CORRIGEN FALLAS VARIAS | 0380-EMPA | NOTP CTEC
PM01 | 83478522 | [PHONE] | 2008-07-08 00:00:00 | 00000007 | 00310498 | Employee name | 00:00:00 | 06:00:00 | 6 | SE ARREGLAN FALLAS VARIAS | 0380-EMPA | NOTP CTEC
PM01 | 83478522 | [PHONE] | 2008-07-08 00:00:00 | 00000008 | 00310498 | Employee name | 22:00:00 | 23:59:00 | 2 | SE ARRGLAN FALLAS VARIAS | 0380-EMPA | NOTP CTEC
PM01 | 83478586 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00312630 | Employee name | 06:00:00 | 20:00:00 | 14 | Se cambian barras y se les colocan placa | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83478588 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00310223 | Employee name | 06:00:00 | 14:45:00 | 8.75 | VER NOTA DE INFORMASION | 0380-EMPA | NOTP CTEC IMPR
PM99 | 83479233 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00301953 | Employee name | 12:00:55 | 13:00:29 | 1 | [NAME] y [NAME] | 0380-EMPA | NOTP CTEC
PM99 | 83479236 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00301953 | Employee name | 11:15:20 | 12:00:03 | 0.75 | se cambio motor de banda y [NAME] ban | 0380-EMPA | NOTP CTEC
PM01 | 83480432 | [PHONE] | 2008-07-08 00:00:00 | 00000002 | 00312705 | Employee name | 06:00:00 | 10:00:00 | 4 | Se realizo mantenimiento a dos cabezales | 0380-EMPA | NOTP CTEC
PM01 | 83481023 | [PHONE] | 2008-07-08 00:00:00 | 00000003 | 00310529 | Employee name | 19:00:00 | 22:00:00 | 3 | SE APOYO EN LINEA 12-B TRIANGLE ISQ. (PA | 0380-EMPA | NOTP CTEC
PM99 | 83481580 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00301953 | Employee name | 20:45:15 | 21:15:53 | 0.5 | se reviza piston y [NAME] | 0380-EMPA | NOTP CTEC
PM99 | 83481583 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00301953 | Employee name | 19:00:54 | 19:30:36 | 0.5 | [NAME] parametros en plus | 0380-EMPA | NOTP CTEC
PM99 | 83481585 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00301953 | Employee name | 19:30:08 | 20:00:53 | 0.5 | se apoya en cambio de motor | 0380-EMPA | NOTP CTEC
PM02 | 83482330 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00310134 | Employee name | 00:00:00 | 08:39:49 | 0 | [NAME] no hay CHECK [NAME] es TOLEDO | 0380-EMPA | NOTP CTEC
PM02 | 83482331 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00310134 | Employee name | 00:00:00 | 08:44:52 | 0 | [NAME] inspeccion en [NAME] | 0380-EMPA | NOTP CTEC
PM99 | 83482658 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00310276 | Employee name | 09:00:00 | 10:30:00 | 1.5 | [NAME] ,quemado , s ein | 0380-EMPA | NOTP CTEC
PM99 | 83482658 | [PHONE] | 2008-07-08 00:00:00 | 00000002 | 00310276 | Employee name | 10:30:00 | 14:15:30 | 1.5 |  | 0380-EMPA | NOTP CTEC
PM01 | 83483173 | [PHONE] | 2008-07-08 00:00:00 | 00000002 | 00308349 | Employee name | 09:00:00 | 13:00:00 | 4 | sE ASISTIÓ A CURSO SE SERVICIO A CLIENTE | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83483173 | [PHONE] | 2008-07-08 00:00:00 | 00000003 | 00310529 | Employee name | 14:00:00 | 18:30:00 | 4.5 | [NAME] CURSO SERVICIO AL CLIENTE. | 0380-EMPA | NOTP CTEC IMPR
PM01 | 83483173 | [PHONE] | 2008-07-08 00:00:00 | 00000004 | 00312994 | Employee name | 09:00:00 | 13:00:00 | 4 | SE AISTIO A CURSO | 0380-EMPA | NOTP CTEC IMPR
PM99 | 83483238 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00312994 | Employee name | 13:30:00 | 14:15:00 | 0.75 | SE CAMBIO FUENTE ALIM. 90VDC. | 0380-EMPA | NOTP CTEC
PM99 | 83483563 | [PHONE] | 2008-07-08 00:00:00 | 00000001 | 00310529 | Employee name | 21:15:00 | 21:45:00 | 0.5 | [NAME] LIMPIEZA Y AJUSTES EN BASCULA | 0380-EMPA | NOTP CTEC
PM01 | 83445545 | [PHONE] | 2008-07-09 00:00:00 | 00000002 | 00310127 | Employee name | [NAME] | 14:00:26 | 6 | [NAME]. | 0380-EMPA | NOTP CTEC
PM01 | 83452998 | [PHONE] | 2008-07-09 00:00:00 | 00000005 | 00310074 | Employee name | 09:00:00 | 15:00:00 | 5.25 | SE CHECARON [NAME] FIJO QUE | 0380-EMPA | NOTP CTEC
PM01 | 83452998 | [PHONE] | 2008-07-09 00:00:00 | 00000002 | 00310081 | Employee name | [NAME] | 08:24:46 | 4 | SE CHECO VIDEOJET #16 | 0380-EMPA | NOTP CTEC
PM01 | 83452998 | [PHONE] | 2008-07-09 00:00:00 | 00000003 | 00310081 | Employee name | 08:24:46 | 14:16:29 | 8.25 | SE DIO MTTO GENERAL A TRES MOTORES DE CO | 0380-EMPA | NOTP CTEC
PM01 | 83460756 | [PHONE] | 2008-07-09 00:00:00 | 00000011 | 00308350 | Employee name | 14:00:20 | [NAME] | 7 | [NAME] las fallas de mantenimiento | 0380-EMPA | NOTP CTEC
PM02 | 83476030 | [PHONE] | 2008-07-09 00:00:00 | 00000002 | 00313114 | Employee name | 06:00:00 | 14:00:00 | 8 | SE TERMINO LISTADO DE REFACCIONES | 0380-EMPA | NOTP CTEC
PM99 | 83477374 | [PHONE] | 2008-07-09 00:00:00 | 00000001 | 00308350 | Employee name | 16:00:00 | 16:45:09 | 0.75 | Se realizan ajustes en insertador. | 0380-EMPA | NOTP CTEC
Example:
PM01 | 83481023 | [PHONE] | 2008-07-07 00:00:00 | 00000001 | 00310529 | Employee name | 07:00:00 | 08:30:00 | 1.5 | APOYO ORDENES LEVES EMPAQUE. | 0380-EMPA | NOTP CTEC
PM01 | 83481023 | [PHONE] | 2008-07-07 00:00:00 | 00000002 | 00310529 | Employee name | 14:00:00 | 19:00:00 | 5 | SE APOYO EN FALLAS VARIAS LEVES . | 0380-EMPA | NOTP CTEC
PM01 | 83481023 | [PHONE] | 2008-07-08 00:00:00 | 00000003 | 00310529 | Employee name | 19:00:00 | 22:00:00 | 3 | SE APOYO EN LINEA 12-B TRIANGLE ISQ. (PA | 0380-EMPA | NOTP CTEC
A unique work order record (the newest one) and the total hours spent on that order.
PM01 | 83481023 | [PHONE] | 2008-07-08 00:00:00 | 00000003 | 00310529 | Employee name | 19:00:00 | 22:00:00 | 9.5 | SE APOYO EN LINEA 12-B TRIANGLE ISQ. (PA | 0380-EMPA | NOTP CTEC