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

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 | 34084 | 44701 | Store | Hammond | 03:45:00 | 04:00:00 |  | 429 | 239 |  |  |  |  | 525
08:00:00 |  |  |  |  |  |  |  |  | 163
09:00:00 |  |  |  |  |  |  |  |  | 115
10:00:00 |  |  |  |  |  |  |  |  | 27
11:00:00 |  |  |  |  |  |  |  |  |  |  | 11:40:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  | 12:45:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:15:00 | 13:45: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 | 32802 | 44702 | DC | Hammond | 04:00:00 | 04:31:00 |  | [NAME] | 169
08:00:00 |  |  |  |  |  |  |  | [NAME] | 100
09:00:00 |  |  |  |  |  |  |  | [NAME] | 45
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10:00:00 | 10:15:00
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 | 20954 | 44703 | DC | Hammond | 03:47:00 | 03:53:00 |  | [NAME] | 131
08:00:00 |  |  |  |  |  |  |  | [NAME] | 57
09:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 09:15:00 | 09:35:00
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 | 801478 | 44704 | DC | Hammond | 03:45:00 | 04:07:00 |  | [NAME] | 154
08:00:00 |  |  |  |  |  |  |  | [NAME] | 79
09:00:00 |  |  |  |  |  |  |  | [NAME] | 12
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 09:30:00 | 09:35:00
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 | 21366 | 44705 | DC | Hammond | 04:15:00 | 04:25:00 |  | [NAME] | 160
08:00:00 |  |  |  |  |  |  |  | [NAME] | 90
09:00:00 |  |  |  |  |  |  |  | [NAME] | 50
10:00:00 |  |  |  |  |  |  |  | [NAME] | 10
11:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10:20:00 | 10:40:00
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 | 21445 | 44706 | DC | Hammond | 04:03:00 | 04:24:00 |  | [NAME] | 175
08:00:00 |  |  |  |  |  |  |  | [NAME] | 106
09:00:00 |  |  |  |  |  |  |  | [NAME] | 39
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10:00:00 | 10:18:00
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00