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

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 | L325 | 45301 | Hammond | 03:40:00 | 04:20:00 |  | 445 | 250 |  |  |  |  | 461
08:00:00 |  |  |  |  |  |  |  | 199
09:00:00 |  |  |  |  |  |  |  | 150
10:00:00 |  |  |  |  |  |  |  | 89
11:00:00 |  |  |  |  |  |  |  | 18 |  | 11:30:00
12:00:00 |  |  |  |  |  |  |  |  |  |  | 12:53:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:41:00 | 14:40: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 | 45302 | Hammond | 03:44:00 | 04:25:00 |  | [NAME] | 197
08:00:00 |  |  |  |  |  |  | [NAME] | 160
09:00:00 |  |  |  |  |  |  | [NAME] | 100
10:00:00 |  |  |  |  |  |  | [NAME] | 60
11:00:00 |  |  |  |  |  |  | [NAME] | 8 |  | 11:00:00 | 11:15: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 | 672167 | 45303 | Hammond | 04:00:00 | 04:30:00 |  | [NAME] | 160
08:00:00 |  |  |  |  |  |  | [NAME] | 100
09:00:00 |  |  |  |  |  |  | [NAME] | 49 |  | 09:30:00 | 09:45:00
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 | 45304 | Hammond | 04:18:00 | 04:40:00 |  | [NAME] | 185
08:00:00 |  |  |  |  |  |  | [NAME] | 148
09:00:00 |  |  |  |  |  |  | [NAME] | 95
10:00:00 |  |  |  |  |  |  | [NAME] | 25 |  | 10:45:00 | 11: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 | 21344 | 45305 | Hammond | 04:01:00 | 04:41:00 |  | [NAME] | 170
08:00:00 |  |  |  |  |  |  | [NAME] | 100
09:00:00 |  |  |  |  |  |  | [NAME] | 50
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:45: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 | 34084 | 45306 | Hammond | 04:00:00 | 04:25:00 |  | [NAME] | 138
08:00:00 |  |  |  |  |  |  | [NAME] | 83
09:00:00 |  |  |  |  |  |  | [NAME] | 31
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:55:00 | 10:05:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00