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

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 | 42101 | Hammond | 03:50:00 | 04:06:00 |  | 574 | 213 |  |  |  |  | 525 |  |  |  |  |  | 434
08:00:00 |  |  |  |  |  |  |  | 170
09:00:00 |  |  |  |  |  |  |  | 111
10:00:00 |  |  |  |  |  |  |  | 53
11:00:00 |  |  |  |  |  |  |  |  |  | 10:50:00 | 11:51:00 |  |  | 13 |  | 13:55: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 | 21052 | 42102 | Hammond | 03:35:00 | 04:00:00 |  | [NAME] | 162
08:00:00 |  |  |  |  |  |  | [NAME] | 102
09:00:00 |  |  |  |  |  |  | [NAME] | 50
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 10:00: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 | 32804 | 42103 | Hammond | 03:00:00 | 04:36:00 |  | [NAME] | 140
08:00:00 |  |  |  |  |  |  | [NAME] | 115
09:00:00 |  |  |  |  |  |  | [NAME] | 58
10:00:00 |  |  |  |  |  |  | [NAME] | 10 |  | 10:30:00 | 10:45:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15: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 | 42104 | Hammond | 03:00:00 | 04:30:00 |  | [NAME] | 247
08:00:00 |  |  |  |  |  |  | [NAME] | 247
09:00:00 |  |  |  |  |  |  | [NAME] | 215
10:00:00 |  |  |  |  |  |  | [NAME] | 162
11:00:00 |  |  |  |  |  |  | [NAME] | 115
12:00:00 |  |  |  |  |  |  | [NAME] | 44 |  | 13:00:00 | 13: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 | L173 | 42105 | Hammond | 02:30:00 | 04:02:00 |  | [NAME] | 139
08:00:00 |  |  |  |  |  |  | [NAME] | 96
09:00:00 |  |  |  |  |  |  | [NAME] | 17
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 | 21324 | 42106 | Hammond | 03:00:00 | 05:12:00 |  | [NAME] | 194
08:00:00 |  |  |  |  |  |  | [NAME] | 153
09:00:00 |  |  |  |  |  |  | [NAME] | 82
10:00:00 |  |  |  |  |  |  | [NAME] | 25
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00