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

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 | 32804 | 43801 | Store | Hammond | 04:26:00 | 04:52:00 |  | 428 | 228 |  |  |  |  | 445
08:00:00 |  |  |  |  |  |  |  |  | 196
09:00:00 |  |  |  |  |  |  |  |  | 86
10:00:00 |  |  |  |  |  |  |  |  | 40
11:00:00 |  |  |  |  |  |  |  |  | 7 |  | 11:39:00
12:00:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  | 13:22:00 |  |  | 35 |  | 15: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 | 21323 | 43802 | DC | Hammond | 03:50:00 | 04:15:00 |  | [NAME] | 150
08:00:00 |  |  |  |  |  |  |  | [NAME] | 95
09:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 09:30:00 | 09:40: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 | 21366 | 43803 | DC | Hammond | 03:50:00 | 04:30:00 |  | [NAME] | 190 |  |  |  | AH
08:00:00 |  |  |  |  |  |  |  | [NAME] | 165
09:00:00 |  |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  |  | [NAME] | 21329 | going to | recover | load
12:00:00
13:00:00 |  |  |  |  |  |  |  | 21329 |  | 18 miles |  |  |  | Mobile
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 | 43804 | DC | Hammond | 03:59:00 | 04:23:00 |  | [NAME] | 200
08:00:00 |  |  |  |  |  |  |  | [NAME] | 142
09:00:00 |  |  |  |  |  |  |  | [NAME] | 33
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10:25: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 | 20954 | 43805 | DC | Hammond | 04:13:00 | 04:19:00 |  | [NAME] | 187
08:00:00 |  |  |  |  |  |  |  | [NAME] | 140
09:00:00 |  |  |  |  |  |  |  | [NAME] | 40
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10:17: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 | 21329 | 43806 | DC | Hammond | 04:04:00 | 04:15:00 |  | [NAME] | 178
08:00:00 |  |  |  |  |  |  |  | [NAME] | 148
09:00:00 |  |  |  |  |  |  |  | [NAME] | 35
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10:20:00 | 10:30:00
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00