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

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 | 32502 | 45801 | Store | Hammond | 04:00:00 | 04:26:00 |  | 434 | 280 |  |  |  |  | 525
08:00:00 |  |  |  |  |  |  |  |  | 230
09:00:00 |  |  |  |  |  |  |  |  | 180
10:00:00 |  |  |  |  |  |  |  |  | 141
11:00:00 |  |  |  |  |  |  |  |  | 84
12:00:00 |  |  |  |  |  |  |  |  |  |  | 12:51:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  | 13:58:00 |  |  |  |  | 14: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 | 21445 | 45802 | DC | Hammond | 03:30:00 | 04:16:00 |  | [NAME] | 182
08:00:00 |  |  |  |  |  |  |  | [NAME] | 129
09:00:00 |  |  |  |  |  |  |  | [NAME] | 65
10:00:00 |  |  |  |  |  |  |  | [NAME] | 7 |  | 10:00:00 | 10:10: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 | 32537 | 45803 | DC | Hammond | 03:30:00 | 04:30:00 |  | [NAME] | 200
08:00:00 |  |  |  |  |  |  |  | [NAME] | 170
09:00:00 |  |  |  |  |  |  |  | [NAME] | 100
10:00:00 |  |  |  |  |  |  |  | [NAME] | 60 |  | 10:30:00 | 10: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 | 32803 | 45804 | DC | Hammond | 04:05:00 | 04:39:00 |  | [NAME] | 200
08:00:00 |  |  |  |  |  |  |  | [NAME] | 162
09:00:00 |  |  |  |  |  |  |  | [NAME] | 120
10:00:00 |  |  |  |  |  |  |  | [NAME] | 55 |  | 10:25:00 | 10:30: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 | 1671 | 45805 | DC | Hammond | 03:00:00 | 04:23:00 |  | [NAME] | 164
08:00:00 |  |  |  |  |  |  |  | [NAME] | 106
09:00:00 |  |  |  |  |  |  |  | [NAME] | 43
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 09:43:00 | 09:50:00
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 | 21323 | 45806 | DC | Hammond | 04:00:00 | 05:23:00 |  | [NAME] | 210
08:00:00 |  |  |  |  |  |  |  | [NAME] | 151
09:00:00 |  |  |  |  |  |  |  | [NAME] | 89
10:00:00 |  |  |  |  |  |  |  | [NAME] | 30 |  | 10:30:00 | 10:45:00
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00