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

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 | 20954 | 46501 | Hammond | 03:17:00 | 04:26:00 |  | 520 | 170 |  |  |  |  | 445
08:00:00 |  |  |  |  |  |  |  | 52
09:00:00
10:00:00 |  |  |  |  |  |  |  |  |  | 10:10:00
11:00:00 |  |  |  |  |  |  |  |  |  |  | 11:39:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 83
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 14;00 | 14:30: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 | 46502 | Hammond | 03:00:00 | 03:49:00 |  | 464 | 230 |  |  |  |  | 553
08:00:00 |  |  |  |  |  |  |  | 200
09:00:00
10:00:00 |  |  |  |  |  |  |  | 77
11:00:00 |  |  |  |  |  |  |  |  |  | 11:03:00
12:00:00 |  |  |  |  |  |  |  |  |  |  | 13:35:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:20:00 | 14: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 | 32804 | 46503 | Hammond | 03:53:00 | 04:20:00 |  | 543 | 134
08:00:00 |  |  |  |  |  |  |  | 74
09:00:00
10:00:00 |  |  |  |  |  |  |  | 29
11:00:00 |  |  |  |  |  |  |  |  |  | 10:36:00 | 11:50: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 | 21709 | 46504 | Hammond | 03:00:00 | 04:10:00 |  | 448 | 164 |  |  |  |  | 451
08:00:00 |  |  |  |  |  |  |  | 143
09:00:00
10:00:00 |  |  |  |  |  |  |  | 77
11:00:00 |  |  |  |  |  |  |  | 22
12:00:00 |  |  |  |  |  |  |  |  |  | 11:51:00 | 12:37:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:20:00 | 14:15: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 | 21428 | 46505 | Hammond | 02:11:00 | 04:10:00 |  | 428 | 166 |  |  |  |  | 521
08:00:00 |  |  |  |  |  |  |  | 147
09:00:00
10:00:00 |  |  |  |  |  |  |  | 99
11:00:00 |  |  |  |  |  |  |  | 30
12:00:00 |  |  |  |  |  |  |  |  |  | 11:19:00 | 12:11:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:39:00 | 14: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 | 32505 | 46506 | Hammond |  |  |  | 428 |  |  |  |  |  | 521
08:00:00 |  |  |  |  |  |  |  | 118
09:00:00
10:00:00 |  |  |  |  |  |  |  | 43
11:00:00 |  |  |  |  |  |  |  | 23
12:00:00 |  |  |  |  |  |  |  | 20
13:00:00 |  |  |  |  |  |  |  |  |  | 11:30:00 | 12:30:00 |  |  |  |  | 13:30: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 | 32805 | 46507 | Hammond | 03:55:00 | 04:05:00 |  | 428 | 261
08:00:00 |  |  |  |  |  |  |  | 184
09:00:00
10:00:00 |  |  |  |  |  |  |  | 180
11:00:00 |  |  |  |  |  |  |  | 121
12:00:00 |  |  |  |  |  |  |  | 80
13:00:00 |  |  |  |  |  |  |  | 18 |  | 12:00:00 | 14:30: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 | 629801 | 46508 | Hammond | 03:36:00 | 04:12:00 |  | 448 | 150
08:00:00 |  |  |  |  |  |  |  | 140
09:00:00
10:00:00 |  |  |  |  |  |  |  | 77
11:00:00 |  |  |  |  |  |  |  | 18
12:00:00 |  |  |  |  |  |  |  |  |  | 11:27:00
13:00:00 |  |  |  |  |  |  |  |  |  |  | 13:07: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 | 502503 | Hammond | 03:15:00 | 04:12:00 |  | 460 | 161
08:00:00 |  |  |  |  |  |  |  | 160
09:00:00
10:00:00 |  |  |  |  |  |  |  | 160 | truck | broke | down
11:00:00 |  |  |  |  |  |  |  |  | L326 | going to | recover
12:00:00
13:00:00 |  |  |  |  |  |  |  | L326 | just | got the | load | 140 |  | 45