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

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 # | DC or Store | 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 | 46101 | Store | Hammond | 04:07:00 | 04:42:00 | OK | 428 |  |  |  |  |  | 447
08:00:00 |  |  |  |  |  |  |  |  | 217
09:00:00 |  |  |  |  |  |  |  |  | 142
10:00:00 |  |  |  |  |  |  |  |  | 43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loading a Winn Dixie truck
11:00:00 |  |  |  |  |  |  |  |  |  |  | 11:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | not @ Dock yet
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | AL
13:00:00 |  |  |  |  |  |  |  |  |  |  |  | 13:39:00 |  |  | 48@14:35 |  | 15:40:00 |  | AL |  |  |  |  |  |  | unloading him now
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | 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 | 21886 | 46102 | DC | Hammond | 03:30:00 | 04:00:00 | OK | [NAME]
08:00:00 | 21512 |  |  |  |  | 08:15:00 |  | [NAME] | 300
09:00:00 |  |  |  |  |  |  |  | [NAME] | 280 |  |  |  | A1
10:00:00 |  |  |  |  |  |  |  | [NAME] | 197
11:00:00 |  |  |  |  |  |  |  | [NAME] | 150
12:00:00 |  |  |  |  |  |  |  |  | 100
13:00:00 |  |  |  |  |  |  |  |  | 40 |  | 14:18:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | 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 | 21580 | 46103 | DC | Hammond | 03:50:00 | 05:32:00 | AM | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Load was not ready still at dock
08:00:00 |  |  |  |  |  |  |  | [NAME] | 180
09:00:00 |  |  |  |  |  |  |  | [NAME] | 112
10:00:00 |  |  |  |  |  |  |  | [NAME] | 20 |  | 10:56:00 | 11:05:00 | OK
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | 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 | 52041 | 46104 | DC | Hammond | 03:30:00 | 04:00:00 | OK | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 180
09:00:00 |  |  |  |  |  |  |  | [NAME] | 65
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10:30:00 | 10:40:00 | OK
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | 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 | 21323 | 46105 | DC | Hammond | 03:45:00 | 04:15:00 | OK | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 101
09:00:00 |  |  |  |  |  |  |  | [NAME] | 30
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10:00:00 | 10:20:00 | OK
11:00:00 |  |  |  |  |  |  |  | [NAME]
13:00:00
13:30:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | 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 | 46106 | DC | Hammond | 04:00:00 | 05:20:00 | OK | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 110
09:00:00 |  |  |  |  |  |  |  | [NAME] | 25 |  | 09:55:00 | 10:10:00 | OK
10:00:00 |  |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00