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

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 | 637018 | 44101 | Hammond | 03:00:00 | 03:30:00 |  | 410 | 211 |  |  |  |  | 442 |  |  |  |  |  | 447
08:00:00 |  |  |  |  |  |  |  | 137
09:00:00 |  |  |  |  |  |  |  | 99
10:00:00 |  |  |  |  |  |  |  | 38 |  | 10:45:00 | 11:30:00 |  |  | 40
11:00:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00 | 13:00:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 |  | 14:15:00 | 15:30: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 | 21525 | 44102 | Hammond | 03:48:00 | 04:00:00 |  | [NAME] | 131
08:00:00 |  |  |  |  |  |  | [NAME] | 62
09:00:00 |  |  |  |  |  |  | [NAME] | 25
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:15: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 | 34084 | 44103 | Hammond | 03:54:00 | 04:00:00 |  | [NAME] | 147
08:00:00 |  |  |  |  |  |  | [NAME] | 71
09:00:00 |  |  |  |  |  |  | [NAME] | 34
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 |  |  | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00 |  |  |  |  |  |  | [NAME]
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 |  |  | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
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 |  |  | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00