Spreadsheet: 149495d1333990919-solved-combine-4-columns-into-one-non-repeating-list-kamelkid2_combine-4-columns-into-one-non-repeating-list_logistix_09apr12_02
Sheet: log

name | wo | shift | date | group | focus factory | work order type | delay code | time | comment | delay code 2 | delay time 2 | comment 2 | delay code 3 | delay time 3 | comment 3 | delay code 4 | delay time 4 | comment 4 | total delay time | wo total time | wo net time
[NAME] | - | 1 | 2012-04-02 00:00:00 | FAC 3150 | n | cor | h | 00:15:00 | - | o | 00:10:00 | - | add-1 | 00:15:00 | construction activity permit | - | - | - |  | 10:00:00
[NAME] | - | 1 | 2012-04-02 00:00:00 | FAC 3150 | n | cor | e | 00:10:00 | - | o | 00:10:00 | - | - | - | - | - | - | - |  | 11:30:00
[NAME] | - | 1 | 2012-04-02 00:00:00 | FAC 3150 | s | cor | - | - | - | - | - | - | - | - | - | - | - | - |  | 03:30:00
[NAME] | - | 1 | 2012-04-02 00:00:00 | FAC 3150 | s | cor | a | 00:20:00 | - | e | 00:15:00 | - | j | 00:10:00 | - | o | 00:05:00 | - |  | 10:30:00
[NAME] | - | 1 | 2012-04-02 00:00:00 | FAC 3150 | v | cor | f | 00:30:00 | - | m | 02:00:00 | - | o | 01:30:00 | - | - | - | - |  | 11:30:00
[NAME] | - | 1 | 2012-04-02 00:00:00 | FAC 3150 | v | bk | d | 02:00:00 | - | - | - | - | - | - | - | - | - | - |  | -
[NAME] Cougar | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | iv | [NAME] | g | 00:30:00 | - | l | 00:30:00 | - | o | 00:30:00 | - | - | - | - |  | 06:30:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | n | [NAME] | - | - | - | - | - | - | - | - | - | - | - | - |  | 01:00:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | n | cor | - | - | - | - | - | - | - | - | - | - | - | - |  | 05:30:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | PRO-3155 | n | - | j | - | - | p | - | - | - | - | - | - | - | - |  | -
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | v | cor | - | - | - | - | - | - | - | - | - | - | - | - |  | 02:00:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | s | pm | add-1 | 00:15:00 | looking for ladder | - | - | - | - | - | - | - | - | - |  | 02:30:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | iv | bk | d | 00:10:00 | - | - | - | - | - | - | - | - | - | - |  | 00:30:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | iv | cor | d | 00:10:00 | - | - | - | - | - | - | - | - | - | - |  | 00:30:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | iv | cor | o | 00:30:00 | - | - | - | - | - | - | - | - | - | - |  | 01:30:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | iv | cor | o | 00:50:00 | - | - | - | - | - | - | - | - | - | - |  | 02:00:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | s | cor | - | - | - | - | - | - | - | - | - | - | - | - |  | 02:30:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | v | cor | - | - | - | - | - | - | - | - | - | - | - | - |  | 03:00:00
[NAME] | - | 2 | 2012-04-02 00:00:00 | FAC 3150 | v | bk | - | - | - | - | - | - | - | - | - | - | - | - |  | 04:00:00
[NAME] | - | 3 | 2012-04-02 00:00:00 | FAC 3150 | v | pm | - | - | - | - | - | - | - | - | - | - | - | - |  | 01:00:00
[NAME] | - | 3 | 2012-04-02 00:00:00 | FAC 3150 | v | pm | - | - | - | - | - | - | - | - | - | - | - | - |  | 01:00:00
[NAME] | - | 3 | 2012-04-02 00:00:00 | FAC 3150 | v | pm | - | - | - | - | - | - | yy | - | - | - | - | - |  | 01:00:00
[NAME] | - | 3 | 2012-04-02 00:00:00 | FAC 3150 | other | pm | - | - | - | - | - | - | - | - | - | - | - | - |  | 02:00:00
[NAME] | - | 3 | 2012-04-02 00:00:00 | FAC 3150 | other | [NAME] | - | - | - | - | - | - | - | - | - | zz | - | - |  | 01:00:00
[NAME] | - | 3 | 2012-04-02 00:00:00 | FAC 3150 | n | [NAME] | - | - | - | - | - | - | - | - | - | - | - | - |  | 01:00:00
[NAME] | - | 3 | 2012-04-02 00:00:00 | FAC 3150 | n | pm | - | - | - | - | - | - | - | - | - | - | - | - |  | 00:30:00