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

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 | 52041 | 46101 | Store | Hammond | 03:00:00 | 04:00:00 | OK | 447 |  |  |  |  |  | 460
08:00:00 |  |  |  |  |  |  |  |  | 270
09:00:00 |  |  |  |  |  |  |  |  | 185
10:00:00 |  |  |  |  |  |  |  |  | 130 |  |  |  | BE
11:00:00 |  |  |  |  |  |  |  |  | 100
12:00:00 |  |  |  |  |  |  |  |  | 4
13:00:00 |  |  |  |  |  |  |  |  |  |  | 13:30:00 | 14:40:00 |  |  | 116 | 17:15: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 | 46102 | DC | Hammond | 03:50:00 | 03:52:00 | OK | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 90
09:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 08:59:00 | 09:05: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 | 2429 | 46103 | DC | Hammond | 03:43:00 | 04:08:00 | OK | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 154
09:00:00 |  |  |  |  |  |  |  | [NAME] | 59
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10:11: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 | 93036 | 46104 | DC | Hammond | 04:00:00 | 04:15:00 | OK | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 143
09:00:00 |  |  |  |  |  |  |  | [NAME] | 75
10:00:00 |  |  |  |  |  |  |  | [NAME] | 4 |  | 10:00:00 | 10:10: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 | 20954 | 46105 | DC | Hammond | 03:29:00 | 03:56:00 | OK | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 130
09:00:00 |  |  |  |  |  |  |  | [NAME] | 33
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 09:40:00 | 10:00:00 | OK
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 | 629805 | 46106 | DC | Hammond | 04:03:00 | 05:01:00 | OK | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 140
09:00:00 |  |  |  |  |  |  |  | [NAME] | 80
10:00:00 |  |  |  |  |  |  |  | [NAME] | 20 |  | 10:35:00 | 10:45:00 | OK
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00