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

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 | L111 | 47401 | Hammond | 03:03:00 | 04:11:00 |  | 410 | 200 |  |  |  |  | 509 |  |  |  |  |  | 445
08:00:00 |  |  |  |  |  |  |  | 175
09:00:00 |  |  |  |  |  |  |  | 50
10:00:00 |  |  |  |  |  |  |  |  |  | 10:34: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 | 32841 | 47402 | Hammond | 03:00:00 | 03:51:00 |  | 447 | 287 |  |  |  |  | 462
08:00:00 |  |  |  |  |  |  |  | 228
09:00:00 |  |  |  |  |  |  |  | 165
10:00:00 |  |  |  |  |  |  |  | 71
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 | 32537 | 47403 | Hammond | 03:30:00 | 04:00:00 |  | 435 | 260 |  |  |  |  | 442
08:00:00 |  |  |  |  |  |  |  | 200
09:00:00 |  |  |  |  |  |  |  | 159
10:00:00 |  |  |  |  |  |  |  | 90
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 | L173 | 47404 | Hammond | 03:00:00 | 04:21:00 |  | 595 | 300 |  |  |  |  | 528
08:00:00 |  |  |  |  |  |  |  | 300
09:00:00 |  |  |  |  |  | trailer | just | 300
10:00:00 |  |  |  |  |  | tire | out | 245
11:00:00 |  |  |  |  |  | blow | of | 128
12:00:00 |  |  |  |  |  | out | shop
13:00:00 |  |  |  |  |  |  | 08: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 | L325 | 47405 | Hammond | 03:38:00 | 04:08:00 |  | 407 | 182 |  |  |  |  | 435
08:00:00 |  |  |  |  |  |  |  | 125
09:00:00 |  |  |  |  |  |  |  | 70
10:00:00 |  |  |  |  |  |  |  |  |  | 10:25: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 | 38084 | 47406 | Hammond | 04:00:00 | 04:09:00 |  | 528 | 139 |  |  |  |  | 526
08:00:00 |  |  |  |  |  |  |  | 78
09:00:00 |  |  |  |  |  |  |  | 10 |  | 09:09:00 | 09:15:00
10:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00 | 11:02:00
11:00:00
12:00:00
13:00:00