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

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 | 45701 | Hammond | 03:15:00 | 03:45:00 | OK | 429 | 226 |  |  |  |  | 434 |  |  |  |  |  | 525
08:00:00 | 637018 | 45701 |  |  |  |  | 429 | 150 | 1100
09:00:00 | 637018 | 45701 |  |  |  |  | 429 | 85
10:00:00 | 637018 | 45701 |  |  |  |  | 429 | 52
11:00:00 | 637018 | 45701 |  |  |  |  | 429 | 4 | 1115 | 11:15:00 | 11:40:00 |  |  |  |  | 12:00:00 | 13:15:00 | OK |  |  |  | 13:50:00 | 14:30:00 | OK
12:00:00 | 637018 | 45701
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 | 45702 | Hammond | 03:45:00 | 04:00:00 | OK | [NAME] | 134
08:00:00 | 34084 | 45702 |  |  |  |  | [NAME] | 64
09:00:00 | 34084 | 45702 |  |  |  |  | [NAME] | 30
10:00:00 | 34084 | 45702 |  |  |  |  | [NAME] | 8 |  | 10:00:00 | 10:20:00 | OK
11:00:00 | 34084 | 45702
12:00:00 | 34084 | 45702
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 | 32804 | 45703 | Hammond | 03:58:00 | 04:09:00 | OK | [NAME] | 176
08:00:00 | 32804 | 45703 |  |  |  |  | [NAME] | 105 | 1000
09:00:00 | 32804 | 45703 |  |  |  |  | [NAME] | 33
10:00:00 | 32804 | 45703 |  |  |  |  | [NAME] |  |  | 09:44:00 | 10:15:00 | OK
11:00:00 | 32804 | 45703
12:00:00 | 32804 | 45703
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 | 21615 | 45704 | Hammond | 03:55:00 | 04:24:00 | OK | [NAME] | 180
08:00:00 | 21615 | 45704 |  |  |  |  | [NAME] | 120 | 1030
09:00:00 | 21615 | 45704 |  |  |  |  | [NAME] | 70
10:00:00 | 21615 | 45704 |  |  |  |  | [NAME] | 10 |  | 10:17:00 | 10:30:00 | OK
11:00:00 | 21615 | 45704
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 | L111 | 45705 | Hammond | 03:31:00 | 04:04:00 | OK | [NAME] | 110
08:00:00 | L111 | 45705 |  |  |  |  | [NAME] | 100 | 1000
09:00:00 | L111 | 45705 |  |  |  |  | [NAME] | 85
10:00:00 | L111 | 45705 |  |  |  |  | [NAME] | 60
11:00:00 | L111 | 45705 |  |  |  |  | [NAME] | 15 | 1130 | 11:00:00 | 11:10:00
12:00:00 | L111 | 45705
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 | 21445 | 45706 | Hammond | 03:56:00 | 04:04:00 | OK | [NAME] | 164
08:00:00 | 21445 | 45706 |  |  |  |  | [NAME] | 129 | 1030
09:00:00 | 21445 | 45706 |  |  |  |  | [NAME] | 60
10:00:00 | 21445 | 45706 |  |  |  |  | [NAME] |  |  | 09:40:00 | 09:50:00 | OK
11:00:00 | 21445 | 45706
12:00:00
13:00:00