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

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 | L111 | 45101 | Hammond | 03:52:00 | 04:46:00 |  | 496 | 200 |  |  |  |  | 442 |  |  |  |  |  | 434
08:00:00 |  |  |  |  |  |  |  | 175
09:00:00 |  |  |  |  |  |  |  | 60
10:00:00 |  |  |  |  |  |  |  | 10 |  | 10:44:00 | 11:06:00
11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 |  | 13:00:00 | 13:45:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 15:00:00 | 16:55: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 | 45102 | Hammond | 03:00:00 | 05:06:00 |  | [NAME] | 247
08:00:00 |  |  |  |  |  |  | [NAME] | 167
09:00:00 |  |  |  |  |  |  | [NAME] | 120
10:00:00 |  |  |  |  |  |  | [NAME] | 52
11:00:00 |  |  |  |  |  |  | [NAME] | 25 |  | 10:50:00 | 11:14: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 | 91073 | 45103 | Hammond | 04:00:00 | 04:21:00 |  | [NAME] | 107
08:00:00 |  |  |  |  |  |  | [NAME] | 39
09:00:00 |  |  |  |  |  |  | [NAME] | 10
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 08:48:00 | 09: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 | 21323 | 45104 | Hammond | 03:45:00 | 04:30:00 |  | [NAME] | 107
08:00:00 |  |  |  |  |  |  | [NAME] | 45
09:00:00 |  |  |  |  |  |  | [NAME] | 10
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:45:00 | 10:00:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00 |  |  |  |  |  |  | [NAME]
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 | 20954 | 45105 | Hammond | 03:00:00 | 04:13:00 |  | [NAME] | 166
08:00:00 |  |  |  |  |  |  | [NAME] | 89
09:00:00 |  |  |  |  |  |  | [NAME] | 47
10:00:00 |  |  |  |  |  |  | [NAME] | 5 |  | 09:45:00 | 10:15: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 | 45106 | Hammond | 03:00:00 | 04:09:00 |  | [NAME] | 166
08:00:00 |  |  |  |  |  |  | [NAME] | 94
09:00:00 |  |  |  |  |  |  | [NAME] | 40
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:40:00 | 09:50:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00