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

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 | 21445 | 42201 | Store | Hammond | 03:24:00 | 04:25:00 | OK | 463 |  |  |  |  |  | 442
08:00:00 |  |  |  |  |  |  |  |  | 200
09:00:00 |  |  |  |  |  |  |  |  | 93
10:00:00 |  |  |  |  |  |  |  |  | 31
11:00:00 |  |  |  |  |  |  |  |  |  |  | 10:49:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 | OK |  | 124
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58 |  | 14:42: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 | 21366 | 42202 | DC | Hammond | 04:10:00 | 05:00:00 | OK | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 201
09:00:00 |  |  |  |  |  |  |  | [NAME] | 100
10:00:00 |  |  |  |  |  |  |  | [NAME] | 64
11:00:00 |  |  |  |  |  |  |  | [NAME] | 53
12:00:00 |  |  |  |  |  |  |  |  |  |  | 12:05:00 | 13:15:00 | OK
13:00: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 | 2429 | 42203 | DC | Hammond | 03:49:00 | 04:04:00 | OK | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 142
09:00:00 |  |  |  |  |  |  |  | [NAME] | 23 |  | 09:30:00 | 09:45:00 | OK
10:00:00 |  |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00: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 | 34084 | 42204 | DC | Hammond | 03:33:00 | 04:05:00 | OK | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 125
09:00:00 |  |  |  |  |  |  |  | [NAME] | 15 |  | 09:45:00 | 09:55:00 | OK
10:00:00 |  |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00: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 | 21858 | 42205 | DC | Hammond | 03:00:00 | 03:50:00 | OK | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 231
09:00:00 |  |  |  |  |  |  |  | [NAME] | 139
10:00:00 |  |  |  |  |  |  |  | [NAME] | 73
11:00:00 |  |  |  |  |  |  |  | [NAME] | 5 |  | 11:15:00 | 11:20:00 | OK
13:00:00
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 | L173 | 42206 | DC | Hammond | 03:00:00 | 03:56:00 | OK | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 114 |  | 08:59:00 | 915 | OK
09:00:00 |  |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00