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

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 # | 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 | 43401 | Hammond | 03:45:00 | 04:21:00 |  | 445 | 225 |  |  |  |  | 464
08:00:00 |  |  |  |  |  |  |  | 154
09:00:00 |  |  |  |  |  |  |  | 95
10:00:00 |  |  |  |  |  |  |  | 43 |  | 10:39:00
11:00:00 |  |  |  |  |  |  |  |  |  |  | 11:40:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 90
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:45:00 | 15:09:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | 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 | 43402 | Hammond | 04:00:00 | 04:15:00 |  | [NAME] | 197
08:00:00 |  |  |  |  |  |  | [NAME] | 121
09:00:00 |  |  |  |  |  |  | [NAME] | 67
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:50:00 | 10:00:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | 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 | 21886 | 43403 | Hammond | 03:00:00 | 04:07:00 |  | [NAME] | 196
08:00:00 |  |  |  |  |  |  | [NAME] | 127
09:00:00 |  |  |  |  |  |  | [NAME] | 48
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:30:00 | 09:45:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | 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 | 2384 | 43404 | Hammond | 03:00:00 | 04:14:00 |  | [NAME] | 195
08:00:00 |  |  |  |  |  |  | [NAME] | 117
09:00:00 |  |  |  |  |  |  | [NAME] | 48
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:55:00 | 10:05:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | 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 | 43405 | Hammond | 04:04:00 | 04:15:00 |  | [NAME] | 177
08:00:00 |  |  |  |  |  |  | [NAME] | 117
09:00:00 |  |  |  |  |  |  | [NAME] | 48
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:43:00 | 10:10:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | 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 | 43406 | Hammond | 03:42:00 | 04:11:00 |  | [NAME] | 184
08:00:00 |  |  |  |  |  |  | [NAME] | 117
09:00:00 |  |  |  |  |  |  | [NAME] | 48
10:00:00 |  |  |  |  |  |  | [NAME] | 6 |  | 10:02:00 | 10:10:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00