Spreadsheet: 875658d1722270888-array-hours-on-the-road-array-count-hours-on-road
Sheet: Logistics

 |  | Cycle of 1 |  |  |  |  |  |  |  |  | Cycle of 2 |  |  |  |  |  |  |  |  | Cycle of 3 |  |  |  |  |  |  |  |  | Cycle of 4 |  |  |  |  |  |  |  |  | Cycle of 5 |  |  |  |  |  |  |  |  | Cycle of 6
 | Days | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  | Days | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  | Days | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  | Days | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  | Days | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  | Days | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | Hours |  |  |  |  |  |  |  |  | Hours |  |  |  |  |  |  |  |  | Hours |  |  |  |  |  |  |  |  | Hours |  |  |  |  |  |  |  |  | Hours |  |  |  |  |  |  |  |  | Hours
 | 0 | 1 | 0 | 0 | 3 | 0 | 0 | 0 |  | 0 | 1 | 0 | 0 | 3 | 0 | 0 | 0 |  | 0 | 1 | 0 | 0 | 3 | 0 | 0 | 0 |  | 0 | 1 | 0 | 0 | 3 | 0 | 0 | 0 |  | 0 | 1 | 0 | 0 | 3 | 0 | 0 | 0 |  | 0 | 1 | 0 | 0 | 3 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 4 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 4 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 4 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 4 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 4 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 4 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 6 | 0 | 5 |  |  | 0 | 0 | 0 | 0 | 6 | 0 | 5 |  |  | 0 | 0 | 0 | 0 | 6 | 0 | 5 |  |  | 0 | 0 | 0 | 0 | 6 | 0 | 5 |  |  | 0 | 0 | 0 | 0 | 6 | 0 | 5 |  |  | 0 | 0 | 0 | 0 | 6 | 0 | 5
 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 3 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 3 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 3 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 3 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 3 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 3 | 0
 |  | 0 | 5 | 0 | 0 | 1 | 0 | 0 |  |  | 0 | 5 | 0 | 0 | 1 | 0 | 0 |  |  | 0 | 5 | 0 | 0 | 1 | 0 | 0 |  |  | 0 | 5 | 0 | 0 | 1 | 0 | 0 |  |  | 0 | 5 | 0 | 0 | 1 | 0 | 0 |  |  | 0 | 5 | 0 | 0 | 1 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 2 | 0 | 0 | 0 | 0 | 0 | 6 |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 6 |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 6 |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 6 |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 6 |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 6
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 4 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 4 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 4 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 4 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 4 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 4 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 2 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 2 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 2 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 2 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 2 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 2 | 0 | 0
 |  | 0 | 0 | 2 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 2 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 2 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 2 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 2 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 2 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 4 | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 4 | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 4 | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 4 | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 4 | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 4 | 1
 |  | 0 | 6 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 6 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 6 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 6 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 6 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 6 | 0 | 0 | 0 | 0 | 0
 |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 5 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 5 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 5 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 5 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 5 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 5 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Required | 43 | 116 | 144 | 144 | 144 | 144 | 144
 | 1 | 24 | 24 | 4 | 24 |  | 24 |  |  | 1 | 24 | 24 | 4 | 24 | 7 | 24 | 18 |  | 1 | 24 | 24 | 4 | 24 | 7 | 24 | 18 |  | 1 | 24 | 24 | 4 | 24 | 7 | 24 | 18 |  | 1 | 24 | 24 | 4 | 24 | 7 | 24 | 18 |  | 1 | 24 | 24 | 4 | 24 | 7 | 24 | 18
 | 1 | 0 | 0 | 20 | 0 | 17 | 0 | 6 |  | 1 | 0 | 0 | 20 | 0 | 17 | 0 | 6 |  | 1 | 0 | 0 | 20 | 0 | 17 | 0 | 6 |  | 1 | 0 | 0 | 20 | 0 | 17 | 0 | 6 |  | 1 | 0 | 0 | 20 | 0 | 17 | 0 | 6 |  | 1 | 0 | 0 | 20 | 0 | 17 | 0 | 6
 | 2 | 15 | 24 | 17 | 24 | 16 | 24 | 24 |  | 2 | 15 | 24 | 17 | 24 | 16 | 24 | 24 |  | 2 | 15 | 24 | 17 | 24 | 16 | 24 | 24 |  | 2 | 15 | 24 | 17 | 24 | 16 | 24 | 24 |  | 2 | 15 | 24 | 17 | 24 | 16 | 24 | 24 |  | 2 | 15 | 24 | 17 | 24 | 16 | 24 | 24
 | 2 | 0 | 0 | 7 | 0 | 8 | 0 | 0 |  | 2 | 0 | 0 | 7 | 0 | 8 | 0 | 0 |  | 2 | 0 | 0 | 7 | 0 | 8 | 0 | 0 |  | 2 | 0 | 0 | 7 | 0 | 8 | 0 | 0 |  | 2 | 0 | 0 | 7 | 0 | 8 | 0 | 0 |  | 2 | 0 | 0 | 7 | 0 | 8 | 0 | 0
 | 3 | 4 | 24 | 24 | 24 | 24 | 6 | 24 |  | 3 | 4 | 24 | 24 | 24 | 24 | 6 | 24 |  | 3 | 4 | 24 | 24 | 24 | 24 | 6 | 24 |  | 3 | 4 | 24 | 24 | 24 | 24 | 6 | 24 |  | 3 | 4 | 24 | 24 | 24 | 24 | 6 | 24 |  | 3 | 4 | 24 | 24 | 24 | 24 | 6 | 24
 | 3 | 0 | 0 | 0 | 0 | 0 | 18 | 0 |  | 3 | 0 | 0 | 0 | 0 | 0 | 18 | 0 |  | 3 | 0 | 0 | 0 | 0 | 0 | 18 | 0 |  | 3 | 0 | 0 | 0 | 0 | 0 | 18 | 0 |  | 3 | 0 | 0 | 0 | 0 | 0 | 18 | 0 |  | 3 | 0 | 0 | 0 | 0 | 0 | 18 | 0
 | 4 | 0 | 22 | 24 | 13 | 24 | 18 | 24 |  | 4 | 0 | 22 | 24 | 13 | 24 | 18 | 24 |  | 4 | 0 | 22 | 24 | 13 | 24 | 18 | 24 |  | 4 | 0 | 22 | 24 | 13 | 24 | 18 | 24 |  | 4 | 0 | 22 | 24 | 13 | 24 | 18 | 24 |  | 4 | 0 | 22 | 24 | 13 | 24 | 18 | 24
 | 4 | 0 | 0 | 0 | 11 | 0 | 6 | 0 |  | 4 | 0 | 0 | 0 | 11 | 0 | 6 | 0 |  | 4 | 0 | 0 | 0 | 11 | 0 | 6 | 0 |  | 4 | 0 | 0 | 0 | 11 | 0 | 6 | 0 |  | 4 | 0 | 0 | 0 | 11 | 0 | 6 | 0 |  | 4 | 0 | 0 | 0 | 11 | 0 | 6 | 0
 | 5 | 0 | 17 | 24 | 22 | 24 | 24 | 3 |  | 5 | 0 | 17 | 24 | 22 | 24 | 24 | 3 |  | 5 | 0 | 17 | 24 | 22 | 24 | 24 | 3 |  | 5 | 0 | 17 | 24 | 22 | 24 | 24 | 3 |  | 5 | 0 | 17 | 24 | 22 | 24 | 24 | 3 |  | 5 | 0 | 17 | 24 | 22 | 24 | 24 | 3
 | 5 | 0 | 0 | 0 | 2 | 0 | 0 | 21 |  | 5 | 0 | 0 | 0 | 2 | 0 | 0 | 21 |  | 5 | 0 | 0 | 0 | 2 | 0 | 0 | 21 |  | 5 | 0 | 0 | 0 | 2 | 0 | 0 | 21 |  | 5 | 0 | 0 | 0 | 2 | 0 | 0 | 21 |  | 5 | 0 | 0 | 0 | 2 | 0 | 0 | 21
 | 6 | 0 | 5 | 24 | 24 | 3 | 24 | 9 |  | 6 | 0 | 5 | 24 | 24 | 3 | 24 | 9 |  | 6 | 0 | 5 | 24 | 24 | 3 | 24 | 9 |  | 6 | 0 | 5 | 24 | 24 | 3 | 24 | 9 |  | 6 | 0 | 5 | 24 | 24 | 3 | 24 | 9 |  | 6 | 0 | 5 | 24 | 24 | 3 | 24 | 9
 | 6 | 0 | 0 | 0 | 0 | 21 | 0 | 15 |  | 6 | 0 | 0 | 0 | 0 | 21 | 0 | 15 |  | 6 | 0 | 0 | 0 | 0 | 21 | 0 | 15 |  | 6 | 0 | 0 | 0 | 0 | 21 | 0 | 15 |  | 6 | 0 | 0 | 0 | 0 | 21 | 0 | 15 |  | 6 | 0 | 0 | 0 | 0 | 21 | 0 | 15
 | Workings
Form ulas | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
Form ulas | 1 | 0 |  |  |  |  |  |  |  | 1 | 0 |  |  |  |  |  |  |  | 1 | 0 |  |  |  |  |  |  |  | 1 | 0 |  |  |  |  |  |  |  | 1 | 0 |  |  |  |  |  |  |  | 1 | 0
Form ulas
Form ulas | 2 |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  | 2
Form ulas | 2 | 0 |  |  |  |  |  |  |  | 2 | 0 |  |  |  |  |  |  |  | 2 | 0 |  |  |  |  |  |  |  | 2 | 0 |  |  |  |  |  |  |  | 2 | 0 |  |  |  |  |  |  |  | 2 | 0
Form ulas
Form ulas | 3 |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 3
Form ulas | 3 | 0 |  |  |  |  |  |  |  | 3 | 0 |  |  |  |  |  |  |  | 3 | 0 |  |  |  |  |  |  |  | 3 | 0 |  |  |  |  |  |  |  | 3 | 0 |  |  |  |  |  |  |  | 3 | 0
Form ulas
Form ulas | 4 |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  | 4
Form ulas | 4 | 0 |  |  |  |  |  |  |  | 4 | 0 |  |  |  |  |  |  |  | 4 | 0 |  |  |  |  |  |  |  | 4 | 0 |  |  |  |  |  |  |  | 4 | 0 |  |  |  |  |  |  |  | 4 | 0
Form ulas
Form ulas | 5 |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | 5
Form ulas | 5 | 0 |  |  |  |  |  |  |  | 5 | 0 |  |  |  |  |  |  |  | 5 | 0 |  |  |  |  |  |  |  | 5 | 0 |  |  |  |  |  |  |  | 5 | 0 |  |  |  |  |  |  |  | 5 | 0
Form ulas
Form ulas | 6 |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  | 6
Form ulas | 6 | 0 |  |  |  |  |  |  |  | 6 | 0 |  |  |  |  |  |  |  | 6 | 0 |  |  |  |  |  |  |  | 6 | 0 |  |  |  |  |  |  |  | 6 | 0 |  |  |  |  |  |  |  | 6 | 0
Match examples
Match examples
Match examples
Match examples
Match examples
Match examples
Match examples
Match examples
Match examples
Match examples
Match examples
Match examples
Match examples
Match examples
Match examples
Match examples
Match examples