Spreadsheet: 821147d1678465566-formula-help-next-available-record-with-conditions-lhs-tool-revised
Sheet: Elements

 |  | With Permit New Trailer | Without Permit New Trailer |  |  |  |  |  | Driver Name | Driver 1 | Driver 2 | Driver 3 | Driver 4 | Driver 5 | Driver 6 | Driver 1 | Driver 2 | Driver 7 | Driver 8 | Driver 9 | Driver 10 | Driver 3 | Driver 4 | Driver 1 | Driver 2 | Driver 3 | Driver 5 | Driver 6 | Driver 7 | Driver 5 | Driver 6 | Driver 4 | Driver 5 | Driver 6 | Driver 11 | Driver 12 | Driver 8 | Driver 7 | Driver 9 | Driver 10 | Driver 8 | Driver 7 | Driver 9 | Driver 10 | Driver 11 | Driver 13 | Driver 14 | Driver 15 | Driver 11 | Driver 16 | Driver 17 | Driver 18 | Driver 12 | Driver 16 | Driver 17 | Driver 13 | Driver 12 | Driver 14
 | Empty Truck/Trailer Weight | 51896 | 51896 |  |  | 27 Curtain siders |  |  | Driver Start Time | 10:00:00 |  |  |  | 13:00:00 |  |  |  | 13:00:00 |  |  |  | 17:00:00 |  |  |  |  | 17:00:00 |  |  |  |  | 20:45:00 |  |  |  |  | 20:00:00 |  |  |  | 23:00:00 |  |  |  | 03:00:00 |  |  |  |  | 00:00:00 |  |  |  | 05:30:00
 | [NAME] | 95000 | 80000 |  |  | 25 trailers of mods |  |  | Catcher Start Time |  | - | - | - |  | - | - | - |  | - | - | - |  | - | - | - | - |  | - | - | - | - |  | - | - | - | - |  | - | - | - |  | - | - |  | - | - | - | - | - |  | - | - | - |  | - | - | - | -
 | [NAME] |  |  |  |  | 3 hours of downtime/WK |  |  | Farm | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | SUNSET FAMILY FARMS LLC | SUNSET FAMILY FARMS LLC | SUNSET FAMILY FARMS LLC | SUNSET FAMILY FARMS LLC | SUNSET FAMILY FARMS LLC | SUNSET FAMILY FARMS LLC | SUNSET FAMILY FARMS LLC | SUNSET FAMILY FARMS LLC | SUNSET FAMILY FARMS LLC | SUNSET FAMILY FARMS LLC | NEWPORTS SPRING FARM LLC. | NEWPORTS SPRING FARM LLC. | NEWPORTS SPRING FARM LLC. | NEWPORTS SPRING FARM LLC. | NEWPORTS SPRING FARM LLC. | NEWPORTS SPRING FARM LLC. | NEWPORTS SPRING FARM LLC. | NEWPORTS SPRING FARM LLC. | NEWPORTS SPRING FARM LLC. | NEWPORTS SPRING FARM LLC. | NEWPORTS SPRING FARM LLC. | NEWPORTS SPRING FARM LLC. | NEWPORTS SPRING FARM LLC. | [NAME] | [NAME] | [NAME] | [NAME] | ZIEGLER BLUE MOUNTAIN GAME FARM | ZIEGLER BLUE MOUNTAIN GAME FARM | ZIEGLER BLUE MOUNTAIN GAME FARM | ZIEGLER BLUE MOUNTAIN GAME FARM | ZIEGLER BLUE MOUNTAIN GAME FARM
 | Avg. Live Bird | 5.7 | 5.7 |  |  | 350 people |  |  | House [NAME] | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 1 | 1 | 1 | 1 | 4 | 4 | 4 | 4 | 4 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 4 | 4 | 4 | 4 | 4 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1
 | Number of Birds Per Load |  |  |  |  | 16 |  |  | Birds/Tray | 56 | 49 | 49 | 49 | 63 | 49 | 49 | 49 | 63 | 49 | 49 | 49 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 63 | 63 | 63 | 56 | 56 | 56 | 56 | 49 | 63 | 63 | 63 | 63 | 56 | 49 | 49 | 49 | 49 | 63 | 56 | 56 | 56 | 56
 |  |  |  |  |  |  |  |  | Total Birds/Trailer
 | Birds/Drawer | 63 | 63 |  |  |  |  |  | Drive Time
 | Drawers/Stack | 9 | 9 |  |  | Catching starts at noon |  |  | Set up
 | Stacks/Trailer | 12 | 12 |  |  | Drivers start at 10 |  |  | Load
 | Birds/Trailer |  |  |  |  | Usually start receiving trucks around 2 PM |  |  | Button up
 |  |  |  |  |  |  |  |  | Drive time
 | Time to load full trailer | 40 | 40 |  |  |  |  |  | Scale
 |  |  |  |  |  |  |  |  | Unload
 |  |  |  |  |  |  |  |  | Expected Time Unloaded @ P3
 |  |  |  |  |  |  |  |  | EV Line Unloaded to | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1
 |  |  |  |  |  |  |  |  | Evis Line 1
 |  |  |  |  |  |  |  |  | Evis Line 2
 | Drive Time | M-Tech |  |  |  |  |  |  | Available Departure time for 2nd pick up
 | Set up | 10 |  |  |  |  |  |  | Actual Departure time of 2nd Pick Up | 14:20:00 | 15:00:00 | 17:00:00 | 17:40:00 | 17:00:00 | 17:40:00 |  |  | 18:20:00 | 20:00:00 | 21:20:00 | 22:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:00:00 | 02:00:00 |  |  |  |  |  |  |  |  |  | 06:50:00 | 08:10:00 |  |  | 05:30:00 | 06:10:00 |  |  |  |  |  | Start Time
 | Load | 40 |  |  |  |  |  |  | Available Departure time for 3rd pick up | 18:10:00 | 18:50:00 | 19:30:00 | 20:10:00 | 18:50:00 | 19:30:00 |  |  | 20:10:00 | 22:30:00 | 23:50:00 | 1900-01-01 00:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:30:00 | 07:20:00 |  |  |  |  |  |  |  |  |  | 08:50:00 | 10:10:00 |  |  | 07:30:00 | 08:10:00 |  |  |  |  |  | Stop Time
 | Button up | 10 |  |  |  |  |  |  | Actual Departure time of 3rd pick up | 18:20:00 | 19:00:00 | 19:40:00 | 20:45:00 | 19:00:00 | 19:40:00 |  |  | 20:40:00 | 23:00:00 | 1900-01-01 00:20:00 | 1900-01-01 01:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:40:00 | 07:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Time
 | Drive time | M-Tech |  |  |  |  |  |  | Available Departure time for 4th pick up | 20:50:00 | 21:30:00 | 22:10:00 | 22:35:00 | 20:50:00 | 21:30:00 |  |  | 23:10:00 | 1900-01-01 01:30:00 | 1900-01-01 02:50:00 | 1900-01-01 03:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:10:00 | 09:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # of Trucks
 | Scale | 20 |  |  |  |  |  |  | Actual Departure time of 4th pick up |  |  |  |  | 21:25:00 | 22:05:00 |  |  | 23:40:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Avg. Time Between Trucks
 | Unload | 10 |  |  |  |  |  |  | Available Departure time for 5th pick up |  |  |  |  | 23:15:00 | 23:55:00 |  |  | 1900-01-01 02:10:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Line Speed | 350
 |  |  |  |  |  |  |  |  | Actual Departure time of 5th pick up
 | Start time for 3rd Shift Hanging | 16:55:00 |  |  |  |  |  |  | End of Shift Time
 | Chain Speed | 140 |  |  |  |  |  |  | Total Work Hours (No Lunch)