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

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 | 32537 | 43701 | Store | Hammond | 04:00:00 | 04:30:00 |  | 543 |  |  |  |  |  | 456
08:00:00 |  |  |  |  |  |  |  |  | 176
09:00:00 |  |  |  |  |  |  |  |  | 106
10:00:00 |  |  |  |  |  |  |  |  | 80
11:00:00 |  |  |  |  |  |  |  |  | 40 |  | 11:30:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  | 12:30:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | 14:45:00 | 16:20: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 | 801478 | 43702 | Store | Hammond | 03:00:00 | 03:45:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 139
09:00:00 |  |  |  |  |  |  |  | [NAME] | 28
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 09:40:00 | 09:45:00
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 | 21886 | 43703 | Store | Hammond | 03:00:00 | 03:52:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 100
09:00:00 |  |  |  |  |  |  |  | [NAME] | 33 |  | 09:05:00 | 09:30:00
10:00:00 |  |  |  |  |  |  |  | [NAME]
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 | 93034 | 43704 | Store | Hammond | 03:44:00 | 04:06:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 160
09:00:00 |  |  |  |  |  |  |  | [NAME] | 50
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 09:50:00 | 10:00:00
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 | 11771 | 43705 | Store | Hammond | 05:51:00 | 06:09:00 |  | [NAME] |  |  |  |  | AH
08:00:00 |  |  |  |  |  |  |  | [NAME] | 246
09:00:00 |  |  |  |  |  |  |  | [NAME] | 179
10:00:00 |  |  |  |  |  |  |  | [NAME] | 32502 | is recover | load | PTA is | 14:30:00
11:00:00 |  |  |  |  |  |  |  | [NAME] | 32502 | just picked | load up | 12:30:00
13:00:00 |  |  |  |  |  |  |  |  | 120
13:30:00 |  |  |  |  |  |  |  |  | 80 |  |  |  |  | 10 miles | out
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 | L325 | 43706 | Store | Hammond | 03:46:00 | 04:21:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 208
09:00:00 |  |  |  |  |  |  |  | [NAME] | 120
10:00:00 |  |  |  |  |  |  |  | [NAME] | 45
11:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10:40:00 | 10:45:00
12:00:00
13:00:00