Spreadsheet: 121881d1316477021-work-schedule-multiple-outputs-from-one-search-criteria-trucking-schedule-example
Sheet: Sheet1

 |  |  |  |  | Helper 1 | Helper 2 |  | Type |  | Names |  | Loadout time
 |  |  |  |  |  |  |  | Trailer |  | AJ Cancella |  | 06:30:00
TRUCKING SCHEDULE |  |  |  |  |  |  |  | Triaxle |  | [NAME] |  | 07:00:00
 |  |  |  |  |  |  |  | Quad |  | [NAME] |  | 07:30:00
 |  |  |  |  |  |  |  | Quint |  | [NAME] |  | 08:00:00
 |  |  |  |  |  |  |  | Tandem |  | [NAME] |  | 08:30:00
 |  |  |  |  |  |  |  |  |  | No Work
Truck | Type | [NAME] | Loadout time | Location
Truck 1 | Trailer | [NAME] | 07:00:00 | Plant | 1 | 37
Truck 2 | Trailer | [NAME] | 07:30:00 | Plant | 2 | 37
Truck 3 | Trailer | [NAME] | 07:30:00 | Plant | 3 | 37
Truck 4 | Trailer | [NAME] | 07:30:00 | Plant | 4 | 37
Truck 5 | Triaxle | [NAME] | 06:30:00 | Plant | 5 | 37
Truck 6 | Trailer | [NAME] | 06:30:00 | Plant | 6 | 37
Truck 7 | Triaxle | [NAME] | 06:30:00 | STP | 1 | 25
Truck 8 | Triaxle | AJ Cancella | 07:30:00 | STP | 1 | 9
Truck 9 | Trailer | [NAME] | 06:30:00 | Plant | 7 | 37
Truck 10 | Trailer | [NAME] | 07:30:00 | Plant | 2 | 25
Truck 11 | Trailer | [NAME] | 06:30:00 | Plant | 8 | 37
Truck 12 | Quint | [NAME] | 06:30:00 | Plant | 3 | 25
Truck 13 | Triaxle | [NAME] | 06:30:00 | Plant | 9 | 37
Truck 14 | Quint | [NAME] | 07:30:00 | Plant | 1 | 5
Truck 15 | Tandem | [NAME] | 06:30:00 | Plant | 1 | 9
Truck 16 | Quad | [NAME] | 07:30:00 | STP | 4 | 25
Truck 17 | Triaxle | No Work | 06:30:00 | STP | 1 | 15
Truck 18 | Trailer | No Work | 07:30:00 | Plant | 2 | 15
Truck 19 | Trailer | No Work | 06:30:00 | Plant | 3 | 15
Truck 20 | Trailer | [NAME] | 07:30:00 | Plant | 10 | 37
Truck 21 | Trailer | [NAME] | 06:30:00 | Plant | 5 | 25
Truck 22 | Triaxle | [NAME] | 07:30:00 | Plant | 11 | 37
Truck 23 | Trailer | [NAME] | 06:30:00 | Plant | 12 | 37
Truck 24 | Triaxle | [NAME] | 07:30:00 | Plant | 13 | 37
Truck 25 | Triaxle | [NAME] | 06:30:00 | STP | 2 | 9
Truck 26 | Trailer | [NAME] | 07:30:00 | STP | 6 | 25
Truck 27 | Trailer | AJ Cancella | 06:30:00 | Plant | 2 | 9
Truck 28 | Trailer | [NAME] | 07:30:00 | Plant | 14 | 37
Truck 29 | Quint | [NAME] | 06:30:00 | Plant | 7 | 25
Truck 30 | Triaxle | AJ Cancella | 06:30:00 | Plant | 3 | 9
Truck 31 | Quint | [NAME] | 06:30:00 | Plant | 8 | 25
Truck 32 | Tandem | [NAME] | 07:30:00 | Plant | 15 | 37
Truck 33 | Quad | [NAME] | 06:30:00 | Plant | 2 | 5
Truck 34 | Triaxle | [NAME] | 07:30:00 | STP | 3 | 9
Truck 35 | Trailer | [NAME] | 06:30:00 | STP | 9 | 25
Truck 36 | Trailer | No Work | 06:30:00 | Plant | 4 | 15
Truck 37 | Trailer | No Work | 06:30:00 | Plant | 5 | 15
Truck 38 | Trailer | No Work | 07:30:00 | Plant | 6 | 15
Truck 39 | Triaxle | [NAME] | 06:30:00 | Plant | 16 | 37
Truck 40 | Trailer | [NAME] | 07:30:00 | Plant | 10 | 25
Truck 41 | Triaxle | [NAME] | 06:30:00 | Plant | 17 | 37
Truck 42 | Triaxle | [NAME] | 07:30:00 | Plant | 18 | 37
Truck 43 | Trailer | [NAME] | 06:30:00 | STP | 19 | 37
Truck 44 | Trailer | [NAME] | 07:30:00 | STP | 4 | 9
Truck 45 | Trailer | [NAME] | 06:30:00 | Plant | 11 | 25
Truck 46 | Quint | AJ Cancella | 07:30:00 | Plant | 4 | 9
Truck 47 | Triaxle | [NAME] | 06:30:00 | Plant | 20 | 37
Truck 48 | Quint | [NAME] | 07:30:00 | Plant | 12 | 25
Truck 49 | Tandem | AJ Cancella | 06:30:00 | Plant | 5 | 9
Truck 50 | Quad | [NAME] | 07:30:00 | Plant | 13 | 25
Truck 51 | Triaxle | [NAME] | 06:30:00 | Plant | 21 | 37
Truck 52 | Trailer | [NAME] | 07:30:00 | STP | 3 | 5
Truck 53 | Trailer | [NAME] | 06:30:00 | STP | 5 | 9
Truck 54 | Trailer | [NAME] | 06:30:00 | Plant | 14 | 25
Truck 55 | Trailer | No Work | 06:30:00 | Plant | 7 | 15
Truck 56 | Triaxle | No Work | 07:30:00 | Plant | 8 | 15
Truck 57 | Trailer | No Work | 06:30:00 | Plant | 9 | 15
Truck 58 | Triaxle | [NAME] | 07:30:00 | Plant | 22 | 37
Truck 59 | Triaxle | [NAME] | 06:30:00 | Plant | 15 | 25
Truck 60 | Trailer | [NAME] | 06:30:00 | Plant | 23 | 37
Truck 61 | Trailer | [NAME] | 06:30:00 | STP | 24 | 37
Truck 62 | Trailer | [NAME] | 07:30:00 | STP | 25 | 37
Truck 63 | Quint | [NAME] | 06:30:00 | Plant | 6 | 9
Truck 64 | Triaxle | [NAME] | 07:30:00 | Plant | 16 | 25
Truck 65 | Quint | AJ Cancella | 06:30:00 | Plant | 6 | 9
Truck 66 | Tandem | [NAME] | 07:30:00 | Plant | 26 | 37
Truck 67 | Quad | [NAME] | 06:30:00 | Plant | 17 | 25
Truck 68 | Triaxle | AJ Cancella | 07:30:00 | Plant | 7 | 9
Truck 69 | Trailer | [NAME] | 06:30:00 | Plant | 18 | 25
Truck 70 | Trailer | [NAME] | 07:30:00 | STP | 27 | 37
Truck 71 | Trailer | [NAME] | 06:30:00 | STP | 4 | 5
Truck 72 | Trailer | [NAME] | 06:30:00 | Plant | 7 | 9
Truck 73 | Triaxle | [NAME] | 06:30:00 | Plant | 19 | 25
Truck 74 | Trailer | No Work | 07:30:00 | Plant | 10 | 15
Truck 75 | Triaxle | No Work | 06:30:00 | Plant | 11 | 15
Truck 76 | Triaxle | No Work | 07:30:00 | Plant | 12 | 15
Truck 77 | Trailer | [NAME] | 06:30:00 | Plant | 28 | 37
Truck 78 | Trailer | [NAME] | 07:30:00 | Plant | 20 | 25
Truck 79 | Trailer | [NAME] | 06:30:00 | STP | 29 | 37
Truck 80 | Quint | [NAME] | 07:30:00 | STP | 30 | 37
Truck 81 | Triaxle | [NAME] | 06:30:00 | Plant | 31 | 37
Truck 82 | Quint | [NAME] | 07:30:00 | Plant | 8 | 9
Truck 83 | Tandem | [NAME] | 06:30:00 | Plant | 21 | 25
Truck 84 | Quad | AJ Cancella | 06:30:00 | Plant | 8 | 9
Truck 85 | Triaxle | [NAME] | 06:30:00 | Plant | 32 | 37
Truck 86 | Trailer | [NAME] | 07:30:00 | Plant | 22 | 25
Truck 87 | Trailer | AJ Cancella | 06:30:00 | Plant | 9 | 9
Truck 88 | Trailer | [NAME] | 07:30:00 | STP | 23 | 25
Truck 89 | Trailer | [NAME] | 06:30:00 | STP | 33 | 37
Truck 90 | Triaxle | [NAME] | 07:30:00 | Plant | 5 | 5
Truck 91 | Trailer | [NAME] | 06:30:00 | Plant | 9 | 9
Truck 92 | Triaxle | [NAME] | 07:30:00 | Plant | 24 | 25
Truck 93 | Triaxle | No Work | 06:30:00 | Plant | 13 | 15
Truck 94 | Trailer | No Work | 07:30:00 | Plant | 14 | 15
Truck 95 | Trailer | No Work | 06:30:00 | Plant | 15 | 15
Truck 96 | Trailer | [NAME] | 06:30:00 | Plant | 34 | 37
Truck 97 | Quint | [NAME] | 06:30:00 | STP | 25 | 25
Truck 98 | Triaxle | [NAME] | 07:30:00 | STP | 35 | 37
Truck 99 | Quint | [NAME] | 06:30:00 | Plant | 36 | 37
Truck 100 | Tandem | [NAME] | 07:30:00 | Plant | 37 | 37