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

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 | L111 | 43201 | Hammond | 03:45:00 | 04:01:00 |  | 520 | 160 |  |  |  |  | 445
08:00:00 |  |  |  |  |  |  |  | 50
09:00:00 |  |  |  |  |  |  |  |  |  | 08:55:00
10:00:00 |  |  |  |  |  |  |  |  |  |  | 09:49:00 |  |  | 83
11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 |  | 11:45:00 | 13:20: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 | 20941 | 43202 | Hammond | 04:03:00 | 04:05:00 |  | [NAME] | 156
08:00:00 |  |  |  |  |  |  | [NAME] | 74
09:00:00 |  |  |  |  |  |  | [NAME] | 12
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:30: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 | 21323 | 43203 | Hammond | 03:30:00 | 04:15:00 |  | [NAME] | 157
08:00:00 |  |  |  |  |  |  | [NAME] | 80
09:00:00 |  |  |  |  |  |  | [NAME] | 18
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:30:00 | 09:40: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 | 21395 | 43204 | Hammond | 04:53:00 | 05:05:00 |  | [NAME] | 241
08:00:00 |  |  |  |  |  |  | [NAME] | 135
09:00:00 |  |  |  |  |  |  | [NAME] | 120
10:00:00 |  |  |  |  |  |  | [NAME] | 48 |  | 11:00:00 | 11:10:00
11:00:00 |  |  |  |  |  |  | [NAME] | 8
12:00:00 |  |  |  |  |  |  | [NAME]
13:00:00 |  |  |  |  |  |  | [NAME]
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 | 422 | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21858 | 43205 | Hammond | 04:36:00 | 05:25:00 |  | [NAME] | 271
08:00:00 |  |  |  |  |  |  | [NAME] | 221
09:00:00 |  |  |  |  |  |  | [NAME] | 168
10:00:00 |  |  |  |  |  |  | [NAME] | 123
11:00:00 |  |  |  |  |  |  | [NAME] | 80 |  | 11:57:00 | 12:15: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 | 2384 | 43206 | Hammond | 04:36:00 | 05:25:00 |  | [NAME] | 223
08:00:00 |  |  |  |  |  |  | [NAME] | 140
09:00:00 |  |  |  |  |  |  | [NAME] | 74
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 10:00:00 | 10:15:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00