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

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 | 21858 | 43101 | Hammond | 03:30:00 | 06:45:00 |  | 553 | 340 |  |  |  |  | 456 |  |  |  |  |  | 428
08:00:00 |  |  |  |  |  |  |  | 285
09:00:00 |  |  |  |  |  |  |  | 263
10:00:00 |  |  |  |  |  |  |  | 204
11:00:00 |  |  |  |  |  |  |  | 141
12:00:00 |  |  |  |  |  |  |  | 75
13:00:00 |  |  |  |  |  |  |  | 32 |  | 14:10:00 | 15:20:00 |  |  |  |  | 16:15: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 | 2384 | 43102 | Hammond | 03:30:00 | 04:13:00 |  | [NAME] | 168
08:00:00 |  |  |  |  |  |  | [NAME] | 99
09:00:00 |  |  |  |  |  |  | [NAME] | 66
10:00:00 |  |  |  |  |  |  | [NAME] | 8 |  | 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 | 20941 | 43103 | Hammond | 03:45:00 | 04:06:00 |  | [NAME] | 129
08:00:00 |  |  |  |  |  |  | [NAME] | 62
09:00:00 |  |  |  |  |  |  | [NAME] | 50
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:15:00 | 09:45: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 | 21437 | 43104 | Hammond | 05:30:00 | 07:00:00 |  | [NAME] | 321
08:00:00 |  |  |  |  |  |  | [NAME] | 250
09:00:00 |  |  |  |  |  |  | [NAME] | 200
10:00:00 |  |  |  |  |  |  | [NAME] | 135
11:00:00 |  |  |  |  |  |  | [NAME] | 84
12:00:00 |  |  |  |  |  |  | [NAME] | 17 |  | 12:45:00 | 13: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 | 21634 | 43105 | Hammond | 03:00:00 | 04:55:00 |  | [NAME] | 137
08:00:00 |  |  |  |  |  |  | [NAME] | 53
09:00:00 |  |  |  |  |  |  | [NAME] | 20
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:20:00 | 09:45: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 | 21512 | 43106 | Hammond | 04:27:00 | 04:45:00 |  | [NAME] | 225
08:00:00 |  |  |  |  |  |  | [NAME] | 180
09:00:00 |  |  |  |  |  |  | [NAME] | 130
10:00:00 |  |  |  |  |  |  | [NAME] | 58
11:00:00 |  |  |  |  |  |  | [NAME] |  |  | 10:55:00 | 11:15:00
12:00:00
13:00:00