Spreadsheet: 821147d1678465566-formula-help-next-available-record-with-conditions-lhs-tool-revised
Sheet: Sunday Day reference (2)

 |  |  |  | Farm | [NAME] | House Number | Trailer Number | Driver | M-Tech Driving Time and Load Elements | Expected Catcher Start Time (Leave Plant) | Expected Driver Start Time | Expected Time to be In Yard | Expected Time (Driver) to [NAME] | Expected Time Birds hit SIA | Expected Time Mods Ready To Leave Yard | Yard Time (Hours) | Birds/Tray | Birds/Truck | EV Line | Driver | Trips |  | Line 1 | Line 2
 | Drive Time | M-Tech |  | [NAME] | Kauffman #1 | 3 | 1 | A |  |  |  | 12:00:00 |  |  |  |  | 63 |  | 1 | A |  | 14:00:00
 | Set up | 10 |  | [NAME] | Kauffman #1 | 3 | 2 | B |  |  |  |  |  |  |  |  | 63 |  | 2 | B |  | 14:10:00
 | Load | 40 |  | [NAME] | Kauffman #1 | 3 | 3 | C |  |  |  |  |  |  |  |  | 63 |  | 1 | C |  | 14:20:00
 | Button up | 10 |  | [NAME] | Kauffman #1 | 3 | 4 | D |  |  |  |  |  |  |  |  | 56 |  | 2 | D |  | 14:30:00
 | Drive time | M-Tech |  | [NAME] | Kauffman #1 | 3 | 5 | E |  |  |  |  |  |  |  |  | 56 |  | 1 | E |  | 14:40:00
 | Scale | 20 |  | [NAME] | Kauffman #1 | 1 | 6 | F |  |  |  | 14:00:00 |  |  |  |  | 63 |  | 2 | F |  | 14:50:00
 | Allow skates to become available |  |  | [NAME] | Kauffman #1 | 1 | 7 | G |  |  |  |  |  |  |  |  | 63 |  | 1 | G |  | 15:00:00
 | Unload trailer | 2.5 |  | [NAME] | Kauffman #1 | 1 | 8 | A |  |  |  |  |  |  |  |  | 63 |  | 2 | H |  | 15:10:00
 | Wash and prep trailer to waiting lot | 10 |  | [NAME] | Kauffman #1 | 1 | 9 | B |  |  |  |  |  |  |  |  | 56 |  | 1 | I |  | 15:20:00
 | Loading empty mods | 12 |  | [NAME] | Kauffman #1 | 1 | 10 | C |  |  |  |  |  |  |  |  | 56 |  | 2 | J |  | 15:30:00
 |  |  |  | [NAME] | Kauffman #2 | 2 | 11 | H |  |  |  | 15:00:00 |  |  |  |  | 63 |  | 1 | K |  | 15:40:00
 | [NAME] | 15:30:00 |  | [NAME] | Kauffman #2 | 2 | 12 | I |  |  |  |  |  |  |  |  | 63 |  | 2 | L |  | 15:50:00
 | Start Denester |  |  | [NAME] | Kauffman #2 | 2 | 13 | J |  |  |  |  |  |  |  |  | 63 |  | 1 | M |  | 16:00:00
 | [NAME] | 16:55:00 |  | [NAME] | Kauffman #2 | 2 | 14 | D |  |  |  |  |  |  |  |  | 63 |  | 2 | N |  | 16:10:00
 |  |  |  | [NAME] | Kauffman #2 | 2 | 15 | E |  |  |  |  |  |  |  |  | 56 |  | 1 |  |  | 16:20:00
 |  |  |  | [NAME] | Kauffman #3 | 1 | 16 | K |  |  |  | 15:00:00 |  |  |  |  | 63 |  | 2 |  |  | 16:30:00
 | Chain speed | 140 |  | [NAME] | Kauffman #3 | 1 | 17 | L |  |  |  |  |  |  |  |  | 63 |  | 1 |  |  | 16:40:00
 | Avg. birds/mod |  |  | [NAME] | Kauffman #3 | 1 | 18 | M |  |  |  |  |  |  |  |  | 56 |  | 2 |  |  | 16:50:00
 | Trays/Minute |  |  | [NAME] | Kauffman #3 | 1 | 19 | F |  |  |  |  |  |  |  |  | 56 |  | 1 |  |  | 17:00:00
 | Minutes/Stack |  |  | [NAME] | Kauffman #3 | 1 | 20 | G |  |  |  |  |  |  |  |  | 56 |  | 2 |  |  | 17:10:00
 | Minutes/Trailer |  |  | [NAME] | Kauffman #4 | 3 | 21 | N |  |  |  | 17:00:00 |  |  |  |  | 63 |  | 1 |  |  | 17:20:00
 | Minutes before skates are available |  |  | [NAME] | Kauffman #4 | 3 | 22 | H |  |  |  |  |  |  |  |  | 63 |  | 2 |  |  | 17:30:00
 | Minutes before next 2 trailers needs to be in the yard |  |  | [NAME] | Kauffman #4 | 3 | 1 | I |  |  |  |  |  |  |  |  | 56 |  | 1 |  |  | 17:40:00
 |  |  |  | Cedar [NAME] | Crew #1 | 1 |  |  |  |  |  | 19:00:00 |  |  |  |  | 56 |  | 2 |  |  | 17:50:00
 | Longest yard time while running (Hours) |  |  | Cedar [NAME] | Crew #1 | 1 |  |  |  |  |  |  |  |  |  |  | 56 |  | 1 |  |  | 18:00:00
 |  |  |  | Cedar [NAME] | Crew #1 | 1 |  |  |  |  |  |  |  |  |  |  | 56 |  | 2 |  |  | 18:10:00
 |  |  |  | Cedar [NAME] | Crew #1 | 1 |  |  |  |  |  |  |  |  |  |  | 56 |  | 1 |  |  | 18:20:00
 |  |  |  | Cedar [NAME] | Crew #1 | 1 |  |  |  |  |  |  |  |  |  |  | 56 |  | 2 |  |  | 18:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:50:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:10:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:20:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:50:00