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

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 | 32502 | 43801 | Hammond | 03:43:00 | 03:48:00 | OK | 456 | 253 |  |  |  |  | 445
08:00:00 |  |  |  |  |  |  |  | 197
09:00:00 |  |  |  |  |  |  |  | 135 | 11:20:00
10:00:00 |  |  |  |  |  |  |  | 90
11:00:00 |  |  |  |  |  |  |  | 40
12:00:00 |  |  |  |  |  |  |  | 2 |  | 12:15:00 | 13:25:00 | OK |  | 55 | 14:30:00 | 14:30:00 | 15:15:00 | OK
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 | 21323 | 43802 | Hammond | 03:30:00 | 04:00:00 | OK | [NAME] | 177
08:00:00 |  |  |  |  |  |  | [NAME] | 85
09:00:00 |  |  |  |  |  |  | [NAME] | 38
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:15:00 | 09:40:00 | OK
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 | 21858 | 43803 | Hammond | 03:30:00 | 05:40:00 | OK | [NAME] | 268
08:00:00 |  |  |  |  |  |  | [NAME] | 187
09:00:00 |  |  |  |  |  |  | [NAME] | 138
10:00:00 |  |  |  |  |  |  | [NAME] | 100
11:00:00 |  |  |  |  |  |  | [NAME] | 43 |  | 10:59:00 | 1115 | OK
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 | L326 | 43804 | Hammond | 03:50:00 | 04:00:00 | OK | [NAME] | 150
08:00:00 |  |  |  |  |  |  | [NAME] | 60
09:00:00 |  |  |  |  |  |  | [NAME] | 13 |  | 09:00:00 | 09:30:00 | OK
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 | 32804 | 43305 | Hammond | 04:10:00 | 04:40:00 | OK | [NAME] | 200
08:00:00 |  |  |  |  |  |  | [NAME] | 134
09:00:00 |  |  |  |  |  |  | [NAME] | 80
10:00:00 |  |  |  |  |  |  | [NAME] | 36 |  | 10:10:00 | 10:30:00 | OK
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 | 21324 | 43806 | Hammond | 04:05:00 | 04:44:00 | OK | [NAME] | 200
08:00:00 |  |  |  |  |  |  | [NAME] | 150
09:00:00 |  |  |  |  |  |  | [NAME] | 95
10:00:00 |  |  |  |  |  |  | [NAME] | 60 |  | 10:28:00 | 11:01:00 | OK
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00