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

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
800 | 32502 | 42701 | HAMMOND | 400 | 445 | OK | 434 | 287 | 1300 |  |  |  | 525
900 | 32502 | 42701 |  |  |  |  | 434 | 230 | 1300 |  |  |  | 525
1000 | 32502 | 42701 |  |  |  |  | 434 | 164 | 1300 |  |  |  | 525
1100 | 32502 | 42701 |  |  |  |  | 434 | 97 | 1315 |  |  |  | 525
1200 | 32502 | 42701 |  |  |  |  | 434 | 52 | 13:15:00 | 1330 | 1445 | OK | 525
 |  |  |  |  |  |  |  |  |  |  |  |  | 525 |  |  | 1520 | 1600 | 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
800 | L173 | 42702 | HAMMOND | 400 | 436 | OK | [NAME] | 129 | 1030
900 | L173 | 42702 |  |  |  |  | [NAME] | 30 | 1000
1000 | L173 | 42702 |  |  |  |  | [NAME] |  |  | 09:35:00 | 10:06:00 | OK
1100 | L173 | 42702 |  |  |  |  | [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 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
800 | 21749 | 42703 | HAMMOND | 400 | 506 | OK | [NAME] | 192 | 1130
900 | 21749 | 42703 |  |  |  |  | [NAME] | 140 | 1130
1000 | 21749 | 42703 |  |  |  |  | [NAME] | 29 | 10:30:00
1100 | 21749 | 42703 |  |  |  |  | [NAME] |  |  | 11:04:00 | 11:30:00 | 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
800 | 637018 | 42704 | HAMMOND | 400 | 434 | OK | [NAME] | 119 | 1030
900 | 637018 | 42704 |  |  |  |  | [NAME] | 42 | 1030
1000 | 637018 | 42704 |  |  |  |  | [NAME] |  |  | 09:50:00 | 10:15:00 | OK
1100 | 637018 | 42704 |  |  |  |  | [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 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
800 | L111 | 42705 | HAMMOND | 415 | 501 | OK | [NAME] | 154 | 1100
900 | L111 | 42705 |  |  |  |  | [NAME] | 90 | 1100
1000 | L111 | 42705 |  |  |  |  | [NAME] |  |  | 10:35:00 | 10:45:00 | OK
1100 | L111 | 42705 |  |  |  |  | [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 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
800 | 672167 | 42706 | HAMMOND | 400 | 445 | OK | [NAME] | 120 | 1000
900 | 672167 | 42706 |  |  |  |  | [NAME] | 35 | 1000
1000 | 672167 | 42706 |  |  |  |  | [NAME] |  |  | 09:39:00 | 10:30:00 | OK
1100 | 672167 | 42706 |  |  |  |  | [NAME]