Spreadsheet: 329476d1404317853-adding-indirect-formula-to-a-countif-es3-cs-wholesale-load-tracking-report-test
Sheet: 5-16

ES3/C&S WHOLESALE LOAD TRACKING
STOP 1 WILL ALWAYS BE ORIGIN - LEAVE SECTION BLANK FOR ANY NON-APPLICALBE STOP, ON ANY GIVE LOAD
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | L173 | 46401 | Hammond | 03:00:00 | 04:00:00 |  | 448 | 147 |  |  |  |  | 445
08:00:00 |  |  |  |  |  |  |  | 90
09:00:00 |  |  |  |  |  |  |  | 50 |  | 09:50:00
10:00:00
11:00:00 |  |  |  |  |  |  |  |  |  |  | 11:12:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 95
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:15:00 | 13:30:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21323 | 46402 | Hammond | 04:00:00 | 04:30:00 |  | [NAME] | 166
08:00:00 |  |  |  |  |  |  | [NAME] | 86
09:00:00 |  |  |  |  |  |  | [NAME] | 35 |  | 09:30:00
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | waiting | 10:30:00
11:00:00 |  |  |  |  |  |  | [NAME] |  |  | on
12:00:00 |  |  |  |  |  |  |  |  |  | empty
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 20954 | 46403 | Hammond | 04:11:00 | 04:24:00 |  | [NAME] | 169
08:00:00 |  |  |  |  |  |  | [NAME] | 104
09:00:00 |  |  |  |  |  |  | [NAME] | 46
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:50:00
11:00:00 |  |  |  |  |  |  | [NAME] |  |  | waiting | 10:40:00
12:00:00 |  |  |  |  |  |  |  |  |  | on
13:00:00 |  |  |  |  |  |  |  |  |  | empty
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21329 | 46404 | Hammond | 04:30:00 | 04:53:00 |  | [NAME] | 166
08:00:00 |  |  |  |  |  |  | [NAME] | 116
09:00:00 |  |  |  |  |  |  | [NAME] | 58
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:55:00
11:00:00 |  |  |  |  |  |  | [NAME] |  |  | waiting | 10:50:00
12:00:00 |  |  |  |  |  |  |  |  |  | on an
13:00:00 |  |  |  |  |  |  |  |  |  | empty
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21858 | 46405 | Hammond | 03:00:00 | 04:37:00 |  | [NAME] | 150
08:00:00 |  |  |  |  |  |  | [NAME] | 130
09:00:00 |  |  |  |  |  |  | [NAME] | 109
10:00:00 |  |  |  |  |  |  | [NAME] | 45
11:00:00 |  |  |  |  |  |  | [NAME] |  | 10:45:00 | 11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21885 | 46406 | Hammond | 03:00:00 | 05:00:00 |  | [NAME] | 200
08:00:00 |  |  |  |  |  |  | [NAME] | 166
09:00:00 |  |  |  |  |  |  | [NAME] | 107
10:00:00 |  |  |  |  |  |  | [NAME] | 45 |  | 10:45:00 | 11:15:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00