Spreadsheet: 130302d1322162061-consolidation-problem-select-hours-demo
Sheet: Select hours

cempid | cfirstname | clastname | nshiftnum | [NAME] | cgroup2 | cgroup3 | tin | tout | cin_exp | cout_exp | cbegsched | cendsched | [NAME] | [NAME] | novert2 | novert3 | novert4 | novert5 | creason | nschhrs | nlong_meal | cgrpdesc | nhrday1 | [NAME] | nhrday3 | nhrday4 | nhrday5 | nhrday6 | [NAME]
236800 | LISA | ACOSTA | 100 | 001 | 001 | 001 | 21-Nov-11 06:49:00 | 21-Nov-11 11:37:00 | E 41 |  | 07:30 | 16:00 | 4.75 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | RECEIVING CLERK | 4.75 | 0 | 0 | 0 | 0 | 0 | 0
236800 | LISA | ACOSTA | 100 | 001 | 001 | 001 | 21-Nov-11 12:05:00 | 21-Nov-11 14:45:00 | M 28 | E 75 | 07:30 | 16:00 | 2.5 | 0 | 0 | 0 | 0 | 0 | R025 | 8.5 | 30 | RECEIVING CLERK | 2.5 | 0 | 0 | 0 | 0 | 0 | 0
324000 | ISABEL | ALVAREZ | 100 | 001 | 001 | 003 | 21-Nov-11 07:30:00 | 21-Nov-11 11:30:00 |  |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 | MTC | 0 | 0 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
324000 | ISABEL | ALVAREZ | 100 | 001 | 001 | 003 | 21-Nov-11 12:00:00 | 21-Nov-11 16:00:00 | M 30 |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 | MTC | 8.5 | 30 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
142600 | RAYMOND | ARENAS | 100 | 001 | 001 | 004 | 21-Nov-11 07:31:00 | 21-Nov-11 11:30:00 | T  1 |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 | MSP | 0 | 0 | FORKLIFT | 4 | 0 | 0 | 0 | 0 | 0 | 0
142600 | RAYMOND | ARENAS | 100 | 001 | 001 | 004 | 21-Nov-11 12:00:00 | 21-Nov-11 15:42:00 | M 30 | E 18 | 07:30 | 16:00 | 3.5 | 0 | 0 | 0 | 0 | 0 | MTC | 8.5 | 30 | FORKLIFT | 3.5 | 0 | 0 | 0 | 0 | 0 | 0
125900 | CINDY | ARTEAGA | 100 | 001 | 001 | 003 | 21-Nov-11 07:56:00 | 21-Nov-11 12:06:00 | T 26 |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
125900 | CINDY | ARTEAGA | 100 | 001 | 001 | 003 | 21-Nov-11 12:32:00 | 21-Nov-11 16:14:00 | M 26 | L 14 | 07:30 | 16:00 | 4.25 | 0 | 0 | 0 | 0 | 0 | CADD | 8.5 | 30 | GENERAL LABOR | 4.25 | 0 | 0 | 0 | 0 | 0 | 0
051300 | ANA GUADALUPE | BOLAINES M. | 100 | 001 | 001 | 003 | 21-Nov-11 06:56:00 | 21-Nov-11 11:01:00 | E 34 | E299 | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 |  | 8.5 | 0 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
802200 | GUADALUPE | CASTANEDA | 100 | 001 | 001 | 003 | 21-Nov-11 07:28:00 | 21-Nov-11 11:31:00 |  |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
802200 | GUADALUPE | CASTANEDA | 100 | 001 | 001 | 003 | 21-Nov-11 12:01:00 | 21-Nov-11 16:01:00 | M 30 |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 |  | 8.5 | 30 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
281400 | VERONICA | [NAME] | 100 | 001 | 001 | 003 | 21-Nov-11 06:55:00 | 21-Nov-11 11:00:00 | E 35 | E300 | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 |  | 8.5 | 0 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
890900 | [NAME] | ESTRADA | 100 | 001 | 001 | 003 | 21-Nov-11 07:28:00 | 21-Nov-11 11:30:00 |  |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 | MSP | 0 | 0 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
890900 | [NAME] | ESTRADA | 100 | 001 | 001 | 003 | 21-Nov-11 12:00:00 | 21-Nov-11 16:05:00 | M 30 |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 | MSP | 8.5 | 30 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
813500 | DERRYL | FISHER | 100 | 001 | 001 | 004 | 21-Nov-11 16:00:00 | 21-Nov-11 20:00:00 | T*** |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 | MTC | 0 | 0 | FORKLIFT | 4 | 0 | 0 | 0 | 0 | 0 | 0
813500 | DERRYL | FISHER | 100 | 001 | 001 | 004 | 21-Nov-11 20:30:00 | 22-Nov-11 01:00:00 | M 30 | L540 | 07:30 | 16:00 | 4 | 0.5 | 0 | 0 | 0 | 0 | MTC | 8.5 | 30 | FORKLIFT | 4.5 | 0 | 0 | 0 | 0 | 0 | 0
000200 | JUAN | GALLEGOS GARCIA | 100 | 001 | 001 | 003 | 21-Nov-11 07:20:00 | 21-Nov-11 11:32:00 | E 10 |  | 07:30 | 16:00 | 4.25 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | GENERAL LABOR | 4.25 | 0 | 0 | 0 | 0 | 0 | 0
000200 | JUAN | GALLEGOS GARCIA | 100 | 001 | 001 | 003 | 21-Nov-11 12:11:00 | 21-Nov-11 16:00:00 | M 39 |  | 07:30 | 16:00 | 3.75 | 0 | 0 | 0 | 0 | 0 |  | 8.5 | 45 | GENERAL LABOR | 3.75 | 0 | 0 | 0 | 0 | 0 | 0
458700 | SUSANA | GUERRERO | 100 | 001 | 001 | 003 | 21-Nov-11 07:55:00 | 21-Nov-11 12:06:00 | T 25 |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
458700 | SUSANA | GUERRERO | 100 | 001 | 001 | 003 | 21-Nov-11 12:31:00 | 21-Nov-11 16:14:00 | M 25 | L 14 | 07:30 | 16:00 | 4.25 | 0 | 0 | 0 | 0 | 0 | CADD | 8.5 | 30 | GENERAL LABOR | 4.25 | 0 | 0 | 0 | 0 | 0 | 0
649900 | JOHNNATHAN | HADLEY | 100 | 001 | 001 | 003 | 21-Nov-11 07:28:00 | 21-Nov-11 11:33:00 |  |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
649900 | JOHNNATHAN | HADLEY | 100 | 001 | 001 | 003 | 21-Nov-11 12:01:00 | 21-Nov-11 15:37:00 | M 28 | E 23 | 07:30 | 16:00 | 3.5 | 0 | 0 | 0 | 0 | 0 |  | 8.5 | 30 | GENERAL LABOR | 3.5 | 0 | 0 | 0 | 0 | 0 | 0
793700 | ANDREW | HATTON | 100 | 001 | 001 | 003 | 21-Nov-11 07:00:00 | 21-Nov-11 11:30:00 | E 30 |  | 07:30 | 16:00 | 4.5 | 0 | 0 | 0 | 0 | 0 | MTC | 0 | 0 | GENERAL LABOR | 4.5 | 0 | 0 | 0 | 0 | 0 | 0
793700 | ANDREW | HATTON | 100 | 001 | 001 | 003 | 21-Nov-11 12:00:00 | 21-Nov-11 15:00:00 | M 30 | E 60 | 07:30 | 16:00 | 3 | 0 | 0 | 0 | 0 | 0 | MTC | 8.5 | 30 | GENERAL LABOR | 3 | 0 | 0 | 0 | 0 | 0 | 0
210600 | RANDY | KELLERHALS | 100 | 001 | 001 | 004 | 21-Nov-11 07:02:00 | 21-Nov-11 11:36:00 | E 28 |  | 07:30 | 16:00 | 4.5 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | FORKLIFT | 4.5 | 0 | 0 | 0 | 0 | 0 | 0
210600 | RANDY | KELLERHALS | 100 | 001 | 001 | 004 | 21-Nov-11 12:00:00 | 21-Nov-11 17:13:00 | M 24 | L 73 | 07:30 | 16:00 | 3.5 | 1.75 | 0 | 0 | 0 | 0 |  | 8.5 | 30 | FORKLIFT | 5.25 | 0 | 0 | 0 | 0 | 0 | 0
574600 | [NAME] | LUNA | 100 | 001 | 001 | 002 | 21-Nov-11 06:55:00 | 21-Nov-11 12:01:00 | E 35 |  | 07:30 | 16:00 | 5 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | SHIPPING CLERK | 5 | 0 | 0 | 0 | 0 | 0 | 0
574600 | [NAME] | LUNA | 100 | 001 | 001 | 002 | 21-Nov-11 12:29:00 | 21-Nov-11 15:32:00 | M 28 | E 28 | 07:30 | 16:00 | 3 | 0 | 0 | 0 | 0 | 0 |  | 8.5 | 30 | SHIPPING CLERK | 3 | 0 | 0 | 0 | 0 | 0 | 0
310000 | VICTOR | MALDONADO | 100 | 001 | 001 | 003 | 21-Nov-11 11:35:00 | 21-Nov-11 16:34:00 | T245 |  | 07:30 | 16:00 | 5 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | GENERAL LABOR | 5 | 0 | 0 | 0 | 0 | 0 | 0
310000 | VICTOR | MALDONADO | 100 | 001 | 001 | 003 | 21-Nov-11 17:00:00 | 21-Nov-11 20:06:00 | M 26 | L246 | 07:30 | 16:00 | 3 | 0 | 0 | 0 | 0 | 0 |  | 8.5 | 30 | GENERAL LABOR | 3 | 0 | 0 | 0 | 0 | 0 | 0
024200 | ALEJANDRO | MARTINEZ | 100 | 001 | 001 | 004 | 21-Nov-11 07:02:00 | 21-Nov-11 11:31:00 | E 28 |  | 07:30 | 16:00 | 4.5 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | FORKLIFT | 4.5 | 0 | 0 | 0 | 0 | 0 | 0
024200 | ALEJANDRO | MARTINEZ | 100 | 001 | 001 | 004 | 21-Nov-11 12:05:00 | 21-Nov-11 16:30:00 | M 34 | L 30 | 07:30 | 16:00 | 3.5 | 1 | 0 | 0 | 0 | 0 |  | 8.5 | 30 | FORKLIFT | 4.5 | 0 | 0 | 0 | 0 | 0 | 0
329800 | FRANCISCO | MENDEZ | 100 | 001 | 001 | 003 | 21-Nov-11 07:20:00 | 21-Nov-11 11:31:00 | E 10 |  | 07:30 | 16:00 | 4.25 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | GENERAL LABOR | 4.25 | 0 | 0 | 0 | 0 | 0 | 0
329800 | FRANCISCO | MENDEZ | 100 | 001 | 001 | 003 | 21-Nov-11 11:59:00 | 21-Nov-11 16:22:00 | M 28 | L 22 | 07:30 | 16:00 | 3.75 | 0.25 | 0 | 0 | 0 | 0 | U025 | 8.5 | 30 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
510400 | LILIANA | MENDEZ | 100 | 001 | 001 | 003 | 21-Nov-11 06:55:00 | 21-Nov-11 11:31:00 | E 35 |  | 07:30 | 16:00 | 4.5 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | GENERAL LABOR | 4.5 | 0 | 0 | 0 | 0 | 0 | 0
510400 | LILIANA | MENDEZ | 100 | 001 | 001 | 003 | 21-Nov-11 12:00:00 | 21-Nov-11 16:35:00 | M 29 | L 35 | 07:30 | 16:00 | 3.5 | 1 | 0 | 0 | 0 | 0 |  | 8.5 | 30 | GENERAL LABOR | 4.5 | 0 | 0 | 0 | 0 | 0 | 0
134700 | [NAME] | MURPHY | 100 | 001 | 001 | 003 | 21-Nov-11 07:24:00 | 21-Nov-11 11:30:00 |  |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 | MSP | 0 | 0 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
134700 | [NAME] | MURPHY | 100 | 001 | 001 | 003 | 21-Nov-11 12:00:00 | 21-Nov-11 15:41:00 | M 30 | E 19 | 07:30 | 16:00 | 3.5 | 0 | 0 | 0 | 0 | 0 | R025 | 8.5 | 30 | GENERAL LABOR | 3.5 | 0 | 0 | 0 | 0 | 0 | 0
604300 | GERARDO | OREJEL | 200 | 001 | 001 | 003 | 21-Nov-11 16:00:00 | 21-Nov-11 20:00:00 |  |  | 16:00 | 24:30 | 4 | 0 | 0 | 0 | 0 | 0 | MSP | 0 | 0 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
604300 | GERARDO | OREJEL | 200 | 001 | 001 | 003 | 21-Nov-11 20:30:00 | 21-Nov-11 23:30:00 | M 30 | E 60 | 16:00 | 24:30 | 3 | 0 | 0 | 0 | 0 | 0 | MTC | 8.5 | 30 | GENERAL LABOR | 3 | 0 | 0 | 0 | 0 | 0 | 0
666700 | NUYGEN | PENDLETON | 100 | 001 | 001 | 003 | 21-Nov-11 07:29:00 | 21-Nov-11 11:30:00 |  |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 | MSP | 0 | 0 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
666700 | NUYGEN | PENDLETON | 100 | 001 | 001 | 003 | 21-Nov-11 12:00:00 | 21-Nov-11 16:01:00 | M 30 |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 | MSP | 8.5 | 30 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
249100 | CLAUDIA | RAMIREZ | 100 | 001 | 001 | 003 | 21-Nov-11 11:29:00 | 21-Nov-11 17:04:00 | T239 |  | 07:30 | 16:00 | 5.5 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | GENERAL LABOR | 5.5 | 0 | 0 | 0 | 0 | 0 | 0
249100 | CLAUDIA | RAMIREZ | 100 | 001 | 001 | 003 | 21-Nov-11 17:34:00 | 21-Nov-11 20:05:00 | M 30 | L245 | 07:30 | 16:00 | 2.5 | 0 | 0 | 0 | 0 | 0 |  | 8.5 | 30 | GENERAL LABOR | 2.5 | 0 | 0 | 0 | 0 | 0 | 0
027100 | ANA | SANDOVAL | 100 | 001 | 001 | 003 | 21-Nov-11 07:30:00 | 21-Nov-11 11:30:00 |  | E270 | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 | MTC | 8.5 | 0 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
602800 | [NAME] | SILVA | 100 | 001 | 001 | 004 | 21-Nov-11 06:55:00 | 21-Nov-11 11:31:00 | E 35 |  | 07:30 | 16:00 | 4.5 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | FORKLIFT | 4.5 | 0 | 0 | 0 | 0 | 0 | 0
602800 | [NAME] | SILVA | 100 | 001 | 001 | 004 | 21-Nov-11 12:00:00 | 21-Nov-11 16:37:00 | M 29 | L 37 | 07:30 | 16:00 | 3.5 | 1 | 0 | 0 | 0 | 0 |  | 8.5 | 30 | FORKLIFT | 4.5 | 0 | 0 | 0 | 0 | 0 | 0
704200 | LESLIE | TORRES | 100 | 001 | 001 | 003 | 21-Nov-11 06:56:00 | 21-Nov-11 11:01:00 | E 34 | E299 | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 |  | 8.5 | 0 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
999600 | ELISEO | VASQUEZ | 100 | 001 | 001 | 004 | 21-Nov-11 16:07:00 | 21-Nov-11 20:02:00 | T517 |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 | MSP | 0 | 0 | FORKLIFT | 4 | 0 | 0 | 0 | 0 | 0 | 0
999600 | ELISEO | VASQUEZ | 100 | 001 | 001 | 004 | 21-Nov-11 20:32:00 | 22-Nov-11 01:01:00 | M 30 | L541 | 07:30 | 16:00 | 4 | 0.5 | 0 | 0 | 0 | 0 |  | 8.5 | 30 | FORKLIFT | 4.5 | 0 | 0 | 0 | 0 | 0 | 0
870900 | CASSANDRA | VILLESCAZ | 100 | 001 | 001 | 003 | 21-Nov-11 07:25:00 | 21-Nov-11 11:35:00 |  |  | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0
870900 | CASSANDRA | VILLESCAZ | 100 | 001 | 001 | 003 | 21-Nov-11 12:07:00 | 21-Nov-11 15:59:00 | M 32 | E  1 | 07:30 | 16:00 | 4 | 0 | 0 | 0 | 0 | 0 |  | 8.5 | 30 | GENERAL LABOR | 4 | 0 | 0 | 0 | 0 | 0 | 0