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

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 | 45101 | Store | Hammond | 03:45:00 | 03:58:00 |  | 462 | 229 |  |  |  |  | 434 |  |  |  |  |  | 525
08:00:00
09:00:00 |  |  |  |  |  |  |  |  | 143
10:00:00 |  |  |  |  |  |  |  |  | 56
11:00:00 |  |  |  |  |  |  |  |  | 15 |  | 11:30:00 | 12:00:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 12:30:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:30:00 |  |  |  |  | 13:50: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 | 45102 | DC | Hammond | 02:34:00 | 04:00:00 |  | [NAME] | 150
08:00:00 |  |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  |  | [NAME] | 114
10:00:00 |  |  |  |  |  |  |  | [NAME] | 27 |  | 10:14:00 | 10:20: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 | L325 | 45103 | DC | Hammond | 03:37:00 | 04:09:00 |  | [NAME] | 169
08:00:00 |  |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  |  | [NAME] | 67 |  | 09:45:00 | 09:50: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 | 21858 | 45104 | DC | Hammond | 03:00:00 | 03:53:00 |  | [NAME] | 149
08:00:00 |  |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  |  | [NAME] | 58 |  | 09:23:00 | 09:45: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 | L111 | 45105 | DC | Hammond | 03:39:00 | 03:54:00 |  | [NAME] | 150
08:00:00 |  |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  |  | [NAME] | 58
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 09:30:00 | 09:40: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 | 21605 | 45106 | DC | Hammond | 03:00:00 | 04:36:00 |  | [NAME] | 140
08:00:00 |  |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  |  | [NAME] | 80
10:00:00 |  |  |  |  |  |  |  | [NAME] | 20 |  | 10:13:00 | 10:20:00
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00