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

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 | 42101 | Store | Hammond | 04:16:00 | 04:31:00 |  | 553 |  |  |  |  |  | 447 |  |  |  |  |  | 445
08:00:00 |  |  |  |  |  |  |  |  | 225
09:00:00 |  |  |  |  |  |  |  |  | 142
10:00:00 |  |  |  |  |  |  |  |  | 55
11:00:00 |  |  |  |  |  |  |  |  |  |  | 11:01:00 | 11:43:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 97
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:39:00 | 14:59:00 |  |  | 58
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 | 52041 | 42102 | DC | Hammond | 03:15:00 | 03:45:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 140
09:00:00 |  |  |  |  |  |  |  | [NAME] | 110
10:00:00 |  |  |  |  |  |  |  | [NAME] | 35 |  | 10:35:00 | 10:55: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 | 42103 | DC | Hammond | 03:00:00 | 04:01:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 160
09:00:00 |  |  |  |  |  |  |  | [NAME] | 109
10:00:00 |  |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00 |  |  |  |  |  |  |  |  |  | 14:30:00 | 14;45
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 | 21059 | 42104 | DC | Hammond | 03:00:00 | 04:30:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 150
09:00:00 |  |  |  |  |  |  |  | [NAME] | 80
10:00:00 |  |  |  |  |  |  |  | [NAME] | 20 |  | 10:22:00 | 10:30: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 | 21323 | 42105 | DC | Hammond | 03:00:00 | 04:30:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 98
09:00:00 |  |  |  |  |  |  |  | [NAME] | 18 |  | 09:20:00 | 09:30:00
10:00:00 |  |  |  |  |  |  |  | [NAME]
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 | 21329 | 42106 | DC | Hammond | 03:51:00 | 04:30:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 132
09:00:00 |  |  |  |  |  |  |  | [NAME] | 54 |  | 09:50:00 | 10:00:00
10:00:00 |  |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00