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

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 | 11771 | 44201 | Hammond | 03:00:00 | 04:04:00 |  | 407 | 120 |  |  |  |  | 411
08:00:00 |  |  |  |  |  |  |  | 55
09:00:00 |  |  |  |  |  |  |  |  |  | 09:28:00 | 09:59:00
10:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 90
11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 12:38:00 | 14:08: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 | #02429 | 44202 | Hammond | 03:51:00 | 04:20:00 |  | [NAME] | 195
08:00:00 |  |  |  |  |  |  | [NAME] | 157
09:00:00 |  |  |  |  |  |  | [NAME] | 27
10:00:00 |  |  |  |  |  |  | [NAME] | 8 |  | 10:15: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 | 21329 | 44203 | Hammond | 03:44:00 | 03:56:00 |  | [NAME] | 175
08:00:00 |  |  |  |  |  |  | [NAME] | 105
09:00:00 |  |  |  |  |  |  | [NAME] | 1
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:55: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 |  |  | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00 |  |  |  |  |  |  | [NAME]
13:00:00 |  |  |  |  |  |  | [NAME]
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 | 422 | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 |  |  | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
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 |  |  | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00