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

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 | 34084 | 44501 | Hammond | 03:45:00 | 04:00:00 |  | 410 |  |  |  |  |  | 442
08:00:00
09:00:00 |  |  |  |  |  |  |  | 134
10:00:00 |  |  |  |  |  |  |  | 54
11:00:00 |  |  |  |  |  |  |  | 27
12:00:00 |  |  |  |  |  |  |  |  |  | 11:15: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 | 11771 | 44502 | Hammond | 03:52:00 | 04:07:00 |  | 462 |  |  |  |  |  | 447
08:00:00
09:00:00 |  |  |  |  |  |  |  | 150
10:00:00 |  |  |  |  |  |  |  | 70
11:00:00 |  |  |  |  |  |  |  | 2
12:00:00 |  |  |  |  |  |  |  |  |  | 11:15: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 | 801478 | 44503 | Hammond | 03:53:00 | 03:59:00 |  | 509 |  |  |  |  |  | 550
08:00:00
09:00:00 |  |  |  |  |  |  |  | 133
10:00:00 |  |  |  |  |  |  |  | 83
11:00:00 |  |  |  |  |  |  |  | 23
12:00:00 |  |  |  |  |  |  |  |  |  | 11:50: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
08:00:00
09:00:00
10:00:00
11:00: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 |  |  | Hammond
08:00:00
09:00:00
10:00:00
11:00: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 |  |  | Hammond
08:00:00
09:00:00
10:00:00
11:00: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 | 34084 | 44501 | Hammond | 03:45:00 | 04:00:00 |  | 410 |  |  |  |  |  | 442
08:00:00
09:00:00 |  |  |  |  |  |  |  | 134
10:00:00 |  |  |  |  |  |  |  | 54
11:00:00 |  |  |  |  |  |  |  | 27
12:00:00 |  |  |  |  |  |  |  |  |  | 11:15: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 | 11771 | 44502 | Hammond | 03:52:00 | 04:07:00 |  | 462 |  |  |  |  |  | 447
08:00:00
09:00:00 |  |  |  |  |  |  |  | 150
10:00:00 |  |  |  |  |  |  |  | 70
11:00:00 |  |  |  |  |  |  |  | 2
12:00:00 |  |  |  |  |  |  |  |  |  | 11:15: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 | 801478 | 44503 | Hammond | 03:53:00 | 03:59:00 |  | 509 |  |  |  |  |  | 550
08:00:00
09:00:00 |  |  |  |  |  |  |  | 133
10:00:00 |  |  |  |  |  |  |  | 83
11:00:00 |  |  |  |  |  |  |  | 23
12:00:00 |  |  |  |  |  |  |  |  |  | 11:50:00
13:00:00