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

 |  |  |  |  |  |  |  |  |  | 2023-02-19 00:00:00
 |  | Farm | Birds | Birds/Tray | Catcher Crew | Catcher Start Time | [NAME] | Number of Loads | Driver Start Time | Date | Buffer Time | Drive Time | Set up | Load | Button up | Drive time | Scale/Drop | Driver Time | Driver Finish Time | Date | Tie |  | Birds | Birds in Yard |  |  |  | 3rd | Start up Time | 19:15:00 |  | 2023-02-19 13:55:00
 |  | 752 - CORG - HACKENBERGER FAMILY FARM LLC - #2 |  | 56 | Kauffman #1 | 10:00:00 | 12:00:00 |  |  |  | 15 | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3rd | Chain Speed | 375 |  | 2023-02-19 14:25:00
 | Driver # | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3rd | [NAME] | 23:30:00 |  | 2023-02-19 14:55:00
 | Driver # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3rd | Length of Lunch Break | 35 |  | 2023-02-19 15:25:00
 | Driver # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3rd | Time back from Lunch |  |  | 2023-02-19 15:55:00
 | Driver # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shift Change | 03:30:00 |  | 2023-02-19 16:25:00
 | Driver # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st | Chain Speed | 375 |  | 2023-02-19 16:55:00
 | Driver # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st | [NAME] | 07:30:00 |  | 2023-02-19 17:25:00
 |  | 752 - CORG - HACKENBERGER FAMILY FARM LLC - #3 |  | 63 | Kauffman #1 | 13:00:00 | 15:00:00 |  |  |  |  | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st | Length of Lunch Break | 35 |  | 2023-02-19 17:55:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st | Time back from Lunch |  |  | 2023-02-19 18:25:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 18:55:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 19:25:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 21:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 21:05:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 21:15:00
 |  | 752 - CORG - HACKENBERGER FAMILY FARM LLC - #1 |  | 56 | Kauffman #2 | 14:00:00 | 16:00:00 |  |  |  |  | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 21:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 21:35:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 21:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 22:05:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 22:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 22:30:00
 |  | 762 - AGC - DEBRA SHUEY - #1 |  | 63 | Kauffman #2 | 18:00:00 | 20:00:00 |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 22:35:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 22:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 23:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 23:05:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 23:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 00:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 00:45:00
 |  | 935 - AGC - BRETT WAGNER - #3 |  | 63 | Kauffman #3 | 17:00:00 | 19:00:00 |  |  |  |  | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 00:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 01:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 01:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 01:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 01:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 01:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 01:50:00
 |  | 935 - AGC - BRETT WAGNER - #2 |  | 63 | Kauffman #3 | 20:45:00 | 22:45:00 |  |  |  |  | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 02:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 02:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 02:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 03:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 03:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 03:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 04:15:00
 |  | 981 - WEN - BRENDA BALMER - #3 |  | 63 | Kauffman #4 | 17:00:00 | 19:00:00 |  |  |  |  | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 04:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 05:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 05:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 06:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 06:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 07:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:15:00
 |  | 981 - WEN - BRENDA BALMER - #2 |  | 63 | Kauffman #4 | 20:45:00 | 22:45:00 |  |  |  |  | 80
 |  | 947 - AGC - ROBERT REISINGER - #1 |  | 56 | Crew #1 | 21:00:00 | 23:00:00 |  |  |  |  | 30
 |  | 947 - AGC - ROBERT REISINGER - #3 |  | 56 | Crew #1 | 00:00:00 | 02:00:00 |  |  |  |  | 30
 |  | 981 - WEN - BRENDA BALMER - #1 |  | 63 | Kauffman #5 | 02:00:00 | 04:00:00 |  |  |  |  | 30