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

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
700 | 21437 | 44701 | Hammond | 03:52:00 | 04:20:00 | OK | 509 | 252 |  |  |  |  | 517 |  |  |  |  |  | 442
800 | 21437 | 44701 |  |  |  |  | 509 | 190 | 1200 |  |  |  | 517 |  |  |  |  |  | 442
900 | 21437 | 44701 |  |  |  |  | 509 | 132 |  |  |  |  | 517 |  |  |  |  |  | 442
1000 | 21437 | 44701 |  |  |  |  | 509 | 60 | 1115 |  |  |  | 517 |  |  |  |  |  | 442
1100 | 21437 | 44701 |  |  |  |  | 509 |  |  | 1100 | 1145 | OK | 517 |  |  |  |  |  | 442
1200 | 21437 | 44701 |  |  |  |  |  |  |  |  |  |  | 517 |  |  | 1220 | 1305 | OK | 442
1300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 442 | 70 | 1430 | 14:28: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
700 | 2384 | 44702 | Hammond | 03:25:00 | 04:25:00 | OK | [NAME] | 161
800 | 2384 | 44702 |  |  |  |  | [NAME] | 120 | 1030
900 | 2384 | 44702 |  |  |  |  | [NAME] | 54
1000 | 2384 | 44702 |  |  |  |  | [NAME] |  |  | 09:20:00 | 945 | OK
1100 | 2384 | 44702 |  |  |  |  | [NAME]
1200
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
700 | 21525 | 44703 | Hammond | 03:58:00 | 04:38:00 | OK | [NAME] | 195
800 | 21525 | 44703 |  |  |  |  | [NAME] | 140 | 1100
900 | 21525 | 44703 |  |  |  |  | [NAME] | 69
1000 | 21525 | 44703 |  |  |  |  | [NAME] | 16 |  | 1000 | 1030 | OK
1100 | 21525 | 44703 |  |  |  |  | [NAME]
1200
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
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
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