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

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 | 32802 | 42201 | Hammond | 04:00:00 | 04:39:00 |  | 447 | 231 |  |  |  |  | 525 |  |  |  |  |  | 442
08:00:00 |  |  |  |  |  |  |  | 141
09:00:00 |  |  |  |  |  |  |  | 108
10:00:00 |  |  |  |  |  |  |  | 50
11:00:00 |  |  |  |  |  |  |  | 30
12:00:00 |  |  |  |  |  |  |  |  |  | 12:00:00 | 12:20:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00 | 13:28:00 |  |  | 5 |  | 14:31:00 | 15:10: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 | 20954 | 42202 | Hammond | 07:30:00 | 08:15:00 |  | [NAME] | 326
08:00:00 |  |  |  |  |  |  | [NAME] | 326
09:00:00 |  |  |  |  |  |  | [NAME] | 290
10:00:00 |  |  |  |  |  |  | [NAME] | 240
11:00:00 |  |  |  |  |  |  | [NAME] | 220
12:00:00 |  |  |  |  |  |  |  | 131
13:00:00 |  |  |  |  |  |  |  | 44 |  | 14:20:00 | 12:45: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 | 42203 | Hammond | 03:00:00 | 04:15:00 |  | [NAME] | 80
08:00:00 |  |  |  |  |  |  | [NAME] | 18
09:00:00 |  |  |  |  |  |  | [NAME] | 18
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:15:00 | 09:42: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 | 21445 | 42204 | Hammond | 04:00:00 | 04:45:00 |  | [NAME] | 200
08:00:00 |  |  |  |  |  |  | [NAME] | 200
09:00:00 |  |  |  |  |  |  | [NAME] | 200
10:00:00 |  |  |  |  |  |  | [NAME] | 200
11:00:00 | L326 |  |  |  |  |  | [NAME]
12:00:00 |  |  |  |  |  |  | [NAME]
13:00:00 |  |  |  |  |  |  | [NAME] | 45 |  | 16:00:00 | 16:35: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 | 422 | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21052 | 42205 | Hammond | 04:00:00 | 04:12:00 |  | [NAME] | 83
08:00:00 |  |  |  |  |  |  | [NAME] | 25
09:00:00 |  |  |  |  |  |  | [NAME] | 25
10:00:00 |  |  |  |  |  |  | [NAME] |  | 09:15: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 | 672167 | 42206 | Hammond | 03:30:00 | 04:12:00 |  | [NAME] | 110
08:00:00 |  |  |  |  |  |  | [NAME] | 65
09:00:00 |  |  |  |  |  |  | [NAME] | 65
10:00:00 |  |  |  |  |  |  | [NAME] |  | 10:05:00 | 10:30:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00