Spreadsheet: 819357d1677449656-formula-to-calculate-downtime-loadout-log-template
Sheet: Thursday

Date | Division | Route | Hauler | Trailer Number | Scheduled Depart Time (Route Sheet) | NEW Estimated Load Completed Time | Actual Load Completion Time | Time Load Departed Dairy | Shift | Load Start Time | Load Finish Time | Load Duration | Case Count | Pallet Count | Trailer Temp | Reason For Downtime | Comments
2023-02-16 00:00:00 | Central | 508 |  | 8648 | 12:28:00 |  | 07:10:00 | 11:10:00 |  | 06:30:00 | 07:00:00 |  | 1039 | 20 | 40 | 5:30-6:00 PICKERS
2023-02-16 00:00:00 | Central | 509 |  | 8644 | 13:57:00 |  | 07:20:00 | 02:35:00 |  | 07:00:00 | 07:20:00 |  | 999 | 20 | 35.4
2023-02-16 00:00:00 | Central | 510 |  | 8623 | 15:29:00 |  | 07:40:00 | 12:39:00 |  | 07:20:00 | 07:40:00 |  | 1115 | 21 | 39 | 7:46 WAITING ON TRACK #4
2023-02-16 00:00:00 | Central | 511 |  | 8626 | 16:13:00 |  | 08:20:00 | 17:01:00 |  | 07:40:00 | 08:20:00 |  | 1101 | 21 | 36.4
2023-02-16 00:00:00 | Central | 512 |  | 8620 | 17:02:00 |  | 08:45:00 | 11:04:00 |  | 08:20:00 | 08:45:00 |  | 999 | 19 | 39.5 | 9:20-11:00 WAITIN ON BILLS
2023-02-16 00:00:00 | Central | 513 |  | 3156 | 17:15:00 |  | 09:00:00 | 16:38:00 |  | 08:45:00 | 09:00:00 |  | 1203 | 24 | 40.3
2023-02-16 00:00:00 | Central | 514 |  | 3127 | 18:30:00 |  | 09:20:00 | 10:56:00 |  | 09:00:00 | 09:20:00 |  | 1119 | 22 | 41.4 | 11:00-11:30 PICKERS
2023-02-16 00:00:00 | Ruler | C12 |  | 6770 | 19:00:00 |  | 12:35:00 | 15:01:00 |  | 12:00:00 | 12:35:00 |  | 991 | 19 | 42.5
2023-02-16 00:00:00 | Ruler | C13 |  | 4758 | 19:30:00 |  | 13:15:00 | 16:22:00 |  | 12:35:00 | 13:15:00 |  | 1037 | 20 | 40.8 | 2:00-2:30 BREAKS
2023-02-16 00:00:00 | Ruler | C14 |  | 5754 | 20:00:00 |  | 16:35:00 | 19:08:00 |  | 16:00:00 | 16:35:00 |  | 1050 | 21 | 38.5
2023-02-16 00:00:00 | Ruler | C15 |  | 3852 | 20:30:00 |  | 17:00:00 | 20:25:00 |  | 16:35:00 | 17:00:00 |  | 867 | 17 | 41.7 | 2:30-2:50 WAITING ON UNITIZER
2023-02-16 00:00:00 | Ruler | C16 |  | 6350 | 21:00:00 |  | 17:40:00 | 20:30:00 |  | 17:00:00 | 17:40:00 |  | 941 | 20 | 41
2023-02-16 00:00:00 | [NAME] | J09 |  | 8614 | 05:00:00 |  | 13:30:00 | 03:45:00 |  | 13:15:00 | 13:30:00 |  | 571 | 11 | 43.1 | 3:00-3:45 PICKERS SORTING TRACKS
2023-02-16 00:00:00 | [NAME] | J10 |  | 8653 | 05:00:00 |  | 13:50:00 |  |  | 13:30:00 | 13:50:00 |  | 607 | 13 | 39.7
2023-02-16 00:00:00 | [NAME] | J11 |  | 8602 | 05:00:00 |  | 15:00:00 |  |  | 14:50:00 | 15:00:00 |  | 446 | 10 | 40.4 | TRACK 1 CHAIN 5:55-7:05
2023-02-16 00:00:00 | Central | 602 |  | 8617 | 09:00:00 |  | 19:10:00 | 01:06:00 |  | 17:40:00 | 19:10:00 |  | 1157 | 22 | 42
2023-02-16 00:00:00 | Central | 603 |  | 8659 | 10:39:00 |  | 20:10:00 |  |  | 19:10:00 | 20:10:00 |  | 1116 | 22 | 41.5 | BREAK 6:05-6:25
2023-02-16 00:00:00 | Central | 604 |  | 8637 | 10:49:00 |  | 23:40:00 |  |  | 23:10:00 | 23:40:00 |  | 1198 | 24 | 42
2023-02-16 00:00:00 | Central | 605 |  | 8642 | 10:58:00 |  | 00:10:00 |  |  | 23:40:00 | 00:10:00 |  | 1027 | 19 | 41.5 | PALLETIZER 7:40-7:50
2023-02-16 00:00:00 | Central | 606 |  | 8628 | 11:10:00 |  | 12:45:00 |  |  | 00:10:00 | 00:45:00 |  | 1229 | 23 | 40
2023-02-16 00:00:00 | Central | 607 |  | 8620 | 11:12:00 |  | 01:10:00 |  |  | 00:45:00 | 01:10:00 |  | 1183 | 23 | 41 | MISPICK 8:10 - ?
2023-02-16 00:00:00 | [NAME] | [NAME] |  | 6253 | 01:00:00 |  | 20:35:00 | 03:37:00 |  | 20:10:00 | 20:35:00 |  | 309 | 7 | 41
2023-02-16 00:00:00 | F4L | 601 F4L |  | 8650 | 03:03:00 |  | 20:55:00 |  |  | 20:35:00 | 20:55:00 |  | 621 | 13 | 40.5 | TRACK 2 9:15 - ?
2023-02-16 00:00:00 | Mariano's | M11 |  | 8636 | 05:34:00 |  | 21:20:00 | 22:20:00 |  | 20:55:00 | 21:20:00 |  | 573 | 11 | 41.5
2023-02-16 00:00:00 | Mariano's | M12 |  | 8638 | 05:42:00 |  | 22:30:00 | 23:08:00 |  | 21:55:00 | 22:30:00 |  | 1224 | 25 | 42 | LUNCH 9:25 -9:55
2023-02-16 00:00:00 | Mariano's | [NAME] |  | 8632 | 05:44:00 |  | 23:10:00 | 12:45:00 |  | 22:30:00 | 23:10:00 |  | 1105 | 21 | 39