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

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 | 21445 |  | Hammond | 04:08:00 | 04:37:00 |  | 448 | 200 |  |  |  |  | 445
08:00:00 |  |  |  |  |  |  |  | 140
09:00:00 |  |  |  |  |  |  |  | 66
10:00:00 |  |  |  |  |  |  |  |  |  | 10:24:00
11:00:00
12:00:00 |  |  |  |  |  |  |  |  |  |  | 12:15:00 |  |  | 97
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 |  | Hammond | 03:00:00 | 03:58:00 |  | 451 | 200 |  |  |  |  | 456
08:00:00 |  |  |  |  |  |  |  | 149
09:00:00 |  |  |  |  |  |  |  | 52
10:00:00 |  |  |  |  |  |  |  | 10
11:00:00
12:00:00 |  |  |  |  |  |  |  | 50
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 | L326 |  | Hammond | 05:00:00 | 05:42:00 |  | 464 | 240 |  |  |  |  | 520
08:00:00 |  |  |  |  |  |  |  | 200
09:00:00 |  |  |  |  |  |  |  | 129
10:00:00 |  |  |  |  |  |  |  | 67
11:00:00 |  |  |  |  |  |  |  | 24
12:00:00 |  |  |  |  |  |  |  |  |  | 11:49: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 | 34084 |  | Hammond | 03:34:00 | 04:55:00 |  | 520 | 196 |  |  |  |  | 543
08:00:00 |  |  |  |  |  |  |  | 121
09:00:00 |  |  |  |  |  |  |  | 99
10:00:00 |  |  |  |  |  |  |  | 4
11:00:00 |  |  |  |  |  |  |  |  |  | 10:45:00 | 11:15:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:40:00 | 12:30: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 | 21525 |  | Hammond | 03:55:00 | 04:05:00 |  | 428 | 222 |  |  |  |  | 553
08:00:00
09:00:00 |  |  |  |  |  |  |  | 222
10:00:00 |  |  |  |  |  |  |  | 146
11:00:00 |  |  |  |  |  |  |  | 103
12:00:00 |  |  |  |  |  |  |  | 56
13:00:00 |  |  |  |  |  |  |  | 20
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 | 637018 |  | Hammond | 03:30:00 | 04:00:00 |  | 503 | 150 |  |  |  |  | 451
08:00:00 |  |  |  |  |  |  |  | 116
09:00:00 |  |  |  |  |  |  |  | 25
10:00:00 |  |  |  |  |  |  |  |  |  | 10:30:00 | 11:20:00 |  |  | 17
11:00:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 | 12:30:00
13:00:00