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

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 | 32502 | 43201 | Store | Hammond | 03:23:00 | 04:14:00 | OK | 462 | 278 |  |  |  |  | 424 |  |  |  |  |  | 525
08:00:00 |  |  |  |  |  |  |  |  | 181
09:00:00 |  |  |  |  |  |  |  |  | 140
10:00:00
11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 Trucks ahead
12:00:00 |  |  |  |  |  |  |  |  |  |  | 12:20:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | of him
13:00:00 |  |  |  |  |  |  |  |  |  |  |  | 13:55:00 | AL |  | 4 |  | 14:25:00 | 15:16:00 |  |  | 10
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 | 21886 | 43202 | DC | Hammond | 03:42:00 | 04:08:00 | OK | [NAME] | 200
08:00:00 |  |  |  |  |  |  |  | [NAME] | 100
09:00:00 |  |  |  |  |  |  |  | [NAME] | 70
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10:10:00 | 10:15:00 | OK
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 | 22819 | 43203 | DC | Hammond | 03:29:00 | 03:55:00 | OK | [NAME] | 150
08:00:00 |  |  |  |  |  |  |  | [NAME] | 60
09:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 09:00:00 | 09:10: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 | L325 | 43204 | DC | Hammond | 03:00:00 | 04:10:00 | OK | [NAME] | 198
08:00:00 |  |  |  |  |  |  |  | [NAME] | 64
09:00:00 |  |  |  |  |  |  |  | [NAME] | 20
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 09:30:00 | 09:48:00 | OK
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 | 52023 | 43205 | DC | Hammond | 04:15:00 | 04:30:00 | OK | [NAME] | 170
08:00:00 |  |  |  |  |  |  |  | [NAME] | 80
09:00:00 |  |  |  |  |  |  |  | [NAME] | 40
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10:14:00 | 10:20:00
11:00:00 |  |  |  |  |  |  |  | [NAME]
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 | 32804 | 43506 | DC | Hammond | 03:48:00 | 04:00:00 | OK | [NAME] | 196
08:00:00 |  |  |  |  |  |  |  | [NAME] | 72
09:00:00 |  |  |  |  |  |  |  | [NAME] | 29
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10:20:00 | 10:25:00 | OK
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00