Spreadsheet: 329476d1404317853-adding-indirect-formula-to-a-countif-es3-cs-wholesale-load-tracking-report-test
Sheet: 5-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 | 32537 | 45501 | Hammond | 03:30:00 | 04:30:00 |  | 442 | 260 |  |  |  |  | 574
08:00:00 |  |  |  |  |  |  |  | 190
09:00:00 |  |  |  |  |  |  |  | 99
10:00:00 |  |  |  |  |  |  |  | 47
11:00:00 |  |  |  |  |  |  |  | 45
12:00:00 |  |  |  |  |  |  |  | 15
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 |  | 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 | 2429 | 45502 | Hammond | 03:00:00 | 04:25:00 |  | 434 | 300 |  |  |  |  | 525
08:00:00 |  |  |  |  |  |  |  | 240
09:00:00 |  |  |  |  |  |  |  | 189
10:00:00 |  |  |  |  |  |  |  | 132
11:00:00 |  |  |  |  |  |  |  | 79
12:00:00 |  |  |  |  |  |  |  | 7
13:00:00 |  |  |  |  |  |  |  |  |  | 12:55:00 | 13:30:00 |  |  |  | 14:30: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 | 21366 | 45503 | Hammond | 03:30:00 | 04:15:00 |  | 456 | 210 |  |  |  |  | 435
08:00:00 |  |  |  |  |  |  |  | 180
09:00:00 |  |  |  |  |  |  |  | 100
10:00:00 |  |  |  |  |  |  |  | 84
11:00:00 |  |  |  |  |  |  |  | 45
12:00:00 |  |  |  |  |  |  |  | 5
13:00:00 |  |  |  |  |  |  |  |  |  | 15:00:00 | 16: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 | 629814 | 45504 | Hammond | 03:56:00 | 04:21:00 |  | 500 | 210 |  |  |  |  | 442
08:00:00 |  |  |  |  |  |  |  | 149
09:00:00 |  |  |  |  |  |  |  | 101
10:00:00 |  |  |  |  |  |  |  | 61
11:00:00 |  |  |  |  |  |  |  | 10 |  | 11:14:00
12:00:00 |  |  |  |  |  |  |  |  |  |  | 12:23:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 13: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 | 91128 | 45505 | Hammond | 04:00:00 | 04:25:00 |  | 429 | 320 |  |  |  |  | 434
08:00:00 |  |  |  |  |  |  |  | 275
09:00:00 |  |  |  |  |  |  |  | 187
10:00:00 |  |  |  |  |  |  |  | 140
11:00:00 |  |  |  |  |  |  |  | 116
12:00:00
13:00:00 |  |  |  |  |  |  |  |  |  | 13:30:00 | 14:22:00 |  |  |  |  | 14:52:00 | 15: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 | 45506 | Hammond | 03:00:00 | 05:29:00 |  | 479 | 210 |  |  |  |  | 458
08:00:00 |  |  |  |  |  |  |  | 175
09:00:00 |  |  |  |  |  |  |  | 74
10:00:00 |  |  |  |  |  |  |  | 50
11:00:00 |  |  |  |  |  |  |  | 20 |  | 11:21:00 | 11:59:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 62
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:56:00 | 14:35: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 | 21886 | 45507 | Hammond | 02:00:00 | 06:26:00 |  | 526 | 300
08:00:00 |  |  |  |  |  |  |  | 225
09:00:00 |  |  |  |  |  |  |  | 106
10:00:00 |  |  |  |  |  |  |  | 110
11:00:00 |  |  |  |  |  |  |  | 58
12:00:00 |  |  |  |  |  |  |  | 5
13:00:00 |  |  |  |  |  |  |  | 10 |  | 15:25:00 | 16: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 | 21445 | 45508 | Hammond | 03:42:00 | 04:16:00 |  | 528 | 155
08:00:00 |  |  |  |  |  |  |  | 123
09:00:00 |  |  |  |  |  |  |  | 15
10:00:00 |  |  |  |  |  |  |  |  |  | 09:48:00 | 11:30:00
11:00: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 | L325 | 45509 | Hammond | 03:42:00 | 04:22:00 |  | 496 | 225
08:00:00 |  |  |  |  |  |  |  | 150
09:00:00 |  |  |  |  |  |  |  | 85
10:00:00 |  |  |  |  |  |  |  | 41
11:00:00 |  |  |  |  |  |  |  | 5
12:00:00 |  |  |  |  |  |  |  |  |  | 11:32:00
13:00:00 |  |  |  |  |  |  |  |  |  |  | 13:15:00