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

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 | 93024 | 46701 | Hammond | 03:45:00 | 04:12:00 | OK | 463 | 170 |  |  |  |  | 445
08:00:00 | 93024 | 46701 |  |  |  |  | 463 | 110 | 1015
09:00:00 | 93024 | 46701 |  |  |  |  | 463 | 15
10:00:00 | 93024 | 46701 |  |  |  |  | 463 |  |  | 10:15:00 | 13:45:00
11:00:00 | 93024 | 46701 |  |  |  |  | 463
12:00:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
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 | L326 | 46702 | Hammond | 04:09:00 | 04:30:00 | OK | [NAME] | 150
08:00:00 | L326 | 46702 |  |  |  |  | [NAME] | 100 | 1000
09:00:00 | L326 | 46702 |  |  |  |  | [NAME] | 68
10:00:00 | L326 | 46702 |  |  |  |  | [NAME] | 5 |  | 10:15:00 | 10:20:00
11:00:00 | L326 | 46702 |  |  |  |  | [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 | 21858 | 46703 | Hammond | 03:00:00 | 03:30:00 | OK | [NAME] | 131
08:00:00 | 21858 | 46703 |  |  |  |  | [NAME] | 100 | 1000
09:00:00 | 21858 | 46703 |  |  |  |  | [NAME] | 45
10:00:00 | 21858 | 46703 |  |  |  |  | [NAME] |  |  | 09:37:00 | 10:45:00
11:00:00 |  |  |  |  |  |  | [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 | 92873 | 46704 | Hammond | 07:15:00 | 747 | AI | [NAME]
08:00:00 | 92873 | 46704 |  |  |  |  | [NAME] | 320 | 1400
09:00:00 | 92873 | 46704 |  |  |  |  | [NAME] | 262
10:00:00 | 92873 | 46704 |  |  |  |  | [NAME] | 185
11:00:00 | 92873 | 46704 |  |  |  |  | [NAME] | 115
12:00:00 | 92873 | 46704 |  |  |  |  | [NAME] | 27
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 | L173 | 46705 | Hammond | 03:00:00 | 06:15:00 | AM | [NAME] | 219
08:00:00 | L173 | 46705 |  |  |  |  | [NAME] | 170 | 1100
09:00:00 | L173 | 46705 |  |  |  |  | [NAME] | 160
10:00:00 | L173 | 46705 |  |  |  |  | [NAME] | 102
11:00:00 | L173 | 46705 |  |  |  |  | [NAME] | 32
12:00:00 |  |  |  |  |  |  | [NAME] |  |  | 11:50:00 | 12:15: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 | 21891 | 46706 | Hammond | 03:45:00 | 04:02:00 | OK | [NAME] | 140
08:00:00 | 21891 | 46706 |  |  |  |  | [NAME] | 100 | 1000
09:00:00 | 21891 | 46706 |  |  |  |  | [NAME] | 24
10:00:00 | 21891 | 46706 |  |  |  |  | [NAME] |  |  | 09:30:00 | 09:45:00
11:00:00 | 21891 | 46706 |  |  |  |  | [NAME]
12:00:00
13:00:00