Spreadsheet: 329476d1404317853-adding-indirect-formula-to-a-countif-es3-cs-wholesale-load-tracking-report-test
Sheet: 5-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 | 21525 | 45401 | Hammond | 04:07:00 | 04:17:00 |  | 434 | 291 |  |  |  |  | 525
08:00:00 |  |  |  |  |  |  |  | 198
09:00:00 |  |  |  |  |  |  |  | 124
10:00:00 |  |  |  |  |  |  |  | 71
11:00:00 |  |  |  |  |  |  |  | 23
12:00:00 |  |  |  |  |  |  |  |  |  | 12:11:00
13:00:00 |  |  |  |  |  |  |  |  |  |  | 13:31:00 |  |  | 13 |  | 13:55: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 | 21437 | 45402 | Hammond | 03:00:00 | 04:30:00 |  | [NAME] | 180
08:00:00 |  |  |  |  |  |  | [NAME] | 93
09:00:00 |  |  |  |  |  |  | [NAME] | 14
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:46:00 | 10:10: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 | 11771 | 45403 | Hammond | 03:00:00 | 06:00:00 |  | [NAME] | 300
08:00:00 |  |  |  |  |  |  | [NAME] | 197
09:00:00 |  |  |  |  |  |  | [NAME] | 172
10:00:00 |  |  |  |  |  |  | [NAME] | 118
11:00:00 |  |  |  |  |  |  | [NAME] | 65
12:00:00 |  |  |  |  |  |  |  |  |  | 12:17:00 | 12:30: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 | 32502 | 45404 | Hammond | 04:30:00 | 04:53:00 |  | [NAME] | 250
08:00:00 |  |  |  |  |  |  | [NAME] | 197
09:00:00 |  |  |  |  |  |  | [NAME] | 180
10:00:00 |  |  |  |  |  |  | [NAME] | 120
11:00:00 |  |  |  |  |  |  | [NAME] | 67
12:00:00 |  |  |  |  |  |  |  |  |  | 12:30:00 | 12:35: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 | L325 | 45405 | Hammond | 03:49:00 | 04:24:00 |  | [NAME] | 200
08:00:00 |  |  |  |  |  |  | [NAME] | 118
09:00:00 |  |  |  |  |  |  | [NAME] | 37
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 10:10: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 | 32507 | 45406 | Hammond | 04:30:00 | 05:18:00 |  | [NAME] | 250
08:00:00 |  |  |  |  |  |  | [NAME] | 137
09:00:00 |  |  |  |  |  |  | [NAME] | 57
10:00:00 |  |  |  |  |  |  | [NAME] | 14
11:00:00 |  |  |  |  |  |  | [NAME] |  |  | 10:41:00 | 11:10:00
12:00:00
13:00:00