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

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 | L111 | 45801 | Hammond | 03:58:00 | 04:02:00 | OK | 429 | 200 | 11:00:00 |  |  |  | 525
08:00:00 | L111 |  |  |  |  |  | 429 | 170 | 11:00:00
09:00:00 | L111 |  |  |  |  |  | 429 | 110 | 11:00:00
10:00:00 | L111 |  |  |  |  |  | 429
11:00:00 | L111 |  |  |  |  |  | 429
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 | 93117 | 45802 | Hammond | 04:00:00 | 05:13:00 | OK | [NAME] | 260 | 11:30:00
08:00:00 | 93117 |  |  |  |  |  | [NAME] | 150 | 11:30:00
09:00:00 | 93117 |  |  |  |  |  | [NAME] | 115 | 11:30:00
10:00:00 | 93117 |  |  |  |  |  | [NAME]
11:00:00 | 93117 |  |  |  |  |  | [NAME]
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 | 21412 | 45803 | Hammond | 03:52:00 | 04:00:00 | OK | [NAME] | 142 | 10:00:00
08:00:00 | 21412 |  |  |  |  |  | [NAME] | 85 | 10:00:00
09:00:00 | 21412 |  |  |  |  |  | [NAME] | 32 | 10:00:00
10:00:00 | 21412 |  |  |  |  |  | [NAME]
11:00:00 | 21412 |  |  |  |  |  | [NAME]
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 | 21525 | 45803 | Hammond | 03:00:00 | 03:54:00 | OK | [NAME] | 149 | 10:00:00
08:00:00 | 21525 |  |  |  |  |  | [NAME] | 88 | 10:00:00
09:00:00 | 21525 |  |  |  |  |  | [NAME] | 30 | 10:00:00
10:00:00 | 21525 |  |  |  |  |  | [NAME]
11:00:00 | 21525 |  |  |  |  |  | [NAME]
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 | 21885 | 45805 | Hammond | 03:30:00 | 04:15:00 | OK | [NAME] | 199
08:00:00 | 21885 |  |  |  |  |  | [NAME] | 90
09:00:00 | 21885 |  |  |  |  |  | [NAME] | 30 | 10:00:00
10:00:00 | 21885 |  |  |  |  |  | [NAME]
11:00:00 | 21885 |  |  |  |  |  | [NAME]
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 | 2384 | 45806 | Hammond | 04:00:00 | 04:15:00 | OK | [NAME] | 159 | 10:30:00
08:00:00 | 2384 |  |  |  |  |  | [NAME] | 88 | 10:30:00
09:00:00 | 2384 |  |  |  |  |  | [NAME] | 27 | 10:00:00
10:00:00 | 2384 |  |  |  |  |  | [NAME]
11:00:00 | 2384 |  |  |  |  |  | [NAME]
12:00:00
13:00:00