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

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 | 1671 | 43601 | Hammond | 03:00:00 | 04:55:00 |  | 527 |  |  |  |  |  | 411 |  |  |  |  |  | 445
08:00:00
09:00:00
10:00:00 |  |  |  |  |  |  |  | 27
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 | 2424 | 43602 | Hammond | 04:15:00 | 04:13:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME] | 90
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 | 1349 | 43603 | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:45: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 | 21709 | 43604 | Hammond | 04:07:00 | 04:12:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME] | 67
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 | 43605 | Hammond | 03:45:00 | 04:15:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME] | 67
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 | 21257 | 43606 | Hammond | 05:43:00 | 06:13:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME] | 100
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00