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

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 | L173 | 42301 | Hammond | 03:00:00 | 04:18:00 |  | 434 | 230 |  |  |  |  | 525 |  |  |  |  |  | 442
08:00:00 |  |  |  |  |  |  |  | 192
09:00:00 |  |  |  |  |  |  |  | 113
10:00:00 |  |  |  |  |  |  |  | 50
11:00:00 |  |  |  |  |  |  |  | 16 |  | 11:30:00 | 12:14:00
12:00:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:46:00 | 13:22:00 |  |  |  | 40 |  | 14:30:00 | 15: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 | 11771 | 42302 | Hammond | 03:00:00 | 04:02:00 |  | [NAME] | 140
08:00:00 |  |  |  |  |  |  | [NAME] | 77
09:00:00 |  |  |  |  |  |  | [NAME] | 39
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:42: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 | 42303 | Hammond | 03:58:00 | 04:25:00 |  | [NAME] | 139
08:00:00 |  |  |  |  |  |  | [NAME] | 67
09:00:00 |  |  |  |  |  |  | [NAME] | 11
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:45: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 | 21329 | 42304 | Hammond | 04:11:00 | 04:22:00 |  | [NAME] | 156
08:00:00 |  |  |  |  |  |  | [NAME] | 80
09:00:00 |  |  |  |  |  |  | [NAME] | 25
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 10:02: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 | 20954 | 42305 | Hammond | 04:45:00 | 05:09:00 |  | [NAME] | 225
08:00:00 |  |  |  |  |  |  | [NAME] | 162
09:00:00 |  |  |  |  |  |  | [NAME] | 96
10:00:00 |  |  |  |  |  |  | [NAME] | 41
11:00:00 |  |  |  |  |  |  | [NAME] |  |  | 11:00:00 | 11:10:00
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 | 2429 | 42306 | Hammond | 03:47:00 | 04:28:00 |  | [NAME] | 168
08:00:00 |  |  |  |  |  |  | [NAME] | 96
09:00:00 |  |  |  |  |  |  | [NAME] | 51
10:00:00 |  |  |  |  |  |  | [NAME] | 4 |  | 10:20:00 | 10:30:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00