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

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 | 32841 | 42801 | Store | Hammond | 03:00:00 | 03:43:00 |  | 574 |  |  |  |  |  | 424 |  |  |  |  |  | 525
08:00:00 |  |  |  |  |  |  |  |  | 218
09:00:00 |  |  |  |  |  |  |  |  | 131
10:00:00 |  |  |  |  |  |  |  |  | 50
11:00:00 |  |  |  |  |  |  |  |  |  |  | 10:55:00 | 11:29:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:03:00 | 14;00 |  |  | 13 |  | 14:20: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 | 21772 | 42802 | DC | Hammond | 04:00:00 | 04:15:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 165
09:00:00 |  |  |  |  |  |  |  | [NAME] | 79
10:00:00 |  |  |  |  |  |  |  | [NAME] | 10 |  | 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 | 32537 | 42803 | DC | Hammond | 03:51:00 | 04:30:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 175
09:00:00 |  |  |  |  |  |  |  | [NAME] | 99
10:00:00 |  |  |  |  |  |  |  | [NAME] | 20 |  | 10:30:00 | 10:40: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 | 34084 | 42804 | DC | Hammond | 03:45:00 | 04:00:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 87
09:00:00 |  |  |  |  |  |  |  | [NAME] | 6 |  | 09:45:00 | 10:00: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 | 32502 | 42805 | DC | Hammond | 04:00:00 | 04:40:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 200
09:00:00 |  |  |  |  |  |  |  | [NAME] | 160
10:00:00 |  |  |  |  |  |  |  | [NAME] | 87
11:00:00 |  |  |  |  |  |  |  | [NAME] | 18 |  | 11:45:00 | 11:50: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 | 32802 | 42806 | DC | Hammond | 04:00:00 | 04:19:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 119
09:00:00 |  |  |  |  |  |  |  | [NAME] | 56
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 09:55:00 | 10:02:00
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00