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

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 | L326 | 43701 | Hammond | 330 | 350 | OK | 503 | 200 | 1100 |  |  |  | 445
800 | L326 | 43701 |  |  |  |  |  | 100 |  |  |  |  | 445
900 | L326 | 43701 |  |  |  |  |  | 15 |  |  |  |  | 445
1000 | L326 | 43701 |  |  |  |  |  |  |  | 09:40:00 | 10:30:00 | OK | 445
1100 | L326 | 43701 |  |  |  |  |  |  |  |  |  |  | 445 | 60 | 12:30:00
1200 | L326 | 43701 |  |  |  |  |  |  |  |  |  |  | 445 |  |  | 1200 | 1243 | OK
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 | 20954 | 43702 | Hammond | 400 | 420 | OK | [NAME] | 250 | 1130
800 | 20954 | 43702 |  |  |  |  |  | 141
900 | 20954 | 43702 |  |  |  |  |  | 45
1000 | 20954 | 43702 |  |  |  |  |  |  |  | 10:30:00 | 11:00:00 | OK
1100 | 20954 | 43702
1200 | 20954 | 43702
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 | 32660 | 43703 | Hammond | 330 | 406 | OK | [NAME] | 167 | 1100
800 | 32660 | 43703 |  |  |  |  |  | 128
900 | 32660 | 43703 |  |  |  |  |  |  |  | 09:17:00 | 10:30:00 | OK
1000 | 32660 | 43703
1100 | 32660 | 43703
1200 | 32660 | 43703
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 | 21323 | 43704 | Hammond | 345 | 410 | OK | [NAME] | 175 | 1100
800 | 21323 | 43704 |  |  |  |  |  | 75
900 | 21323 | 43704 |  |  |  |  |  |  |  | 09:15:00 | 10:00:00 | OK
1000 | 21323 | 43704
1100 | 21323 | 43704
1200 | 21323 | 43704
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 | 32841 | 43705 | Hammond | 300 | 330 | OK | [NAME] | 179 | 1100
800 | 32841 | 43705 |  |  |  |  |  | 87
900 | 32841 | 43705 |  |  |  |  |  |  |  | 09:30:00 | 10:20:00 | OK
1000 | 32841 | 43705
1100 | 32841 | 43705
1200 | 32841 | 43705
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 | 672167 | 43706 | Hammond | 315 | 340 | OK | [NAME] | 165 | 1100
800 | 672167 | 43706 |  |  |  |  |  | 68
900 | 672167 | 43706 |  |  |  |  |  |  |  | 09:15:00
1000 | 672167 | 43706
1100 | 672167 | 43706 |  |  |  |  |  |  |  |  | 11:00:00 | OK
1200 | 672167 | 43706