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

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 # | DC or Store | 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 | 22819 | 47201 | Store | Hammond | 03:27:00 | 03:45:00 | OK | 410 |  |  |  |  | OK | 434 |  |  |  |  |  | 525 |  |  |  |  | OK
08:00:00
09:00:00 |  |  |  |  |  |  |  |  | 198
10:00:00
11:00:00 |  |  |  |  |  |  |  |  |  |  | 11:06:00 | 11:30:00
12:00:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 14:30:00 |  |  |  |  | 14:53:00 | 14:54:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | 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 | 32841 | 47202 | Store | Hammond | 03:16:00 | 03:35:00 | OK | 410 |  |  |  |  | OK | 462 |  |  |  |  |  | 429
08:00:00
09:00:00 |  |  |  |  |  |  |  |  | 165
10:00:00
11:00:00 |  |  |  |  |  |  |  |  |  |  | 10:56:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  | 12:22:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:56:00 | 13:29:00 | OK |  |  |  | 13:41:00 | 14:39:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | 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 | 32804 | 47203 | Store | Hammond | 04:03:00 | 04:40:00 | OK | 574 |  |  |  |  | OK | 442
08:00:00
09:00:00 |  |  |  |  |  |  |  |  | 204
10:00:00
11:00:00
12:00:00 |  |  |  |  |  |  |  |  |  |  | 12:14:00 | 12:59:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:19:00 | 14:57:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | 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 | L325 | 47204 | Store | Hammond | 03:00:00 | 04:08:00 | OK | 458 |  |  |  |  |  | 496
08:00:00
09:00:00 |  |  |  |  |  |  |  |  | 151
10:00:00 |  |  |  |  |  |  |  |  |  |  | 10:56:00
11:00:00 |  |  |  |  |  |  |  |  |  |  |  | 11:48:00
12:00:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:21:00 | 14:21:00 | OK
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | 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 | 52023 | 47205 | Store | Hammond | 04:20:00 | 04:26:00 | OK | 528 |  |  |  |  | OK | 595
08:00:00
09:00:00 |  |  |  |  |  |  |  |  | 71 |  | 09:53:00
10:00:00 |  |  |  |  |  |  |  |  |  |  |  | 10:53:00
11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:58:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:48:00 | OK
13:30:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | 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 | 91026 | 47206 | Store | Hammond | 03:53:00 | 04:09:00 | OK | 595 |  |  |  |  | OK | 550 |  |  |  |  |  | 458
08:00:00
09:00:00 |  |  |  |  |  |  |  |  | 173
10:00:00
11:00:00
12:00:00 |  |  |  |  |  |  |  |  |  |  | 12:34:00 | 13:27:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:57:00 | 14:58:00 | OK |  |  |  | 16:05:00 | 16:25:00 | OK