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

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 | 44801 | Hammond | 03:30:00 | 04:00:00 | OK | 509 | 231 |  |  |  |  | 410 |  |  |  |  |  | 442
08:00:00 |  |  |  |  |  |  | 509 | 140 |  |  |  |  | 410 |  |  |  |  |  | 442
09:00:00 |  |  |  |  |  |  | 509 | 97 | 11:00:00 |  |  |  | 410 |  |  |  |  |  | 442
10:00:00 |  |  |  |  |  |  | 509 | 44 | 11:00:00 |  |  |  | 410 |  |  |  |  |  | 442
11:00:00 |  |  |  |  |  |  | 509 | 5 |  | 11:15:00 | 12:05:00 | OK | DROP | 33 |  | 12:50:00 | 13:40:00 | OK | 442 | 67 |  | 14:45:00 | 15:10:00 | OK
12:00:00 |  |  |  |  |  |  | 509 |  |  |  |  |  | 2 EXTRA |  |  |  |  |  | 442
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | PALLETS |  |  |  |  |  | 442
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 | 44802 | Hammond | 02:30:00 | 03:45:00 | OK | [NAME] | 160
08:00:00 |  |  |  |  |  |  | [NAME] | 64
09:00:00 |  |  |  |  |  |  | [NAME] | 17 | 09:15:00 | 09:14:00 | 09:45:00 | OK
10:00:00 |  |  |  |  |  |  | [NAME]
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 | 20941 | 44803 | Hammond | 03:51:00 | 04:04:00 | OK | [NAME] | 160
08:00:00 |  |  |  |  |  |  | [NAME] | 75
09:00:00 |  |  |  |  |  |  | [NAME] | 29 | 09:30:00 | 09:28:00 | 09:48:00 | OK
10:00:00 |  |  |  |  |  |  | [NAME]
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
08:00:00
09:00:00
10:00:00
11:00:00
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
08:00:00
09:00:00
10:00:00
11:00:00
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
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00