Spreadsheet: 329476d1404317853-adding-indirect-formula-to-a-countif-es3-cs-wholesale-load-tracking-report-test
Sheet: 5-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 # | 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 | 34084 | 42401 | Hammond | 03:45:00 | 04:00:00 |  | 429 | 232 |  |  |  |  | 434 |  |  |  |  |  | 525
08:00:00 |  |  |  |  |  |  |  | 177
09:00:00 |  |  |  |  |  |  |  | 123
10:00:00 |  |  |  |  |  |  |  | 32
11:00:00 |  |  |  |  |  |  |  |  |  | 11:30:00 | 12:34:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:15:00 | 13:45:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 14:40: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 | 21445 | 42402 | Hammond | 03:21:00 | 03:40:00 |  | [NAME] | 164
08:00:00 |  |  |  |  |  |  | [NAME] | 84
09:00:00 |  |  |  |  |  |  | [NAME] | 37
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:30:00 | 10:00: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 | 2429 | 42403 | Hammond | 03:55:00 | 04:10:00 |  | [NAME] | 190
08:00:00 |  |  |  |  |  |  | [NAME] | 123
09:00:00 |  |  |  |  |  |  | [NAME] | 74
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 10:00:00 | 10:10: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 | 20954 | 42404 | Hammond | 03:00:00 | 04:47:00 |  | [NAME] | 201
08:00:00 |  |  |  |  |  |  | [NAME] | 117
09:00:00 |  |  |  |  |  |  | [NAME] | 84
10:00:00 |  |  |  |  |  |  | [NAME] | 30 |  | 10:10:00 | 10:20: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 | 93024 | 42405 | Hammond | 03:42:00 | 04:15:00 |  | [NAME] | 156
08:00:00 |  |  |  |  |  |  | [NAME] | 100
09:00:00 |  |  |  |  |  |  | [NAME] | 48
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 10:12:00 | 10:30: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 | 1671 | 42406 | Hammond | 03:00:00 | 04:28:00 |  | [NAME] | 194
08:00:00 |  |  |  |  |  |  | [NAME] | 125
09:00:00 |  |  |  |  |  |  | [NAME] | 93
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 10:20:00 | 10:25:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00